[GENERAL] DROP TABLE wildcard

[Andy Koch]

Is it possible to drop multiple tables with SQL on the system tables:

I tried this:

DROP TABLE from pg_tables where tablename LIKE 'table_num_%';

Which for whatever reason would delete 0 items despite it should have 
matched on several.

Of course I'm not even sure pg_tables would be the smart place to make the 
delete from?

Thanks.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]