Re: Problem with apostrophes in TK frontend

Поиск
Список
Период
Сортировка
От Chris
Тема Re: Problem with apostrophes in TK frontend
Дата
Msg-id 3A424C96.B7CEF03C@libertysurf.fr
обсуждение исходный текст
Ответ на Problem with apostrophes in TK frontend  (pgsql-bugs@postgresql.org)
Список 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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgresql process crashes on select * from cmd_sm (which is a view)
Следующее
От: Chris
Дата:
Сообщение: Re: bug