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