Re: Unique UUID value - PostgreSQL 9.2

On 15 March 2016 at 10:29, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Mon, Mar 14, 2016 at 2:13 PM, drum(dot)lucas(at)gmail(dot)com <
> drum(dot)lucas(at)gmail(dot)com> wrote:
>
>> Hi all,
>>
>>
> favorite
>> <http://dba.stackexchange.com/questions/132226/unique-values-uuid-generation-postgresql-9-2#>
>>
>> I've got 2 tables:
>>
>> Temp-Table
>> Table-A
>>
>> Need to copy all the data from *Temp-Table* to *Table-A*. But there is a
>> Constraint that does not allow me to have duplicated items.
>>
>> So I need to create a Unique value.
>>
>> *Example:*
>>
>> Column Code | Column Info |
>> code_67493675936 info_2016
>>
>> *Question:*
>>
>> How can I do that using PostgreSQL 9.2?
>>
>
> You might want to try to restate the problem and question. I'm having a
> hard time trying to figure out what you want.
>
> Reading your subject line I'll point you to:
>
> http://www.postgresql.org/docs/9.2/interactive/datatype-uuid.html
>
> specifically the extension that is mentioned.
>
> ​Usually people figure out ways to accomplish their goals without using
> UUID though.
>
> David J.
> ​
>
>
I want to import data from table A to table B, but when doing it the column
"code" on table B has to have some unique random data.

I could use UUID like:
insert into "TB" ("Id", "Title") values (uuid_generate_v4(), '111');

but I'm doing:
INSERT INTO tableb (SELECT * FROM TABLEA)

So, how to use UUID using the SELECT above?