Re: basic question
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: Michael Hanna <zen@hwcn.org>
Cc: "pgsql-novice" <pgsql-novice@postgresql.org>
Date: 2003-06-26T20:58:49Z
Lists: pgsql-novice
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