From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | Stefan Keller <sfkeller(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: How to set parameters in 'options'? |
Date: | 2019-01-29 15:18:29 |
Message-ID: | DM5PR17MB153249E644BC51B8C6EADE6EDA970@DM5PR17MB1532.namprd17.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----Original Message-----
From: Stefan Keller [mailto:sfkeller(at)gmail(dot)com]
Sent: Tuesday, January 29, 2019 9:40 AM
To: Postgres General <pgsql-general(at)postgresql(dot)org>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-01-29 15:21:46 | Re: How to set parameters in 'options'? |
Previous Message | Adrian Klaver | 2019-01-29 14:43:03 | Re: Anonymize Data |