Hello \set removes outer quotes if you use PostgreSQL 9.0 you can use \set xxx 'Pavel ''StÄhule' postgres=# \set AUTOCOMMIT = 'on' PROMPT1 = '%/%R%# ' PROMPT2 = '%/%R%# ' PROMPT3 = '>> ' VERBOSITY = 'default' VERSION = 'PostgreSQL 9.1beta1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.5.1 20100924 (Red Hat 4.5.1-4), 64-bit' DBNAME = 'postgres' USER = 'pavel' PORT = '5432' ENCODING = 'UTF8' EDITOR_LINENUMBER_SWITCH = '+' HISTSIZE = '6000' HISTFILE = '~/.psql_history-5432' xxx = 'Pavel 'StÄhule' postgres=# \echo :'xxx' 'Pavel ''StÄhule' Regards Pavel 2011/6/1 Prafulla Tekawade <prafulla.tekawade@xxxxxxxxx>: > 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
