Message-ID: <cbda445a-31c2-847e-69de-b80c90c9e78e@joeconway.com>
Date: Tue, 1 Feb 2022 08:41:08 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: How can i pass variable in dblink_connect_u ?
Content-Language: en-US
To: aditya desai <admad123@gmail.com>,
 pgsql-sql <pgsql-sql@lists.postgresql.org>
References: 
 <CAN0SRDEWatOY8T7+WL2-vkx1Qff=LjQ+biPSnT4JbnnmVtYvkA@mail.gmail.com>
From: Joe Conway <mail@joeconway.com>
In-Reply-To: 
 <CAN0SRDEWatOY8T7+WL2-vkx1Qff=LjQ+biPSnT4JbnnmVtYvkA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/cbda445a-31c2-847e-69de-b80c90c9e78e%40joeconway.com>
Precedence: bulk

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