Mark Thomas <thomas@pbegames.com> writes:
> ... I end up with a query string that looks like:
> INSERT INTO "some_table" (ttext)
> VALUES ('This is a test of postgresql''s escaping mechanism')
That should result in inserting
This is a test of postgresql's escaping mechanism
> Subsequently I do:
> SELECT ttext from "some_table";
> This is a test of postgresql''s escaping mechanism
This is hard to believe. The returned string shouldn't have the
doubled quote. You're going to have to give more details about
what you're doing.
regards, tom lane