Re: Importing and Exporting Tables.

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chandra Mouli S <scmouli23(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Importing and Exporting Tables.
Date: 2005-02-14 15:56:34
Message-ID: 20050214155634.GA28291@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Feb 14, 2005 at 13:19:11 +0530,
Chandra Mouli S <scmouli23(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-02-14 17:14:33 Re: Problem binding postmaster to several interfaces
Previous Message Christopher Browne 2005-02-14 12:36:19 Re: replication