Re: Unique UUID value - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Unique UUID value - PostgreSQL 9.2
Дата
Msg-id CAKFQuwYSqBy6kxWCv=ZDHvXR+LUWWHR3URr=QdKgOdU9BZSBSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Unique UUID value - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Ответы Re: Unique UUID value - PostgreSQL 9.2
Список pgsql-general
Дерево обсуждения
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 по дате отправления: