Postgres Pro
Downloads
Home   >   mailing lists

Thread: UUID for Postgresql 8.4

UUID for Postgresql 8.4

From
Trinath Somanchi
Date:
Hi All,

I have a column in my Postgresql database tables which need UUID.

Is there any function in Pgsql for UUID generation. Please help me in this regard.

--
Regards,
----------------------------------------------
Trinath Somanchi,

Re: UUID for Postgresql 8.4

From
"A. Kretschmer"
Date:
In response to Trinath Somanchi :
> Hi All,
> 
> I have a column in my Postgresql database tables which need UUID.
> 
> Is there any function in Pgsql for UUID generation. Please help me in this
> regard.

http://www.postgresql.org/docs/8.4/static/uuid-ossp.html

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

Re: UUID for Postgresql 8.4

From
MIkhail Puzanov
Date:
There's contrib module for it, uuid-ossp.
It should be available as a package for most
OSes and distributions, I guess.


Hi All,

I have a column in my Postgresql database tables which need UUID.

Is there any function in Pgsql for UUID generation. Please help me in this regard.

--
Regards,
----------------------------------------------
Trinath Somanchi,

Re: UUID for Postgresql 8.4

From
Kenneth Marshall
Date:
On Wed, Jul 21, 2010 at 05:49:53PM +0530, Trinath Somanchi wrote:
> Hi All,
> 
> I have a column in my Postgresql database tables which need UUID.
> 
> Is there any function in Pgsql for UUID generation. Please help me in this
> regard.
> 
> -- 
> Regards,
> ----------------------------------------------
> Trinath Somanchi,

Check the page about the UUID type in the manual:

http://www.postgresql.org/docs/8.4/interactive/datatype-uuid.html

It contains some suggestions for generating them, including the
contrib/uuid-ossp module:

http://www.postgresql.org/docs/8.4/interactive/uuid-ossp.html

Cheers,
Ken