Inserting exported bytea value
I am trying to build SQL commands that insert values exported from a bytea column. Output facilities do not escape single quotes for bytea column. As such, the built INSERT SQL can be invalid because single quotes can appear in values. For example, the built (invalid) INSERT SQL command can look like this:
INSERT INTO t1 VALUES ('ABC\\000C'DE');
Note the apostrophe between C and D.
Are there straight approaches to do this job using version 8.x?
Does the bytea hex export feature provided by version 9 help solve this problem?
Thank you in advance!
CN
Hello
why you don't use PQescapeBytea function ?
http://www.postgresql.org/docs/8.4/interactive/libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA
Regards
Pavel Stehule
2010/2/11 <seiliki@so-net.net.tw>:
Show quoted text
I am trying to build SQL commands that insert values exported from a bytea column. Output facilities do not escape single quotes for bytea column. As such, the built INSERT SQL can be invalid because single quotes can appear in values. For example, the built (invalid) INSERT SQL command can look like this:
INSERT INTO t1 VALUES ('ABC\\000C'DE');
Note the apostrophe between C and D.
Are there straight approaches to do this job using version 8.x?
Does the bytea hex export feature provided by version 9 help solve this problem?Thank you in advance!
CN
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general