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 <seil...@so-net.net.tw>: > 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 > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
