Re: Running queries from scripts.

Hi,

It works for me, for example, this way:
athens% psql -d template1 -c "select datname from pg_database"
datname
-----------
template1
postgres
biology
test
(4 rows)

Hope this helps,
-Rita

On Thu, 6 Jul 2000, DalTech - Continuing Technical Education wrote:

> I was wondering if anyone could help me out with the syntax of running queries from a unix script.
>
> psql -c select 'I am a dummy' -d dbname - never seems to work. I've tried variations on the command line, but to no success.
>
> Does the -c option work?
>
> Cheers,
> Christopher Currie
>
> __________________________________
> Dalhousie: DalTech - CTE
> Visit our Web site at http://www.cte.dal.ca
> (902) 494-6079
> (800) 565-1179
>

--------------------------------------------------------
Margarita Barvinok University of Michigan
System Administrator II Department of Biology
brita(at)umich(dot)edu
---------------------------------------------------------