PostgreSQL: Replace schema in db1 with schema from db2Transfer data from database1 to database2 using task...
Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?
Is the symmetric product of an abelian variety a CY variety?
What would be some possible ways of escaping higher gravity planets?
Minimum Viable Product for RTS game?
The No-Straight Maze
What is the draw frequency for 3 consecutive games (same players; amateur level)?
How can I take a waterfall's effect on a jump into consideration mechanically?
Create linguistic diagram (in TikZ?)
Where does documentation like business and software requirement spec docs fit in an agile project?
Why is Shelob considered evil?
Co-worker sabotaging/undoing my work. (Software Development)
How bad is a Computer Science course that doesn't teach Design Patterns?
"I showed the monkey himself in the mirror". Why is this sentence grammatical?
Crack the bank account's password!
Can me and my friend spend the summer in Canada (6 weeks) at 16 years old without an adult?
Identical projects by students at two different colleges: still plagiarism?
Writing dialogues for characters whose first language is not English
What does からか mean?
What are some ways of extending a description of a scenery?
Is Screenshot Time-tracking Common?
How do dictionaries source attestation?
Why are mages sometimes played bot instead of traditional ADCs?
Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?
Is the fingering of thirds flexible or do I have to follow the rules?
PostgreSQL: Replace schema in db1 with schema from db2
Transfer data from database1 to database2 using task queueDump PostgreSQL schema with foreign keys and referenced dataPostgreSQL: Why is the schema owner not the database ownerHow to make a query from a database with schemas to a database without schemas, and vice versa, with DBLINK in postgresCan PostgreSQL slave server act as master for a new database?How to identify which schema calls a function in another database without schema?PostgreSQL Size Quota on Table or SchemaHow do I Configure Per Database Roles for PostgreSQL?Merge 2 columns and replace with specific outputSchema replication Postgresql AWS
Is there a way to replace data in a schema in db1 with data in a schema in db2, given that the schemas are identical (only the data differs)? An alternative would be to replace the whole schema? I would like to keep the name of the schema in db1.
I've serached the documentation but can't find any solution. Any ideas?
Thanks
postgresql postgis
add a comment |
Is there a way to replace data in a schema in db1 with data in a schema in db2, given that the schemas are identical (only the data differs)? An alternative would be to replace the whole schema? I would like to keep the name of the schema in db1.
I've serached the documentation but can't find any solution. Any ideas?
Thanks
postgresql postgis
add a comment |
Is there a way to replace data in a schema in db1 with data in a schema in db2, given that the schemas are identical (only the data differs)? An alternative would be to replace the whole schema? I would like to keep the name of the schema in db1.
I've serached the documentation but can't find any solution. Any ideas?
Thanks
postgresql postgis
Is there a way to replace data in a schema in db1 with data in a schema in db2, given that the schemas are identical (only the data differs)? An alternative would be to replace the whole schema? I would like to keep the name of the schema in db1.
I've serached the documentation but can't find any solution. Any ideas?
Thanks
postgresql postgis
postgresql postgis
asked 1 min ago
SpiranSpiran
61
61
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230645%2fpostgresql-replace-schema-in-db1-with-schema-from-db2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230645%2fpostgresql-replace-schema-in-db1-with-schema-from-db2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown