Re: Running a query from the OS CLI - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Running a query from the OS CLI
Date
Msg-id 84D155BE-7F21-4565-AD9B-C4C788852F73@seespotcode.net
Whole thread Raw
In response to Running a query from the OS CLI  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Running a query from the OS CLI  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Aug 8, 2007, at 13:13 , Gauthier, Dave wrote:

> If I have a DB called "foo"

psql --dbname "foo"

>
> ...and...
>
> I want to run "select name from table_a where name like 'john%'"

psql --dbname "foo" -c "select name from table_a where name like 'john
%'"

>
> ...and...
>
> I want no table header "NAME" in the output

psql --dbname "foo" -c "select name from table_a where name like 'john
%'" -t

>
> ...and...
>
> I want to do this as a one-liner from the linux command line

check.

>
> ...and...
>
> I don't want to have to deal with intermediate files or home-grown
> programs...

Does that work?

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Running a query from the OS CLI
Next
From: Steve Atkins
Date:
Subject: Re: Running a query from the OS CLI