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,
whati 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.