CODEWITHSUNDEEP
postgresql
alt
alt

Reputation: 9

Postgres storing and retrieving double quotes

I am storing data which includes single and double quotes in a column which has a type of text.

I have a function that returns that column but it always returns the double quote character being doubled up. I tried to escape the character \" but that just returned \"". I have the same process working in MySQL well. I am trying to move to Postgres for greater scaling and stability but it seems it does not work well. I have noticed in pgAdmin when I look at the data output, it seems to show the data correctly so I am wondering what is being done there for it to work correctly?

Also I am getting a (" at the start of the returned value and ") at the end.

Can someone help please?

Upvotes: 0

Views: 1469

Answers (1)

David Jesus
David Jesus

Reputation: 2111

Use pg_escape_string to escape quote characters in your string.

Upvotes: 1

Related Questions