On 15 March 2016 at 10:29, David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Mon, Mar 14, 2016 at 2:13 PM, drum.lu...@gmail.com < > drum.lu...@gmail.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?
