Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id F2A58632BF6
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jul 2010 09:38:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 71874-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jul 2010 12:38:12 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mh4.mail.rice.edu (mh4.mail.rice.edu [128.42.199.11])
	by mail.postgresql.org (Postfix) with ESMTP id D45CF63282E
	for <pgsql-sql@postgresql.org>; Wed, 21 Jul 2010 09:38:12 -0300 (ADT)
Received: from mh4.mail.rice.edu (localhost.localdomain [127.0.0.1])
	by mh4.mail.rice.edu (Postfix) with ESMTP id A70AB370002;
	Wed, 21 Jul 2010 07:38:10 -0500 (CDT)
X-Virus-Scanned: by amavis-2.6.0 at mh4.mail.rice.edu
Received: from mh4.mail.rice.edu ([127.0.0.1])
	by mh4.mail.rice.edu (mh4.mail.rice.edu [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id BLmHrATDUyuP; Wed, 21 Jul 2010 07:38:10 -0500 (CDT)
Received: from aart.is.rice.edu (aart.is.rice.edu [168.7.56.48])
	by mh4.mail.rice.edu (Postfix) with ESMTP id 78044370007;
	Wed, 21 Jul 2010 07:38:10 -0500 (CDT)
Received: by aart.is.rice.edu (Postfix, from userid 18612)
	id 8C2CD2D5A6; Wed, 21 Jul 2010 07:38:09 -0500 (CDT)
Date: Wed, 21 Jul 2010 07:38:08 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Trinath Somanchi <trinath.somanchi@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: UUID for Postgresql 8.4
Message-ID: <20100721123808.GH27203@aart.is.rice.edu>
References: <AANLkTimGOZtxkCTX9Nc-1DC3GQRYLNWa8mE4l4P54Mi8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <AANLkTimGOZtxkCTX9Nc-1DC3GQRYLNWa8mE4l4P54Mi8@mail.gmail.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.21 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/86
X-Sequence-Number: 34399

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