Unique UUID value - PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Unique UUID value - PostgreSQL 9.2
Date: 2016-03-14 21:13:15
Message-ID: CAE_gQfXMJWTMpQCSwzifDGDc22_NAuG9WF2bBNvmjrvEEAkVqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

down votefavorite
<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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dustin Kempter 2016-03-14 21:17:14 BDR
Previous Message Chris Mair 2016-03-14 20:45:02 Re: Unexpected result using floor() function