[postgis-users] How to set parameters in 'options'?

Stefan Keller sfkeller at gmail.com
Tue Jan 29 06:18:37 PST 2019


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: syntax error at or near "_host"
$$ language sql;

In order to do:
select foo('', '5432', 'mydb');

How can I set the parameters in 'options' using those variables?


P.S. Actually I'll put this code in a plggsql later on.

More information about the postgis-users mailing list