string - 转义postgresql中的所有单引号

Question

不是转义文本中的每个 '，有没有办法一次性转义它们，像这样:

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

Answer 1

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