On Mon, Feb 11, 2002 at 01:15:26PM +0000,
Madelon Brennan <brennanm@georgetown.edu> wrote:
> What is the syntax for copying data from one database to another. I
> would like to take the data from my most current database and copy all
> of the data to my test environment.
> Thanks.
One way to do this is with pg_dump. Something like:
pg_dump database_name > dumpfile
psql test_name < dumpfile