From: | "Paulo Parola" <pparola(at)brazilinfo(dot)com> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | BLOBS and PostgreSQL |
Date: | 1999-08-25 15:21:51 |
Message-ID: | 002501beef0f$641813c0$0300000a@cpqivx-2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I need to create a table to store images (BLOBs - binary large objects) in
PostgreSQL as I would do in MySQL like below:
create table images (
id INT NOT NULL PRIMARY KEY,
image BLOB
);
MySQL has actually 4 different types for a BLOB, as below:
TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8
BLOB, TEXT L+2 bytes, where L < 2^16
MEDIUMBLOB, MEDIUMTEXT L+3 bytes, where L < 2^24
LONGBLOB, LONGTEXT L+4 bytes, where L < 2^32
Which types in PostgreSQL should I use for this purpose (storing BLOBs)?
text? varchar(n)? Documentation for PostgreSQL is unfortunately really poor
if compared to MySQL...
TIA,
Paulo
From | Date | Subject | |
---|---|---|---|
Next Message | Jens Felber | 1999-08-25 15:39:49 | Re: [GENERAL] changing between 6.4.1 and 6.5 |
Previous Message | Jeff MacDonald <jeff@pgsql.com> | 1999-08-25 12:42:14 | Re: [GENERAL] PostgreSQL, Inc Site Redone ... |