postgresql escaped quotes still escaped in DB

Question

Just had to import some data in my postgreSQL db with sometimes single quote escapes. Everything is fine, but at the end I still have my '' escapes in my DB values.

before import : L'Auberge D'Aillane

after import (when I do a "SELECT name from mytable") : L''Auberge D''Aillane

is that normal ? is there any way to have to right value in the entries ?

thanks a lot

score 0 · Answer 1 · edited May 23 '17 at 11:52

0

You can find a detailed answer here: Insert text with single quotes in PostgreSQL

But as quick response use the backslash escape instead of double quotes: In old versions or if you still run with standard_conforming_strings = off or, generally, if you prepend your string with E to declare Posix escape string syntax, you can also escape with the backslash :

E'user\'s log'

edited May 23 '17 at 11:52

Community

1
1

answered May 16 '16 at 11:09

Rabih El Khatib

61
3

i'm in psql 9.4.5 so double quotes escaping should be running well, no ? i don't want to user E escape as it's not supported no and standard_conforming_strings should be on. – Alex Pereira May 16 '16 at 11:12

score 0 · Answer 2 · answered May 16 '16 at 14:03

As you logged your question here also: https://github.com/brianc/node-postgres/issues/1020

The answer is the very same:

as you see I use the double-quote escape to avoid any insertion error

You shouldn't be doing that ever! The node-postgres library's internal formatting provides the correct escaping for strings as well as all the other JavaScript types.

postgresql escaped quotes still escaped in DB

2 Answers2