Psql Internal Variable question - Mailing list pgsql-general

From Prafulla Tekawade
Subject Psql Internal Variable question
Date
Msg-id BANLkTimvW4TXJb2FXmiaAN450bnR6hW0_w@mail.gmail.com
Whole thread Raw
List pgsql-general

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



pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Consistency of distributed transactions
Next
From: Brendan Jurd
Date:
Subject: Re: search_path versus dynamic CREATE SCHEMA