Substitution Variables...

[debfawn]

Hi,

I have a quick question about variables in vsql. I'd like to set up a variable that I can use as text in a SELECT statement.

This is what I tried, but I get an error:

Code: Select all

dbadmin=> \set myname debbie
dbadmin=> \echo myname
myname
dbadmin=> select 'My name is ' || :myname;
ERROR 2624:  Column "debbie" does not exist

Is there something special I need to do so that I can get this result?

Code: Select all

dbadmin=> select 'My name is ' || :myname;
     ?column?
-------------------
 My name is debbie

Thanks!

[doug_harmon]

Code: Select all

dbadmin=> \set myname '''' debbie ''''
dbadmin=> select 'My name is ' || :myname ;
     ?column?
-------------------
 My name is debbie
(1 row)

[debfawn]

Your name is debbie too?!?!

Just kidding! Thanks, Doug! Now I can use this syntax in my scripts!