Re: SQL from Linux command line

> Scott Geller <geller(dot)subscribe(at)gmail(dot)com> wrote:
> > Hello
> >
> > Hoping for some help on this one....
> >
> > I need to query postgres, run a count of specific records, and write to
> > a different table based on the results all from the linux command
> > line.
> >
> > My questions are:
> > 1. Would I use psql for this?
> > 2. If so, how do I structure the script to run psql from Linux?
> > 3. how do I pass the value for the where clause from the command line
> > into the
> >
> > code?

Using Perl would be a lot easier.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."