Yes, here foo is a temp table. As others have pointed out, you could
probably do a create table foo as select distinct * from orig_table. I
would move the data back to orig_table, so that constraints and
privileges are maintainited. After you have done this, you can put a
uniq constraint on columns A & B. I am uncertain if you can do
something like ALTER TABLE orig_table ADD UNIQUE (A,B) ON DUPLICATE DELETE.
-Said
A B wrote:
> There is probably a more elegant way of doing it, but a simple way
of doing
> it ( depending on the size of the table ) could be:
>
> begin;
>
> insert into foo select distinct * from orig_table;
> delete from orig_table;
> insert into orig_table select * from foo;
>
> commit;
Just to make it clear to me
Here foo is a table that I have to create with the command
CREATE TABLE foo (....same columns as orig_table);
?
Is it possible to add a unique constraint to the table, with a
"delete" option so it will delete duplicates?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Said Ramirez
Super Cool MySQL DBA
cel: 732 425 1929
