Re: [pgadmin-support] Recommended Procedure for Archiving Table Data

2004-10-29 Thread Andreas Pflug
Sally Ruggero wrote: I need advice on archiving data from our production database. Each night I would like to save and remove a day's data from two weeks ago, from all the tables. I know how to delete the data--though our schema does not specify cascaded deletes. However, I can't figure out ho

[pgadmin-support] Recommended Procedure for Archiving Table Data

2004-10-29 Thread Sally Ruggero
I need advice on archiving data from our production database.   Each night I would like to save and remove a day's data from two weeks ago, from all the tables. I know how to delete the data--though our schema does not specify cascaded deletes. However, I can't figure out how to save the de