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?
--
Thanks
Prafulla