-----Original Message----- From: Stefan Keller [mailto:sfkeller@xxxxxxxxx] Sent: Tuesday, January 29, 2019 9:40 AM To: Postgres General <pgsql-general@xxxxxxxxxxxxxx> 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 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 e.g. do: select foo('111.11.11.11', '5432', 'mydb'); How can I set the parameters in 'options' using those variables? :Stefan P.S. Actually I'll put this code in a plggsql function later on. ______________________________________________________________________________________ Use dynamic sql: https://www.postgresql.org/docs/11/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN Regards, Igor Neyman
