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) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend