Fwd: how to create script of database in postgres..sql(winxp)

---------- Forwarded message ----------
From: deepak pal <deepak(dot)05pal(at)gmail(dot)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(at)gmail(dot)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.