How to import schema?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • osman7king
    New Member
    • Sep 2010
    • 61

    How to import schema?

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

    Thanks.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    I think you can use pg_dump tool to do that.

    Comment

    • Amin M Salih
      New Member
      • Jul 2011
      • 2

      #3
      you can use the following
      psql dbname < infile

      Comment

      • hikmat
        New Member
        • Sep 2011
        • 4

        #4
        you can use pg_dumpall > filename. Then to restore you can psql -f filename databasename

        Comment

        Working...