how to move a postgres schema via file operations ?

Posted by Jerome WAGNER on Stack Overflow See other posts from Stack Overflow or by Jerome WAGNER
Published on 2010-05-05T07:52:21Z Indexed on 2010/05/05 9:08 UTC
Read the original article Hit count: 387

Filed under:

Hello,

I have a schema schema1 in a postgres database A. I want to have a duplicate of this schema (model + data) in database B under the name schema2.

What are my options ?

I currently : * dump schema1 from database A * sed my way through schema renaming in the dump : schema1 becomes schema2 * restore schema2 in database B

but I am looking for a more efficient procedure. For instance, via direct file operations on postgres binary files.

Thanks for your help

Jerome Wagner

© Stack Overflow or respective owner

Related posts about postgresql