sequence - Mailing list pgsql-novice

From Robert Morgan
Subject sequence
Date
Msg-id 40B11BE5.30806@ihug.co.nz
Whole thread Raw
Responses Re: sequence
List pgsql-novice
Is it possible to change an existing field to a sequence?

I have a field that contains ID numbers and I want this field to
autoincrement evrytime a new row is inserted.

The existing field is int8, (this database has been imported to
Postgresql using DBTools import wizard.)
Do I need to drop the existing column and create a new one using create
sequence.....?
and then I can use the nextval() in the insert query?

thanks
Bob





pgsql-novice by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: New from mssql. Help please
Next
From:
Date:
Subject: phppgadmin on Debian/unstable (sort of)