2

is there a way to create a select statement that would retrieve data from multiple database in postgre?

i was thinking it would be something like this:

select * from dbname1.table1, dbname2.table2 where dbname1.table1.column1 = dbname2.table2.column1

Improve this question

3 Answers 3

Reset to default
4

Have a look at the "dblink" contrib module.

OTOH it's possible that you treat the databases in a PostgreSQL cluster as equivalent to the databases in... let's say MySQL. Which is incorrect - the PostgreSQL databases contain schemas and those are the equivalent of the databases in MySQL.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

From here:

It is not possible to access more than one database per connection.

Update: but see Milen's answer.

Improve this answer

Comments

0

As Milen A. Radev wrote, it's possible to execute cross-database queries using dblink package. There is an example in this other answer: https://stackoverflow.com/a/72562629/679240

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.