Possible to perform cross-database queries with PostgreSQL?

by

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.

postgres_fdw

Use postgres_fdw (foreign data wrapper) to connect to tables in any Postgres database – local or remote.

Note that there are foreign data wrappers for other popular data sources. At this time, only postgres_fdw and file_fdw are part of the official Postgres distribution.

For Postgres versions before 9.3

Versions this old are no longer supported, but if you need to do this in a pre-2013 Postgres installation, there is a function called dblink.

I’ve never used it, but it is maintained and distributed with the rest of PostgreSQL. If you’re using the version of PostgreSQL that came with your Linux distro, you might need to install a package called postgresql-contrib.

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Any downsides of using data type “text” for storing strings?
  4. Index for finding an element in a JSON array
  5. Query for array elements inside JSON type
  6. How to delete duplicate rows without unique identifier
  7. Best way to check for “empty or null value”
  8. How to avoid multiple function evals with the (func()).* syntax in a query?
  9. Time zone storage in data type “timestamp with time zone”
  10. Is there something like a zip() function in PostgreSQL that combines two arrays?
  11. Serial numbers per group of rows for compound key
  12. PostgreSQL parameterized Order By / Limit in table function
  13. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  14. Get the default values of table columns in Postgres?
  15. Division of integers returns 0
  16. PostgreSQL: how to convert from Unix epoch to date?
  17. Postgres not using index when index scan is much better option
  18. SQL update fields of one table from fields of another one
  19. Postgres – Function to return the intersection of 2 ARRAYs?
  20. How to store array or multiple values in one column
  21. convert Postgres geometry format to WKT
  22. COPY with dynamic file name
  23. Table or column name cannot start with numeric?
  24. Count cumulative total in Postgresql
  25. PostgreSQL column ‘foo’ does not exist
  26. Prepared Statement on Postgresql in Rails
  27. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment