On Thu, 3 May 2001, Terry Fielder wrote:
> Is there an autonumber data type in postgreSQL?
>
If you mean a type that it is automatically incremented then yes SERIAL.
Actually serial isn't a datatype. It is an integer column with
a default value that is the next number of a sequence that is
automatically created.
CREATE TABLE foo (
bar1 SERIAL,
bar2 text
);
INSERT INTO foo (bar2) VALUES ('text value');
INSERT INTO foo (bar2) VALUES ('text value2');
and the bar1 gets an automatic value.
- Einar Karttunen