Re: Foreign Data Wrapper Handler - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Foreign Data Wrapper Handler
Date
Msg-id 7a1d990b614c9ae573c3b32ccba579930320d39d.camel@cybertec.at
Whole thread Raw
In response to Re: Foreign Data Wrapper Handler  (Susan Hurst <susan.hurst@brookhurstdata.com>)
List pgsql-general
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 FOREIGN SERVER somename FOREIFN DATA WRAPPER postgres_fdw OPTIONS (...);

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Susan Hurst
Date:
Subject: Re: Foreign Data Wrapper Handler
Next
From: Pavel Stehule
Date:
Subject: Re: Temporary tables usage in functions