Postgres Pro
Downloads
Home   >   mailing lists

Re: psql \echo strangeness with :variables - Mailing list pgsql-general

From ptjm@interlog.com (Patrick TJ McPhee)
Subject Re: psql \echo strangeness with :variables
Date
Msg-id 4dkqloF1a6g4aU1@uni-berlin.de
Whole thread Raw
In response to psql \echo strangeness with :variables  (Jerry Sievers <jerry@jerrysievers.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "xuemei"
Date:
Subject: Postgresql with Hibernate issues
Next
From: "Nik"
Date:
Subject: Re: Insert into partition table hangs