Re: GUIDs - Mailing list pgsql-general

From Doug McNaught
Subject Re: GUIDs
Date
Msg-id 87ekw9s1xs.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: GUIDs  (David Wheeler <david@kineticode.com>)
Responses Re: GUIDs
List pgsql-general
David Wheeler <david@kineticode.com> writes:

> I can store them as a string in Perl, but the trick is getting the
> string representation in the first place. The library I was looking at
> using Data::UUID, offers binary and hex representations, as well as a
> 32 bit alphanumeric string and a Base64-encoded string, but not a
> numeric string, unfortunately.

I think if I were in your place, I'd store them as TEXT fields using
either the base64 or hex representation.

-Doug

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: UPGRADING 7.1 TO 7.3.4
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Conservation of OIDs