GUID function in pgsql?

From: <me(at)alternize(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: GUID function in pgsql?
Date: 2005-12-15 04:59:30
Message-ID: 048101c60134$55d18740$0201a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi list

i'm looking for a GUID function in pgsql to ease migration from mssql. several tools rely on a primary key that consists of a guid column. unfortunately, pgsql does not seem to provide such a datatype, and much worse i wasn't even able to 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message mallikarjun.revgond 2005-12-15 04:59:34 how to pass the password value in single statement.
Previous Message Bruno Wolff III 2005-12-15 04:37:42 Re: Sequence on a char(6) column