Some questions about oid's and sequences. - Mailing list pgsql-general

From Erik Norvelle
Subject Some questions about oid's and sequences.
Date
Msg-id 35ECCC67.E6750196@uswest.net
Whole thread Raw
List pgsql-general
Howdy:

I am coming from the Windows world, and Microsoft SQL variants in
particular.  Both Access and SQL Server have autoincrement data types --
I understand that Postgresql has "sequences" which do the same thing,
but I can't find any documentation on them.  I have browsed all the
online documentation that comes with Postgresql, and can't find anything
about it.  Could someone point me to some docs that would explain how to
use sequences?

I have a similar question about oid's.  I am not sure what they are --
from their name, I would guess that they are autoassigned, unique
identifiers for each row in a table.  Is that correct?  If so (or even
if not), how do I create and use them.  Any documentation that addresses
oid usage specifically?  I am confused because oid's seem to be to
substitute for the BLOB data type which is available in other RDBMS's.

If you post a reply to this, could you also cc: to
enorvelle1@uswest.net.  TKA for your assistance.

-Erik Norvelle

Attachment

pgsql-general by date:

Previous
From: "R.Stevens"
Date:
Subject: C++ / pgsql Interface
Next
From: claudio navarro
Date:
Subject: SET LOCK MODE ?