Re: psql \echo strangeness with :variables

[ptjm@xxxxxxxxxxxx (Patrick TJ McPhee)]

In article <m3ejyjp2d8.fsf@xxxxxxxxxxxxxxxxxxxxxxx>,
Jerry Sievers <jerry@xxxxxxxxxxxxxxxx> wrote:

% jsievers@jsievers#
% = \set date `date '+%Y%m%d'`
% 
% jsievers@jsievers#
% = \echo :date
% 20060524
% 
% jsievers@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@xxxxxxxxxxxx