Re: Problem with apostrophes in TK frontend
Chris <linux.fellow@libertysurf.fr>
From: Chris <linux.fellow@libertysurf.fr>
To: hramrach@centrum.cz
Cc: pgsql-bugs@postgresql.org
Date: 2000-12-21T18:31:50Z
Lists: pgsql-bugs
> insert into "tab1" ("taet","text","text2","id") values ('skldgj 'dgk dlf','dgsdfkl gh ;sdfgh
> dlfkgh','dfl;sj gkl;j','456464654')
>
> ERROR: parser: parse error at or near "dgk"
>
Of course it is not correctly quoted. If you want to insert a quote in the
string, just put it twice.
insert into "tab1" ("taet","text","text2","id") values ('skldgj ''dgk
dlf','dgsdfkl gh ;sdfgh
dlfkgh','dfl;sj gkl;j','456464654')
if you want to insert a backslash, it's the same :
insert into "tab1" ("text") values ('need a \\ ?');
Hope this will solve your problem.