String literals and escape characters in postgresql
Posted
by rjohnston
on Stack Overflow
See other posts from Stack Overflow
or by rjohnston
Published on 2008-08-04T01:00:24Z
Indexed on
2010/04/30
14:17 UTC
Read the original article
Hit count: 177
Filed under:
postgresql
Attempting to insert an escape character into a table results in a warning. For example:
create table EscapeTest (text varchar(50));
insert into EscapeTest (text) values ('This is the first part \n And this is the second');
Produces the warning:
WARNING: nonstandard use of escape in a string literal
(Using PSQL 8.2)
Anyone know how to get around this?
© Stack Overflow or respective owner
