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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
