| From: | "Olivier Hubaut" <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Export/Import |
| Date: | 2004-12-01 13:07:07 |
| Message-ID: | opsibyp5ym94ope3@olivier.amaze.ulb.ac.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 1 Dec 2004 04:36:44 -0800 (PST), Sudhakar Kurumella
<kurumella(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pradeepkumar, Pyatalo (IE10) | 2004-12-01 13:25:47 | PSQL History not working |
| Previous Message | Halford Dace | 2004-12-01 13:06:26 | Re: Export/Import |