Re: Establishing a primary key

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.