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
FAQ