I have these 3 tables:
tablename
tmp_staging0109
tmp_staging1229
tmp_staging0108
I'd like this query:
select tablename from pg_tables where tablename like 'tmp_staging%' and
tablename 'tmp_staging1230';
To return this result:
tablename
On Monday, January 09, 2012 8:12:18 am Tony Capobianco wrote:
I have these 3 tables:
tablename
tmp_staging0109
tmp_staging1229
tmp_staging0108
I'd like this query:
select tablename from pg_tables where tablename like 'tmp_staging%' and
tablename
I see what you're saying:
pg=# select tablename from pg_tables where tablename like 'tmp_staging%' and
tablename 'tmp_staging1230' and tablename 'tmp_staging1228';
tablename
tmp_staging1229
This query is part of a larger script where I want to dynamically
On Monday, January 09, 2012 8:12:18 am Tony Capobianco wrote:
tablename
tmp_staging0109
tmp_staging1229
tmp_staging0108
How can I write this correctly?
Had another idea. If you are looking for the highest numbered table below a
certain number then maybe
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
tmp_staging1229
This query is part of a larger script where I want to dynamically select
tablenames older than 10 days and drop them. The tables are created in
a tmp_stagingMMDD format. I know postgres does not maintain object
create
On Monday, January 09, 2012 8:28:43 am Tony Capobianco wrote:
I see what you're saying:
pg=# select tablename from pg_tables where tablename like 'tmp_staging%'
and tablename 'tmp_staging1230' and tablename 'tmp_staging1228';
tablename
tmp_staging1229
This