Changeset 212

Show
Ignore:
Timestamp:
01/12/11 22:19:02 (3 years ago)
Author:
depesz
Message:

make it dump the tables in chronological order

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/tools/archive_old_tables_to_csvs

    r211 r212  
    8989    and c.relkind = 'r' 
    9090    and to_date( regexp_replace( c.relname, '^.*([0-9]{8})$', E'\\\\1'), 'YYYYMMDD') < ( select now() - '%s'::interval ) 
     91ORDER BY 1 
    9192        }, $self->{ 'schema' }, $self->{ 'table' }, $self->{ 'keep' }; 
    9293