Thread: Importing and Exporting Tables.

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.

This is my really save my time and work.

Yours truly,
SCMOULI.

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.