Re: psql scripting tutorials - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: psql scripting tutorials
Date
Msg-id 20080911143252.GA9492@alvh.no-ip.org
Whole thread Raw
In response to Re: psql scripting tutorials  (Harald Fuchs <hari.fuchs@gmail.com>)
List pgsql-general
Harald Fuchs escribió:

> Nice trick, but when I try the following variant:
>
>   psql -v TEST=16 -c 'select :TEST as "input"'
>
> I get
>
>   ERROR:  syntax error at or near ":"
>   LINE 1: select :TEST as "input"
>
> This seems to be contrary to the psql manual page:
>
>  These assignments are done during a very early stage of start-up...

Seems like a bug in -c ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: "Healing" a table after massive updates
Next
From: Alvaro Herrera
Date:
Subject: Re: "Healing" a table after massive updates