Re: psql scripting tutorials - Mailing list pgsql-general

From aklaver@comcast.net (Adrian Klaver)
Subject Re: psql scripting tutorials
Date
Msg-id 091120081710.2802.48C951120001491600000AF222069997359D0A900E04050E@comcast.net
Whole thread Raw
In response to psql scripting tutorials  (Artacus <artacus@comcast.net>)
List pgsql-general
-------------- Original message ----------------------
From: "Roderick A. Anderson" <raanders@acm.org>
> Kevin Hunter wrote:
> > At 7:13am -0400 on Thu, 11 Sep 2008, Harald Fuchs wrote:
> >> Nice trick, but when I try the following variant:
> >>
> >>   psql -v TEST=16 -c 'select :TEST as "input"'
> >>
> >> I get [a syntax error]
> >
> >> This seems to be contrary to the psql manual page:
> >
> > Nope.  Take a look at the -c option.  Specifically "Thus you cannot mix
> > SQL and psql meta-commands with this option."
> >
> > You might try shell interpretation:
> >
> > $ TEST=16; psql -c "select $TEST as \"input1\";"
> > $ TEST=16; echo "select $TEST as \"input1\";" | psql
>
> Whatever happened to pgbash?  I see the last update was Feb 2003 but
> that was for Pg v7.3.
>
>
> Rod
> --
> >
> > Kevin
> >
>
>

See also:
http://www.edlsystems.com/shellsql/
http://pgfoundry.org/projects/plsh/
--
Adrian Klaver
aklaver@comcast.net




pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: psql scripting tutorials
Next
From: Alan Hodgson
Date:
Subject: Re: "Healing" a table after massive updates