| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | Trinath Somanchi <trinath(dot)somanchi(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: UUID for Postgresql 8.4 |
| Date: | 2010-07-21 12:38:08 |
| Message-ID: | 20100721123808.GH27203@aart.is.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wes Devauld | 2010-07-22 06:37:04 | Aggregates (last/first) not behaving |
| Previous Message | MIkhail Puzanov | 2010-07-21 12:37:18 | Re: UUID for Postgresql 8.4 |