Re: psql scripting tutorials

-------------- 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