Re: Does Postgres support BLOB datatypes?

On Tue, 8 Jan 2002, Peter E. Chen wrote:

> I just migrated a MySQL database to Postgres.  I used the mysql2pgsql
> application to convert my MySQL data into Postgres-friendly data.  The BLOB
> data I had in the MySQL database converted into the text datatype for
> postgres.  I'd like to know if Postgres supports BLOBs and if not, what
> datatype should I use in place of BLOBs?

If it's a BLOB of text, the use text.

If it's binary data, you can either use bytea - or PG's LO (Large Object)
interface...


--
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/