Michael,
> michael=# insert into healthnotes (notes) values ('mytext....');
> michael'#
>
> changes the prompt accordingly and doesn't commit the change..what am I
> doing wrong? I'm certain this code works, as I've done something
> similar via dbVis
You're failing to close a set of single quotes. Look for, for example, an
un-escaped apostrophe.
--
-Josh Berkus
Aglio Database Solutions
San Francisco