Re: Foreign Data Wrapper Handler

2020-11-09 Thread Adrian Klaver
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

Re: Foreign Data Wrapper Handler

2020-11-09 Thread Laurenz Albe
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

Re: Foreign Data Wrapper Handler

2020-11-09 Thread Susan Hurst
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? ---

Re: Foreign Data Wrapper Handler

2020-11-09 Thread Laurenz Albe
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

Re: Foreign Data Wrapper Handler

2020-11-08 Thread Adrian Klaver
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

Re: Foreign Data Wrapper Handler

2020-11-08 Thread Susan Hurst
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

Re: Foreign Data Wrapper Handler

2020-11-07 Thread Adrian Klaver
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

Foreign Data Wrapper Handler

2020-11-07 Thread Susan Hurst
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.