Обсуждение: Copying data

Поиск
Список
Период
Сортировка

Copying data

От
Madelon Brennan
Дата:
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
Дата:
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