Hi,
Can u please try with the following command:
pg_dump -s dbname >DumpFileName.dmp
or
pg_dump -s -u dbname >DumpFileName.dmp
For the second, you will be asked for username & password.
Regards,
Sandeep
Shaun Clements wrote:
Hi All
Im having a problem restoring a data schema on Postgres 8.01 for Windows.
Im using the following command
psql -U username -d db1 > filename.dmp
This should have restored the schema from the file, filename.dmp to
the database, db1
I did create the database before restoring the data schema. And its
not working.
Am I missing something?
Thanks in advance.
Kind Regards,
Shaun Clements
Subject to www.relyant.co.za/edisclaim.htm
------------------------------------------------------------------------
---------------------------------------------------------
email-body was scanned and no virus found
---------------------------------------------------------
---------------------------------------------------------
Disclaimer:
The contents of this message are confidential and intended to the addressee at the specified e-mail address only. Its contents may not be copied or disclosed to anyone other than the intended recipient. If this e-mail is received in error, please contact Vertex Software Pvt. Ltd immediately on +91 20 4041500 with details of the sender and addressee and delete the e-mail. Vertex Software Pvt. Ltd accepts no responsibility in the event that the onward transmission, opening or use of this message and/or any attachments adversely affects the recipient's systems or data. It is the recipient's responsibility to carry out such virus and other checks as the recipient considers appropriate.
---------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
