Hi
po 19. 10. 2020 v 19:40 odesílatel Igor Korot <ikorot01@xxxxxxxxx> napsal:
Hi,
IIUC, PostgreSQL does not support attaching a database to an existing
connection.
However I was told that I can use this:
https://www.postgresql.org/docs/9.3/postgres-fdw.html.
Is it the same thing? Why there is no simple
ATTACH <db> AS <dbname>
It is a different thing - postgresql_fdw does nested connect - it uses client-server protocol.
For postgres connect and sql engine process is one entity - and engine is written without a possibility to reconnect to another database.
Regards
Pavel
?
Thank you.