Louis :emacs: on Nostr: Oh, TIL PostgreSQL doesn't support cross-database queries on the same server. As a ...
Oh, TIL PostgreSQL doesn't support cross-database queries on the same server.
As a workaround, one must use the postgres_fdw extension and "register" the other database as a foreign server and "import" the foreign schema (which is then not updated automatically).
SQLite, MySQL, SQL Server all support this essential feature. Does anyone know the reasons why PostgreSQL doesn't?
#postgresql
As a workaround, one must use the postgres_fdw extension and "register" the other database as a foreign server and "import" the foreign schema (which is then not updated automatically).
SQLite, MySQL, SQL Server all support this essential feature. Does anyone know the reasons why PostgreSQL doesn't?
#postgresql