On Tue, Feb 01, 2005 at 04:48:10PM +0000, Phil Endecott wrote:
Hi,
> > Have I to do some byte-stuffing before the import?
>
> Yes, you will have to do the necessary escaping. I think that the
> postgres C library has code to do this, and others have mentioned the
> possibilities with other languages. You cannot do it with anything
> quite as simple as the one line of psql that you posted.
If you are using C then you may as well use PQexecParams() and pass the
datum as a pointer. Then you don't need to escape anything.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"World domination is proceeding according to plan" (Andrew Morton)