Drop table wildcard

From: Danny Aldham <danny(at)lennon(dot)postino(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Drop table wildcard
Date: 2001-05-15 01:58:23
Message-ID: 200105150158.f4F1wNK02058@lennon.postino.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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_ ?
Thanks

--
Danny Aldham Providing Certified Internetworking Solutions to Business
www.postino.com E-Mail, Web Servers, Web Databases, SQL PHP & Perl

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-05-15 02:35:37 Re: Drop table wildcard
Previous Message Tom Strickland 2001-05-14 15:23:58 Inheritence-relations problem