Re: Unique UUID value - PostgreSQL 9.2

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 3/15/2016 2:48 PM, drum.lucas@xxxxxxxxx wrote:

It's already working:

INSERT INTO junk.wm_260_billables2 (account_id, code, info)
SELECT account_id, 'test_' || uuid_generate_v4(), info
FROM junk.wm_260_billables1;

BUT.. I'm getting a very long UUID - Would like some smaller

test_ea8bacbe-fa3c-4072-b511-643a56feb40e

that would be a v4 uuid, like you asked for in the above code.

test=# select uuid_generate_v4();  
           uuid_generate_v4          
--------------------------------------
 09b24e5b-5116-435e-94b9-f0da4661f594

afaik, all UUID's are 128 bit numbers expressed in hexadecimal in that format.   This is an ISO standard.

-- 
john r pierce, recycling bits in santa cruz