View source for postgres

=== Duplicates === 

%%

select Column1, Column2, count(*)
from yourTable
group by Column1, Column2
HAVING count(*) > 1


%%


=== DELETE from SELECT ===

%%

delete from mytable where id in(select id from mytable where someconditon)

%%

=== Dump ===

%%

## sudo -u USERNAME pg_dump -v DATABASE > d.psql

%%