Dear Sudhakar ,
> > I am new to PostgreSQL, Welcome . > 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. PostgreSQL does not have any GUI tool for that but pg_dump and pg_restore would do your job. Please read the docs for more. http://www.postgresql.org/docs/7.4/interactive/app-pgrestore.html http://www.postgresql.org/docs/current/static/app-pgdump.html -- With Best Regards, Vishal Kashyap. Lead Software Developer, http://saihertz.com, http://vishalkashyap.tk ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
