From: | Miguel Angel Tribaldos Hervas <mitriher(at)teleco(dot)upv(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Import SVG file |
Date: | 2005-01-28 10:26:31 |
Message-ID: | 1106907991.41fa13573ccbe@webmail.upv.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I want to do the import from the psql client. I try to find something like that:
INSERT INTO "controller" (notes, enabled, diagram, ...)
VALUES ('Example controller', TRUE, load_svg('controller.svg'), ...)
with diagram of type TEXT, and diagram field correctly escaped.
Best regards.
--
Miguel A. Tribaldos
>Miguel Angel Tribaldos Hervas wrote:
>> Hi,
>>
>> how can I import a SVG file to a row?? The main problem is that it has many
>> postgres scape symbols. Can I utilize the
>> 'text' type for that?
>> Have I to do some byte-stuffing before the import?
>If you want to create a text-file with a COPY or INSERT statement and
>then use psql -f ... you'll need to perform the usual escaping. If
>you're going via Perl's DBI or similar you can let it handle those
>details for you. Do you have a client system in mind?
From | Date | Subject | |
---|---|---|---|
Next Message | sid tow | 2005-01-28 11:36:40 | How to get back the current count of a auto incrementing number. |
Previous Message | Miguel Angel Tribaldos Hervas | 2005-01-28 10:20:06 | Re: Import SVG file |