By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

How to import schema?

P: 61
I want to import a schema from database to another,
how can I do that?

Mar 10 '11 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 700
I think you can use pg_dump tool to do that.
Mar 11 '11 #2

P: 2
you can use the following
psql dbname < infile
Jul 7 '11 #3

P: 4
you can use pg_dumpall > filename. Then to restore you can psql -f filename databasename
Sep 20 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.