Skip site navigation (1) Skip section navigation (2)

Automation again more info.. HELP

From: "Jerome Macaranas" <macky(at)edsamail(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Automation again more info.. HELP
Date: 2000-10-13 02:30:55
Message-ID: 00e001c034bd$9d60bd40$ (view raw or whole thread)
Lists: pgsql-novice
Sorry about the lack of info..

OS: Redhat 6.2
mailbox01-->Postgresql 6.5
mailbox02-->Postgresql 7.02
Preferred language-->TCL

    I have a database of email users with a lot of tables..... 

I want to automate the dumping of data..... from mailbox01(name of computer) and append it to to the existing database in mailbox02 (backup of mailbox01) so the marketing dept. can do their job..  I have an idea of just querying... I want to have suggestions ... more idea on how to do this.... 
I hate typing again and again the query WHERE date is ... bla bla ... 


If Im going to create a single script to placed in cron WHAT IF... I want to have the month of October I'll be dumping all the data again.... waste of time... and cpu hours hehehehe...

Thanks in advance 


pgsql-novice by date

Next:From: ghaverlaDate: 2000-10-13 02:48:16
Subject: Re: Automation again more info.. HELP
Previous:From: Mike WhiteDate: 2000-10-13 02:15:47
Subject: starting postmaster problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group