Hi,
I am trying to use psql \set and \echo commands to set some internal variables.
My variable starts with single quote and ends with single quote.
That is actual value of the variable.
Eg.
set cur_db 'pgdb'
\echo :cur_db
--I am expecting here 'pgdb' but psql shows pgdb
As mentioned above, I am expecting \echo to return 'pgdb' to me but it returns pgdb.
I tried using escape char, but it did not work.
Can somebody help me?
--
Best Regards,
Prafulla V Tekawade