| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Attaching database |
| Date: | 2020-10-19 17:50:31 |
| Message-ID: | CAFj8pRCktpj00jQwbPS118jrXs4xwxk=TtMpRMSTf61xE+SR1g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
po 19. 10. 2020 v 19:40 odesílatel Igor Korot <ikorot01(at)gmail(dot)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.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2020-10-19 18:18:20 | Re: Attaching database |
| Previous Message | Igor Korot | 2020-10-19 17:39:57 | Attaching database |