Statement that returns rows) in a remote database. What I ended up doing was using schemas to divide the table space that way I could keep the tables grouped but still query them all.ĭblink() - executes a query in a remote databaseĭblink executes a query (usually a SELECT, but it can be any SQL I have run into this before an came to the same conclusion about cross database queries as you. If you're using the version of PostgreSQL that came with your Linux distro, you might need to install a package called postgresql-contrib. I've never used it, but it is maintained and distributed with the rest of PostgreSQL. This functionality isn't part of the default PostgreSQL install, but you can add it in. At this time, only postgres_fdw and file_fdw are part of the official Postgres distribution. Note that there are foreign data wrappers for other popular data sources. You can now use the new postgres_fdw (foreign data wrapper) to connect to tables in any Postgres database - local or remote.

Note: As the original asker implied, if you are setting up two databases on the same machine you probably want to make two schemas instead - in that case you don't need anything special to query across them.

I have no idea why these are two separate databases instead of schema, but c'est la vie.

I'm working with some data that is partitioned across two databases although data is really shared between the two (userid columns in one database come from the users table in the other database). How I can connect multiple Postgres Database in a single SQL query? - postgresql I'm going to guess that the answer is 'no' based on the below error message (and this Google result), but is there anyway to perform a cross-database query using PostgreSQL?ĭatabaseA=# select * from ĮRROR: cross-database references are not implemented:

Postgresql 9.2 install dblink