agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedHow can i pass variable in dblink_connect_u ?
3+ messages / 2 participants
[nested] [flat]
* How can i pass variable in dblink_connect_u ?
@ 2022-02-01 10:42 aditya desai <admad123@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: aditya desai @ 2022-02-01 10:42 UTC (permalink / raw)
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Hi All,
how can I pass variables in dblink_connect_u ?
Current code hardcoded DB name:
perform * from dblink_connect_u('myconn','dbname=mydb');
Expected:
databasename=current_database();
perform * from dblink_connect_u('myconn','dbname=databasename');
databasename is getting considered as text.
Thanks in advance
Regards,
Aditya.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How can i pass variable in dblink_connect_u ?
@ 2022-02-01 13:41 Joe Conway <mail@joeconway.com>
parent: aditya desai <admad123@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joe Conway @ 2022-02-01 13:41 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; pgsql-sql <pgsql-sql@lists.postgresql.org>
On 2/1/22 05:42, aditya desai wrote:
> Hi All,
> how can I pass variables in dblink_connect_u ?
>
> Current code hardcoded DB name:
> perform * from dblink_connect_u('myconn','dbname=mydb');
>
> Expected:
> databasename=current_database();
> perform * from dblink_connect_u('myconn','dbname=databasename');
>
> databasename is getting considered as text.
Correct, it is a string literal. So just create the string literal using
string manipulation functionality -- e.g.:
SELECT
dblink_connect_u('myconn','dbname=' ||
current_database());
dblink_connect_u
------------------
OK
(1 row)
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How can i pass variable in dblink_connect_u ?
@ 2022-02-03 11:38 aditya desai <admad123@gmail.com>
parent: Joe Conway <mail@joeconway.com>
0 siblings, 0 replies; 3+ messages in thread
From: aditya desai @ 2022-02-03 11:38 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Thanks Joe
On Tue, Feb 1, 2022 at 7:11 PM Joe Conway <mail@joeconway.com> wrote:
> On 2/1/22 05:42, aditya desai wrote:
> > Hi All,
> > how can I pass variables in dblink_connect_u ?
> >
> > Current code hardcoded DB name:
> > perform * from dblink_connect_u('myconn','dbname=mydb');
> >
> > Expected:
> > databasename=current_database();
> > perform * from dblink_connect_u('myconn','dbname=databasename');
> >
> > databasename is getting considered as text.
>
> Correct, it is a string literal. So just create the string literal using
> string manipulation functionality -- e.g.:
>
> SELECT
> dblink_connect_u('myconn','dbname=' ||
> current_database());
> dblink_connect_u
> ------------------
> OK
> (1 row)
>
> HTH,
>
> Joe
>
> --
> Crunchy Data - http://crunchydata.com
> PostgreSQL Support for Secure Enterprises
> Consulting, Training, & Open Source Development
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-02-03 11:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-01 10:42 How can i pass variable in dblink_connect_u ? aditya desai <admad123@gmail.com>
2022-02-01 13:41 ` Joe Conway <mail@joeconway.com>
2022-02-03 11:38 ` aditya desai <admad123@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox