Re: psql \echo strangeness with :variables

In article <m3ejyjp2d8(dot)fsf(at)prod01(dot)jerrysievers(dot)com>,
Jerry Sievers <jerry(at)jerrysievers(dot)com> wrote:

% jsievers(at)jsievers#
% = \set date `date '+%Y%m%d'`
%
% jsievers(at)jsievers#
% = \echo :date
% 20060524
%
% jsievers(at)jsievers#
% = \echo foo_:date
% foo_:date <-- Was expecting this to expand... see below

variables need to be space-delimited in \ contexts. Work-around:

\set tn 'foo_' :date
\echo :tn
create table :tn();

--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com