Re: Unique UUID value - PostgreSQL 9.2

[James Keener <jim@xxxxxxxxxxxxx>]

Is a uuid a valid value in the application making use of the data? Why can't you add the column to table b and then import, or use create the uuid in the import select clause? I'm also having trouble understanding the problem and why you've discounted the options you've not even told us you've considered.

On March 14, 2016 5:37:00 PM EDT, "drum.lucas@xxxxxxxxx" <drum.lucas@xxxxxxxxx> wrote:

On 15 March 2016 at 10:29, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Mon, Mar 14, 2016 at 2:13 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> wrote:

Hi all,

 

favorite

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?

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.