Re: GUIDs - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: GUIDs
Date
Msg-id Pine.LNX.4.44.0311140203570.17499-100000@peter.localdomain
Whole thread Raw
In response to GUIDs  (David Wheeler <david@kineticode.com>)
Responses Re: GUIDs  (David Wheeler <david@kineticode.com>)
List pgsql-general
David Wheeler writes:

> It looks like the hex option would be the best option, but there's no
> native hex format in PostgreSQL. Anyone have suggestions on what the
> best approach might be? I can't convert it to a number, really, because
> 128 bit numbers aren't too portable).

Use bytea.  It stores bytes and allows the conversion into several output
formats.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: GUIDs
Next
From: David Wheeler
Date:
Subject: Re: GUIDs