Postgres Pro
Downloads
Home   >   mailing lists

How can i pass variable in dblink_connect_u ? - Mailing list pgsql-sql

From aditya desai
Subject How can i pass variable in dblink_connect_u ?
Date
Msg-id CAN0SRDEWatOY8T7+WL2-vkx1Qff=LjQ+biPSnT4JbnnmVtYvkA@mail.gmail.com
Whole thread Raw
Responses Re: How can i pass variable in dblink_connect_u ?  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Clean up shop database
Next
From: Jian He
Date:
Subject: Offline HTML manual.