Re: Importing and Exporting Tables. - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Importing and Exporting Tables.
Date
Msg-id 20050214155634.GA28291@wolff.to
Whole thread Raw
In response to Importing and Exporting Tables.  (Chandra Mouli S <scmouli23@gmail.com>)
List pgsql-admin
On Mon, Feb 14, 2005 at 13:19:11 +0530,
  Chandra Mouli S <scmouli23@gmail.com> wrote:
> Hi,
>
> I have POSTGRESQL v8.0 for Windows installed in my home computer.
>
> I work simultaneously in my home and in my office.
>
> I like someone to help me to find a way to:
>
> EXPORT the tables in my home pc to some file format
> from which I can IMPORT back the same tables in my office system.

You can use pg_dump/pg_dumpall to dump as text and use psql reload.

pgsql-admin by date:

Previous
From: Christopher Browne
Date:
Subject: Re: replication
Next
From: Tom Lane
Date:
Subject: Re: Problem binding postmaster to several interfaces