Postgres Pro
Downloads
Home   >   mailing lists

Thread: globally unique ID

globally unique ID

From
"Marin Dimitrov"
Date:
Hi,

is there a way to generate a GUID from Postgres?

I'm looking for something similar to sys_guid() in Oracle

thanx,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

Re: globally unique ID

From
"Dave Cramer"
Date:
Not knowing oracle at all, could you be more specific?

Dave

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Marin Dimitrov
> Sent: Monday, March 18, 2002 9:59 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] globally unique ID
>
>
>
> Hi,
>
> is there a way to generate a GUID from Postgres?
>
> I'm looking for something similar to sys_guid() in Oracle
>
> thanx,
>
>     Marin
>
> ----
> "...what you brought from your past, is of no use in your
> present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a
> little of the
> old life, end up torn apart by their own memories. "
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org

Re: globally unique ID

From
"Marin Dimitrov"
Date:
----- Original Message -----
From: "Dave Cramer" <Dave@micro-automation.net>


> Not knowing oracle at all, could you be more specific?
>

yes, I need a way to generate a globally unique number that will identify
one database from another one

in Oracle, calling sys_guid() will return 16-byte unique number which is
globally unique

this is from the Oracle docs: "On most platforms, the generated identifier
consists of a host identifier and a process or thread identifier of the
process or thread invoking the function, and a nonrepeating value (sequence
of bytes) for that process or thread"

is there an equivalent in Postgres?

thanx,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "