On 1/29/19 10:03 AM, Stefan Keller wrote:
Many thanks to Igor and Adrian for your hints.
Got it to work like this:
create function link_server(_server text, _host text, _port text, _dbname text)
returns void as $$
begin
execute format('create server %s
foreign data wrapper postgres_fdw
Many thanks to Igor and Adrian for your hints.
Got it to work like this:
create function link_server(_server text, _host text, _port text, _dbname text)
returns void as $$
begin
execute format('create server %s
foreign data wrapper postgres_fdw
options (host %L, port %L, dbname %L)', _s
On 1/29/19 6:40 AM, Stefan Keller wrote:
Hi,
I'd like to write a function like this:
create function foo(_host text, _port text, _dbname text)
returns void as $$
create server _server
foreign data wrapper postgres_fdw
options (host _host, port _port, dbname _dbname);
-- ERROR:
-Original Message-
From: Stefan Keller [mailto:sfkel...@gmail.com]
Sent: Tuesday, January 29, 2019 9:40 AM
To: Postgres General
Subject: How to set parameters in 'options'?
Hi,
I'd like to write a function like this:
create function foo(_host text, _port text, _dbname text) returns voi