drop all the table in a 3-node cluster (say 800 tables)

Amit_Singh

drop all the table in a 3-node cluster (say 800 tables)

knicely87

If it's all of the tables, it might easier to just to drop the entire schema and re-create it!

DROP SCHEMA xxx CASCADE;

CREATE SCHEMA xxx;

Ben_Vandiver

I like the vsql-to-vsql approach:

vsql -aT -c "select 'drop table '||table_name||' cascade;' from tables" | vsql

id10t

did you mean(mistype)?
 
vsql -At -c "select 'drop table '||table_name||' cascade;' from tables" | vsql

because:

$ vsql --help | grep -P '(\-T)|(\-a)'
  -a              echo all input from script
  -T TEXT         set HTML table tag attributes (width, border) (-P tableattr=)

Ben_Vandiver

Err.. yup.  Flipped the case.  Thanks!