Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 31 Mar 2008 10:48:27 -0400
- Message-id: <47F0F9BB.3060706@encs.concordia.ca> <text/plain>
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!
- Follow-Ups:
- Re: drop table where tableName like 'backup_2007%' ?
- From: Tom Lane
- Re: drop table where tableName like 'backup_2007%' ?
- Prev by Date: Re: Removing redundant itemsets
- Next by Date: Re: drop table where tableName like 'backup_2007%' ?
- Previous by thread: Removing redundant itemsets
- Next by thread: Re: drop table where tableName like 'backup_2007%' ?
- Indexes: