Re: Does Postgres support BLOB datatypes?

Hello,

Yes PostgreSQL supports BLOBS. You are looking for \loimport within psql
client.

J

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

> Hey All,
>
> 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?
>
> Thanks for any help,
> Peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
--
by way of pgsql-general(at)commandprompt(dot)com
http://www.postgresql.info/
http://www.commandprompt.com/