Is it possible to use multiple databases within same query using pg-promise?
I have two related tables T1 and T2 in different databases D1 and D2. I need to do an inner join between two tables.
From here: Joining Results from Two Separate Databases it is clear that separate queries should be made to two databases and results to be consolidated on client side OR use dblink / postgres-fdw.
However, I see this issue: Multiple Databases #1
and the use of $dc parameter here: pg-promise/Database.
I believe issue: Multiple Databases #1
just facilitates allowing connecting to multiple databases within the same codebase.
The description of $dc parameter states:
This is mainly to facilitate the use of multiple databases which may need separate protocol extensions, or different implementations within a single task
However, I did not find any examples.
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
node.js postgresql pg-promise
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
add a comment |
I have two related tables T1 and T2 in different databases D1 and D2. I need to do an inner join between two tables.
From here: Joining Results from Two Separate Databases it is clear that separate queries should be made to two databases and results to be consolidated on client side OR use dblink / postgres-fdw.
However, I see this issue: Multiple Databases #1
and the use of $dc parameter here: pg-promise/Database.
I believe issue: Multiple Databases #1
just facilitates allowing connecting to multiple databases within the same codebase.
The description of $dc parameter states:
This is mainly to facilitate the use of multiple databases which may need separate protocol extensions, or different implementations within a single task
However, I did not find any examples.
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
node.js postgresql pg-promise
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
add a comment |
I have two related tables T1 and T2 in different databases D1 and D2. I need to do an inner join between two tables.
From here: Joining Results from Two Separate Databases it is clear that separate queries should be made to two databases and results to be consolidated on client side OR use dblink / postgres-fdw.
However, I see this issue: Multiple Databases #1
and the use of $dc parameter here: pg-promise/Database.
I believe issue: Multiple Databases #1
just facilitates allowing connecting to multiple databases within the same codebase.
The description of $dc parameter states:
This is mainly to facilitate the use of multiple databases which may need separate protocol extensions, or different implementations within a single task
However, I did not find any examples.
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
node.js postgresql pg-promise
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
I have two related tables T1 and T2 in different databases D1 and D2. I need to do an inner join between two tables.
From here: Joining Results from Two Separate Databases it is clear that separate queries should be made to two databases and results to be consolidated on client side OR use dblink / postgres-fdw.
However, I see this issue: Multiple Databases #1
and the use of $dc parameter here: pg-promise/Database.
I believe issue: Multiple Databases #1
just facilitates allowing connecting to multiple databases within the same codebase.
The description of $dc parameter states:
This is mainly to facilitate the use of multiple databases which may need separate protocol extensions, or different implementations within a single task
However, I did not find any examples.
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
node.js postgresql pg-promise
node.js postgresql pg-promise
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
asked Nov 24 '18 at 8:48
Naisheel VerdhanNaisheel Verdhan
2,5361127
2,5361127
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
It is the former.
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
No. Each Database object represents only a single connection to A database.
Database Context is there to allow re-use of tasks, transactions and protocol extensions across multiple Database objects, by relying on its value.
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53456604%2fis-it-possible-to-use-multiple-databases-within-same-query-using-pg-promise%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
It is the former.
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
No. Each Database object represents only a single connection to A database.
Database Context is there to allow re-use of tasks, transactions and protocol extensions across multiple Database objects, by relying on its value.
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
add a comment |
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
It is the former.
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
No. Each Database object represents only a single connection to A database.
Database Context is there to allow re-use of tasks, transactions and protocol extensions across multiple Database objects, by relying on its value.
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
add a comment |
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
It is the former.
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
No. Each Database object represents only a single connection to A database.
Database Context is there to allow re-use of tasks, transactions and protocol extensions across multiple Database objects, by relying on its value.
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
Is the $dc paramter just a database context object that can be accessed, or would it allow to do an inner join between two different databases?
It is the former.
Is there a way to do utilise two database connections but do a join across databases in without having to do it on client-side using pg-promise?
No. Each Database object represents only a single connection to A database.
Database Context is there to allow re-use of tasks, transactions and protocol extensions across multiple Database objects, by relying on its value.
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
edited Nov 24 '18 at 10:51
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
answered Nov 24 '18 at 9:51
vitaly-tvitaly-t
11.1k34771
11.1k34771
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53456604%2fis-it-possible-to-use-multiple-databases-within-same-query-using-pg-promise%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
