CODEWITHSUNDEEP
stringpostgresqlescaping
user6574649
user6574649

Reputation:

Escape all single quotes in postgresql

Instead of escaping each ' in text, is there any way to escape them all at once, something like this:

insert into table1(data) values(@'it's a string, it's got some single quotes')

Upvotes: 6

Views: 10223

Answers (1)

Clodoaldo Neto
Clodoaldo Neto

Reputation: 125204

insert into table1(data) values
($$it's a string, it's got some single quotes$$)

Dollar quoting

A dollar-quoted string constant consists of a dollar sign ($), an optional "tag" of zero or more characters, another dollar sign, an arbitrary sequence of characters that makes up the string content, a dollar sign, the same tag that began this dollar quote, and a dollar sign

Upvotes: 15

Related Questions