Re: UUID for Postgresql 8.4 - Mailing list pgsql-sql

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