Re: basic question

You most likely have a ' in the mytext.  You need to escape it using \'.

i.e.
insert into healthnotes (notes) values ('some test\'s');

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Michael Hanna
> Sent: Thursday, June 26, 2003 3:54 PM
> Cc: pgsql-novice
> Subject: [NOVICE] basic question
> 
> 
> in psql 7.3.3, press enter after a semi-colon
> 
> 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
> 
> Michael
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>