BLOBS and PostgreSQL

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

Browse pgsql-general by date

  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 ...