| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | me(at)alternize(dot)com |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: GUID function in pgsql? |
| Date: | 2005-12-15 06:10:51 |
| Message-ID: | 20051215061051.GA16519@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Dec 15, 2005 at 05:59:30 +0100,
me(at)alternize(dot)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 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
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghunandan Bapuram | 2005-12-15 07:13:19 | Regarding retrieving a bytea datatype using embedded SQL |
| Previous Message | mallikarjun.revgond | 2005-12-15 04:59:34 | how to pass the password value in single statement. |