Re: Import SVG file

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
set in its header. If you have an 8859-1 database and then import a
UTF-8 SVG file into a text field you will have unnecessary problems.
bytea is just a sequence of bytes.

The main disadvantage of bytea is that you can't do regular expression
searches on them.

> 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.

Regards,

--Phil Endecott.