On 11/9/20 9:21 AM, Susan Hurst wrote:
Thanks for the detailed instructions, Laurenz!
"The foreign server encapsulates the connection string to access a remote
PostgreSQL database. Define one per remote database you want to access."
Where do I define "one per remote database"?.in pg_hba.co
On Mon, 2020-11-09 at 11:21 -0600, Susan Hurst wrote:
> "The foreign server encapsulates the connection string to access a remote
> PostgreSQL database. Define one per remote database you want to access."
>
> Where do I define "one per remote database"?.in pg_hba.conf?
No, in SQL:
CREATE
Thanks for the detailed instructions, Laurenz!
"The foreign server encapsulates the connection string to access a
remote
PostgreSQL database. Define one per remote database you want to
access."
Where do I define "one per remote database"?.in pg_hba.conf?
---
On Sun, 2020-11-08 at 13:09 -0600, Susan Hurst wrote:
> The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html
> does not tell me what I think I need to know, but I will digest this
> more thoroughly. Maybe I need to understand more of the lingo re:
> foreign data wrappers. I do
On 11/8/20 11:09 AM, Susan Hurst wrote:
The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html
does not tell me what I think I need to know, but I will digest this
more thoroughly. Maybe I need to understand more of the lingo re:
foreign data wrappers. I do understand that all f
The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html
does not tell me what I think I need to know, but I will digest this
more thoroughly. Maybe I need to understand more of the lingo re:
foreign data wrappers. I do understand that all fdw names must be unique
within a databas
On 11/7/20 12:44 PM, Susan Hurst wrote:
Can anyone recommend a good online resource for learning how to set up a
foreign data wrapper using a custom fdw name? It seems the trick is to
use a handler to make it work but so far the search results have been
elusive for creating a fdw with a succes
Can anyone recommend a good online resource for learning how to set up a
foreign data wrapper using a custom fdw name? It seems the trick is to
use a handler to make it work but so far the search results have been
elusive for creating a fdw with a successful outcome.
I'm using 'PostgreSQL 11.