From: | Scott Geller <geller(dot)subscribe(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | SQL from Linux command line |
Date: | 2010-07-10 05:25:16 |
Message-ID: | AANLkTikRXpEkzPn6n6APdRhaKfk7qMK0KhiU5wJVw_Ss@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
This feels like it should be simple, but I'm new to postgres and could use
some help.
I'm good with the SQL part - for the SQL, I would write:
create table2 as select *, case when _cnt_ < 50 then 'low' when _cnt_ >= 50
'high' end as cnt from (select id, count(*) as _cnt_ from table1 where id =
1234 group by id) a;
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?
Thanks!
Scott
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-07-10 06:42:37 | Re: SQL from Linux command line |
Previous Message | Jean-Yves F. Barbier | 2010-07-09 14:17:17 | Re: Storing the data on a portable extenal hard drive |