On Tue, Feb 01, 2005 at 04:48:10PM +, 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 la
Hi Miguel,
> how can I import a SVG file to a row?? The main problem is
> that it has many postgres scape symbols. Can I use the
> 'text' type for that?
I would probably choose to use 'bytea' rather than 'text' because of the
character set issues. The SVG, being XML, describes its own character
Miguel Angel Tribaldos Hervas wrote:
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 correc
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.
--
I want to do the import from the psql client. ... Something like that:
--
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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 a
