On Thu, Dec 15, 2005 at 05:59:30 +0100,
me@alternize.com wrote:
> hi list
>
> i'm looking for a GUID function in pgsql to ease migration from mssql. several tools rely on a primary key that
consistsof a guid column. unfortunately, pgsql does not seem to provide such a datatype, and much worse i wasn't even
ableto find a similar pgsql function that generates a GUID.
>
> the list archives found some discussions about how a guid could be implemented - unfortunately without giving a final
solution.is there really no GUID creation function? if so, could it be requested for a (hopefully not so future) pgsql
release?
>
> - thomas
Normally you want to use sequences to do this. If you need something more
global you could combine this with some unique ID for your database.