| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Import SVG file |
| Date: | 2005-02-01 17:33:16 |
| Message-ID: | 20050201173316.GA6585@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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[(at)]dcc(dot)uchile(dot)cl>)
"World domination is proceeding according to plan" (Andrew Morton)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Si Chen | 2005-02-01 18:53:11 | Re: how to release a transaction lock on a table? |
| Previous Message | Phil Endecott | 2005-02-01 16:48:10 | Re: Import SVG file |