Thanks, I had tried the semi-colon, it's the unusual quoting syntax I was
Is that the only way you can quote it to make a string work?
From: John DeSoi [mailto:desoi(at)pgedit(dot)com]
Sent: Thursday, March 24, 2005 5:07 PM
To: Walker, Jed S
Subject: Re: [NOVICE] psql questions
On Mar 24, 2005, at 6:29 PM, Walker, Jed S wrote:
> How can do those things in psql? (I found the \set which seems to
> work, no
> error, but I can't figure out how to use the variable in a psql
You prefix the variable with a colon to get the value. Here are a few
\set mystring '\'here is a string\''
select :mystring || ' test';
here is a string test
\set myint 37
select :myint + 10;
John DeSoi, Ph.D.
Power Tools for PostgreSQL
pgsql-novice by date
|Next:||From: Michelle Konzack||Date: 2005-03-25 15:48:50|
|Subject: Re: install pgaccess under windows xp|
|Previous:||From: John DeSoi||Date: 2005-03-25 13:52:00|
|Subject: Re: stored procedures?|