Re: Unique UUID value - PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>, James Keener <jim(at)jimkeener(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unique UUID value - PostgreSQL 9.2
Date: 2016-03-15 21:01:02
Message-ID: CAE_gQfVP=ioudnCHK48t0NbZMP=P4QGQxfVUw83G2NE278uKBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
>>
> Not reading the documentation for functions you've never heard of makes
> the list.
>
> David J.
>

INSERT INTO junk.test1 (account_id, code, info)SELECT account_id,
uuid_generate_v4(), infoFROM junk.test2;

It works but I get data like:

abc77f31-0ee6-44fd-b954-08a3a3aa7b28
f307fb42-23e5-4742-ab8f-8ce5c0a8e852

*Is it possible to do the same, but with TEXT on the beginning?*

Example:

test_32152563bdc4db11aa

test_321525694417ad6b5f

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-03-15 21:30:29 Re: Unique UUID value - PostgreSQL 9.2
Previous Message rob stone 2016-03-15 17:59:26 Re: pg_dump crashing