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
Code: Select all
dbadmin=> select 'My name is ' || :myname;
?column?
-------------------
My name is debbie