Re: globally unique ID - Mailing list pgsql-jdbc

From Marin Dimitrov
Subject Re: globally unique ID
Date
Msg-id 002b01c1ce92$f8dcc6d0$9b0e32d4@sirma.bg
Whole thread Raw
In response to Re: globally unique ID  ("Dave Cramer" <Dave@micro-automation.net>)
List pgsql-jdbc
----- 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. "




pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: globally unique ID
Next
From: Peter V Cooper
Date:
Subject: Re: Scrolling through cursors