Skip site navigation (1) Skip section navigation (2)

Re: GUID function in pgsql?

From: Norberto Meijome <sys(at)meijome(dot)net>
To: me(at)alternize(dot)com
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-novice(at)postgresql(dot)org
Subject: Re: GUID function in pgsql?
Date: 2005-12-15 11:51:14
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
me(at)alternize(dot)com wrote:

>> 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.
> normally i would use serials, of course. but not when the tools expect 
> a guid (i.e. something like 'a4180365-b4b5-4013-bd7b-7b6a386eb343'). 
> and as i'm only in control of the DBMS and not the tools itself, i 
> will need a guid somehow...
Bruno's advise is still valid. If you google around a bit, you'll across 
explanations like the one in

on how MS-GUIDs are created. If fitting to your GUID-loving-app is the 
key here, you can easily write a function in C or other language that 
when called it returns a GUID in the exact format you need.
Somethign like
substr(random(n,m,sha1(rand(ms_since_epoch())))-[unique ID generated 
from your MAC address]

or something like that - you get the picture.

In response to


pgsql-novice by date

Next:From: Oliver ElphickDate: 2005-12-15 11:52:01
Subject: Re: client-server connection
Previous:From: meDate: 2005-12-15 11:10:58
Subject: Re: GUID function in pgsql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group