Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 517292E0043
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Mon, 31 Mar 2008 11:48:34 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 11788-07
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Mon, 31 Mar 2008 11:48:33 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from perseverance.services.encs.concordia.ca
	(perseverance-96.encs.concordia.ca [132.205.96.94])
	by developer.postgresql.org (Postfix) with ESMTP id B757B2E003F
	for <pgsql-sql@postgresql.org>; Mon, 31 Mar 2008 11:48:33 -0300 (ADT)
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
	[132.205.47.225])
	by perseverance.services.encs.concordia.ca (envelope-from
	emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id m2VEmR7q023712
	for <pgsql-sql@postgresql.org>; Mon, 31 Mar 2008 10:48:28 -0400
Message-ID: <47F0F9BB.3060706@encs.concordia.ca>
Date: Mon, 31 Mar 2008 10:48:27 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: drop table where tableName like 'backup_2007%' ?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.58 on perseverance.encs.concordia.ca at 2008/03/31
	10:48:28 EDT
X-Archive-Number: 200803/208
X-Sequence-Number: 30536

Good morning,


Is there a command to drop tables whose name begins a specific string?


For example, all backup tables begins with backup_2007:
Drop table where tableName like 'backup_2007%'?


Thanks a lot!