Re: Copying data

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Madelon Brennan <brennanm(at)georgetown(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Copying data
Date: 2002-02-11 13:49:38
Message-ID: 20020211134938.GC3472@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Feb 11, 2002 at 01:15:26PM +0000,
Madelon Brennan <brennanm(at)georgetown(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marco Tulio 2002-02-11 14:31:57 History Keys fault
Previous Message anjo.doce.marilia 2002-02-11 13:47:41 Permissions on FUNCTIONS