Postgres Pro
Downloads
Home   >   mailing lists

Re: Attaching database - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Attaching database
Date
Msg-id CAFj8pRCktpj00jQwbPS118jrXs4xwxk=TtMpRMSTf61xE+SR1g@mail.gmail.com
Whole thread Raw
In response to Attaching database  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Attaching database  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view
Hi

po 19. 10. 2020 v 19:40 odesílatel Igor Korot <ikorot01@gmail.com> 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.


pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Attaching database
Next
From: Igor Korot
Date:
Subject: Re: Attaching database