script for unidirectional database update - Mailing list pgsql-sql

Hi,

I need to periodically transfer the content of one db into another. The
target db should be deleted before and there should be one ascii file
containing the data, because there's a firewall between the two db's and
file transfer ist the most simple thing to do. Does anyone have a script
to automate this?

Thanks,

Markus