Re: [SQL] identifying duplicates in table with redundancies

On Fri, 24 Sep 2010 18:12:18 +0100 Oliver d'Azevedo Christina wrote: >>> SELECT DISTINCT trainer_id,trainer_name >>> FROM ( >>> SELECT trainer_name -- The field you want to test for duplicates >>> FROM ( >>> SELECT DISTINCT "trainer_id","trainer_name" >>> FROM student >>> ) x >>> GROUP BY "trai

Re: [SQL] pgdump with insert command help

On Sep 24, 2010, at 6:02 PM, Nicholas I wrote: > > pg_dump -Dt --insert table dbname > table.sql; > > i am not able to get the output. is this correct ? Try following: pg_dump --insert -t Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation -- Sent via pgsql-sql mailing list (pgsql-