Re: Export/Import

From: Halford Dace <hal(at)stowe(dot)co(dot)za>
To: Sudhakar Kurumella <kurumella(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Export/Import
Date: 2004-12-01 13:06:26
Message-ID: Pine.SGI.4.53.0412011506010.28271@jove.stowe.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


You would be wanting to use pg_dump

It's pretty quick and efficient. Try its man page or docs.

Hal

On Wed, 1 Dec 2004, Sudhakar Kurumella wrote:

> Hello Everyone,
>
> I am new to PostgreSQL, i have a question, i'll appreciate if anybody helps me.
>
> How can i export/import a complete database running on one machine to another machine. I have gone through the docs, what i gather is,,that i can export only tables only..not entire database like we do in MS SQL Server.
>
> thanks,
> kuru
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - You care about security. So do we.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Olivier Hubaut 2004-12-01 13:07:07 Re: Export/Import
Previous Message CoL 2004-12-01 13:05:11 Re: Linux PostgreSQL to Windows PostgreSQL