From: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
---|---|
To: | 'John DeSoi' <desoi(at)pgedit(dot)com> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: psql questions |
Date: | 2005-03-25 15:23:26 |
Message-ID: | 41669DC6FE3B80449A33A4DD46DB370A09E7E8B1@entcoexch15.broadband.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi John,
Thanks, I had tried the semi-colon, it's the unusual quoting syntax I was
missing.
\set '/'jed\''
select :jed;
Is that the only way you can quote it to make a string work?
-----Original Message-----
From: John DeSoi [mailto:desoi(at)pgedit(dot)com]
Sent: Thursday, March 24, 2005 5:07 PM
To: Walker, Jed S
Cc: 'pgsql-novice(at)postgresql(dot)org'
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
> session)
You prefix the variable with a colon to get the value. Here are a few
examples:
\set mystring '\'here is a string\''
select :mystring || ' test';
?column?
----------------------
here is a string test
(1 row)
\set myint 37
select :myint + 10;
?column?
----------
47
(1 row)
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Konzack | 2005-03-25 15:48:50 | Re: install pgaccess under windows xp |
Previous Message | John DeSoi | 2005-03-25 13:52:00 | Re: stored procedures? |