How can i pass variable in dblink_connect_u ?

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: How can i pass variable in dblink_connect_u ?
Date: 2022-02-01 10:42:06
Message-ID: CAN0SRDEWatOY8T7+WL2-vkx1Qff=LjQ+biPSnT4JbnnmVtYvkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jian He 2022-02-01 11:10:08 Offline HTML manual.
Previous Message Дмитрий Воронин 2022-02-01 08:42:00