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
[EMAIL PROTECTED]
---------------------------------------------------------
