Using this: Insert text with single quotes in PostgreSQL
I run on Postgres version 9.4.3 with command sql after
insert into test values (1,$$user's log$$);
Postgres returns error message
ERROR: 42601: Syntax error at or near "s"
Asked
Active
Viewed 65 times
0
-
Dollar quoting like that should work. Which tool do you use to run that statement? – Dec 15 '16 at 10:21
-
I run on Query pgAdmin III – Vu QUANG Dec 16 '16 at 03:51