| From: | Peter Mount <pgsqlgen(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Brian <signal(at)shreve(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] datatype questions |
| Date: | 1998-06-23 18:21:59 |
| Message-ID: | Pine.LNX.3.95.980623191546.3330A-100000@retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Carobus | 1998-06-23 19:54:39 | problem with floats |
| Previous Message | Patrice Hédé | 1998-06-23 16:41:25 | Re: [GENERAL] Q: How to convert int to date? |