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