Skip site navigation (1) Skip section navigation (2)

drop table where tableName like 'backup_2007%' ?

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: drop table where tableName like 'backup_2007%' ?
Date: 2008-03-31 14:48:27
Message-ID: 47F0F9BB.3060706@encs.concordia.ca (view raw or flat)
Thread:
Lists: pgsql-sql
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!



Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2008-03-31 15:55:14
Subject: Re: drop table where tableName like 'backup_2007%' ?
Previous:From: Craig RingerDate: 2008-03-31 11:48:34
Subject: Re: Removing redundant itemsets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group