Re: Export/Import - Mailing list pgsql-admin

From Olivier Hubaut
Subject Re: Export/Import
Date
Msg-id opsibyp5ym94ope3@olivier.amaze.ulb.ac.be
Whole thread Raw
In response to Export/Import  (Sudhakar Kurumella <kurumella@yahoo.com>)
List pgsql-admin
On Wed, 1 Dec 2004 04:36:44 -0800 (PST), Sudhakar Kurumella
<kurumella@yahoo.com> 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

A simple pg_dump -C -f dump.sql dbname should give you what you want.


--
Downloading signature ... 99%
*CRC FAILED*
signature aborted

pgsql-admin by date:

Previous
From: "Vishal Kashyap @ [SaiHertz]"
Date:
Subject: Re: Linux PostgreSQL to Windows PostgreSQL
Next
From: Halford Dace
Date:
Subject: Re: Export/Import