Re: psql \echo strangeness with :variables

In article <m3ejyjp2d8.fsf@prod01.jerrysievers.com>,
Jerry Sievers <jerry@jerrysievers.com> 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@interlog.com