Re: globally unique ID

Поиск
Список
Период
Сортировка
От Marin Dimitrov
Тема Re: globally unique ID
Дата
Msg-id 002b01c1ce92$f8dcc6d0$9b0e32d4@sirma.bg
обсуждение исходный текст
Ответ на Re: globally unique ID  ("Dave Cramer" <Dave@micro-automation.net>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: Re: globally unique ID
Следующее
От: Peter V Cooper
Дата:
Сообщение: Re: Scrolling through cursors