---------- Forwarded message ----------
From: deepak pal <deepak.05pal@gmail.com>
Date: Apr 3, 2006 2:05 PM
Subject: Re: [GENERAL] how to create script of database in postgres..sql(winxp)
To: Tomi NA <hefest@gmail.com>
it do not recognize that \i and pg_dump i use \i pg_dump mydbname>newdb command
From the examples in man pg_dump:
To dump a database:
$ pg_dump mydb > db.out
To reload this database:
$ psql -d database -f db.out
To dump a database called mydb to a tar file:
$ pg_dump -Ft mydb > db.tar
To reload this dump into an existing database called newdb:
$ pg_restore -d newdb db.tar
Have you tried to dump the database this way? Does it work?
t.n.a.