Postgres Pro
Downloads
Home   >   mailing lists

drop table where tableName like 'backup_2007%' ? - Mailing list pgsql-sql

From Emi Lu
Subject drop table where tableName like 'backup_2007%' ?
Date
Msg-id 47F0F9BB.3060706@encs.concordia.ca
Whole thread Raw
Responses Re: drop table where tableName like 'backup_2007%' ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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!

pgsql-sql by date:

Previous
From: Allan Kamau
Date:
Subject: Re: Removing redundant itemsets
Next
From: Tom Lane
Date:
Subject: Re: drop table where tableName like 'backup_2007%' ?