Copying data
Copying data
От:
Madelon Brennan <brennanm@georgetown.edu>
Дата:
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. -- Madelon L. Brennan Internet Development Coordinator Georgetown University brennanm@georgetown.edu http://web.georgetown.edu
Re: Copying data
От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Mon, Feb 11, 2002 at 01:15:26PM +0000, Madelon Brennan 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