var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Join in tables in different databases
I have two tables named a and b in public schema of two different databases like
How can I have a join between the two tables?
Sorry, I wrote it incorrectly.
The two tables are like
PostgreSQL does not allow you to query / 'talk' between different databases.
Each Database is a self-contained system, with the only common information being Roles across Databases.
As such, you can't join DatabaseA.public.TableA to DatabaseB.public.TableB.
However, have you considered:
DatabaseA.SchemaA.TableA to DatabaseA.SchemaB.TableB. In that situation, you could join the two tables.