Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: psql \echo strangeness with :variables
- From: ptjm(at)interlog(dot)com (Patrick TJ McPhee)
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: psql \echo strangeness with :variables
- Date: 25 May 2006 04:38:16 GMT
- Message-id: <4dkqloF1a6g4aU1(at)uni-berlin(dot)de>
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
- References:
- psql \echo strangeness with :variables
- From: Jerry Sievers
- psql \echo strangeness with :variables
- Prev by Date: Re: New DBs from existing schemas
- Next by Date: Re: I dont get it,
- Previous by thread: psql \echo strangeness with :variables
- Next by thread: recompliing c-language functions with new releases of postgres
- Indexes: