> > 1. How do you remove one of two identical rows > > from a pgsql table ? > > DELETE FROM t1 WHERE .... wil do the stuff for you. If you don't know > the value into the duplicate field just export the database with pg_dump > create > a unique index onto this field and reimport all your data. Duplicate > data will > not be inserted. Another way could be to SELECT oid FROM table WHERE ...; and then delete based on that. However I believe it is possible to have two rows have the same oid but usually that isn't the case.
