Re: [GENERAL] datatype questions

On Mon, 22 Jun 1998, Brian wrote:

> I am trying to convert a table into PostgresSQL from MySQL, and had a few
> questions:

[snip]

> 2. Does postgres support anything even like a "blob" data type?

yes and no. I posted an experimental blob type (actually its lo) just over
a week ago, and it should be in the src/contrib/lo directory of the CVS
source. This handles (in part) orphaning of large objects, which is a
problem with ODBC & JDBC.

Other than that, in postgres, we use oid as the type, which then refers to
a large object.

> 3. Does Postgres support something like "auto_increment".

We have sequences which provide this facility.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk