On Tue, 2021-05-18 at 16:13 +0000, Godfrin, Philippe E wrote: > That seems very promising, though I’m not certain how I’d code that in the create > foreign server syntax. My testbed is not quire ready right now, so I’ll ask instead of testing. > Is this what you mean: > > CREATE SERVER FDW001 FOREIGN DATA WRAPPER POSTGES_FDW > OPTIONS (HOST ‘FOORW, FOORO’, DBNAME ‘FOODB,FOODB’, PORT ‘5432,6432’, > TARGET_SESSION_ATTRS ‘ANY,READ-ONLY’ Pretty much, yes. Except you can only specify a single setting for "target_session_attrs". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
