Bob Pawley wrote:
I have numerous entries in a column of table 1, some of which are
duplicated.
I need to transfer this information to table 2 so that I have column
that can be used as a primery key.
Any help is appreciated.
So, I take it you're wanting to have this so that table 1 stays as it
is, and table 2 gets the entries from table 1 made unique, and becomes
the parent of table 1?
If that's the case, you want something like this:
create table2 as select distinct idcolumn from table1;
alter table2 add primary key (idcolumn);
alter table1 add foreign key (idcolumn) references table2(idcolumn);
I think that's about right.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
