Truncate all tables in postgres database
- by Aaron
I regularly need to delete all the data from my postgresql database before a rebuild. How would I do this directly in SQL?
At the moment I've managed to come up with a SQL statement that returns all the commands I need to execute:
SELECT 'TRUNCATE TABLE ' || tablename || ';' FROM pg_tables WHERE tableowner='MYUSER';
but I cant see a way to execute them programatically once I have them...
Thanks in advance