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?