Re: globally unique ID

----- 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. "