Fwd: how to create script of database in postgres..sql(winxp) - Mailing list pgsql-general

From Tomi NA
Subject Fwd: how to create script of database in postgres..sql(winxp)
Date
Msg-id d487eb8e0604030514q5e6a361dn948e3a2ce9ea7e39@mail.gmail.com
Whole thread Raw
In response to how to create script of database in postgres..sql(winxp)  ("deepak pal" <deepak.05pal@gmail.com>)
List pgsql-general


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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: how to create script of database in postgres..sql(winxp)
Next
From: Robert Treat
Date:
Subject: Re: Creating serial ID on Windows.