Postgres Pro
Downloads
Home   >   mailing lists

Re: Drop table wildcard - Mailing list pgsql-novice

From Tom Lane
Subject Re: Drop table wildcard
Date
Msg-id 28575.989894137@sss.pgh.pa.us
Whole thread Raw
In response to Drop table wildcard  (Danny Aldham <danny@lennon.postino.com>)
List pgsql-novice
Tree view 
Danny Aldham <danny@lennon.postino.com> writes:
> I am working with some software that creates a lot of temporary tables
> to store query returns. So after a few weeks I have over 200 tables
> named tmp_123_some_number_etc . Is there a way from psql for me to
> drop all the tables with names beginning with tmp_ ?

Why don't you make it create the tables as TEMP tables to begin with?
Then they'll go away by themselves.

            regards, tom lane

pgsql-novice by date:

Previous
From: Danny Aldham
Date:
Subject: Drop table wildcard
Next
From: "Matus \"fantomas\" Uhlar"
Date:
Subject: asynchronour queries and result testing