Thread: GenGUID (AutoNumber) in postgres
I have a database that was migrated from Access. I am having trouble porting "AutoNumber" datatype. The column that is oftype "AutoNumber" is suppose to Unique ID (PK) for that table. Internally it uses GenGUID API in access to generate theunique ID.<br /><br />Any ideas on how to port this functionality to Postgres. <br /><br />Thanks<br /><br /><br /><br/>
On Fri, Jun 13, 2008 at 1:48 PM, Premil Agarwal <preagarw@gmail.com> wrote: > I have a database that was migrated from Access. I am having trouble porting > "AutoNumber" datatype. The column that is of type "AutoNumber" is suppose to > Unique ID (PK) for that table. Internally it uses GenGUID API in access to > generate the unique ID. > > Any ideas on how to port this functionality to Postgres. I don't use Access, but you might want to look at the documentation about "serial" data type. Sean