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(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)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(at)postgresql(dot)org)
>