Hi,
I would like to write a SQL statement to drop all the
tables owned by me but a problem I’m struggling with is with
referential integrity. The statement I have now to generate the drop statements is
select 'drop table '||tablename||' cascade;' from pg_tables where tableowner='<myuseraccount>';
The generated SQLs above might attempt to drop the
parent tables first before the child and to be able to drop all the
tables, I had to run the SQL script in multiple iterations. Not very clean.
Can someone advise how I could formulate the SQL to check for table dependencies to generate a SQL script that drops the child tables first before the parent? Or are there any better alternatives?
Thank you.
Tiff
