Thread: GenGUID (AutoNumber) in postgres

GenGUID (AutoNumber) in postgres

From
"Premil Agarwal"
Date:
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/> 

Re: GenGUID (AutoNumber) in postgres

From
"Sean Davis"
Date:
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