Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique UUID value - PostgreSQL 9.2 - Mailing list pgsql-general

From David G. Johnston
Subject Re: Unique UUID value - PostgreSQL 9.2
Date
Msg-id CAKFQuwYSqBy6kxWCv=ZDHvXR+LUWWHR3URr=QdKgOdU9BZSBSQ@mail.gmail.com
Whole thread Raw
In response to Unique UUID value - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: Unique UUID value - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-general
Tree view
On Mon, Mar 14, 2016 at 2:13 PM, drum.lucas@gmail.com <drum.lucas@gmail.com> wrote:
Hi all,
 

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.
​

pgsql-general by date:

Previous
From: Dustin Kempter
Date:
Subject: BDR
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Unique UUID value - PostgreSQL 9.2