| From: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org> |
|---|---|
| To: | "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu> |
| Cc: | "Postgres (General)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Does Postgres support BLOB datatypes? |
| Date: | 2002-01-08 20:20:39 |
| Message-ID: | Pine.LNX.4.33.0201081420001.23879-100000@morannon.the-infinite.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Cunningham | 2002-01-08 20:23:52 | Re: [SQL] Need help |
| Previous Message | Tom Lane | 2002-01-08 20:18:17 | Re: plpgsql |