Re: Returning bytea* from a C function - Mailing list pgsql-general

From Joe Conway
Subject Re: Returning bytea* from a C function
Date
Msg-id 3D2B111F.5090506@joeconway.com
Whole thread Raw
In response to Returning bytea* from a C function  (David Busby <busby@pnts.com>)
List pgsql-general
David Busby wrote:
> List,
>     I'm trying to build a function for PostgreSQL that allows me to
> create a new UUID for data in my datbase.  Has anyone had experience
> with this one?  I was going to store it as a bytea datatype, would a
> char(32) be better?  Any Ideas?
>

If your table will be very large, using bytea will save a fair amount of
space. Other possibilities are to encode the data into base64 or hex and
store in a TEXT (or VARCHAR or CHAR()) field.

Joe



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: I am being interviewed by OReilly
Next
From: Robert L Mathews
Date:
Subject: Re: Query Casting Help