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/