Running a query from the OS CLI

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Running a query from the OS CLI
Date: 2007-08-08 18:13:59
Message-ID: D7FF158337303A419CF4A183F48302D602F19224@hdsmsx411.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I have a DB called "foo"

...and...

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

...and...

I want no table header "NAME" in the output

...and...

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

...and...

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

Is this possible?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johan Runnedahl 2007-08-08 18:24:04 Installing Postgresql 8.2 on Windows Vista
Previous Message luca.ciciriello 2007-08-08 17:55:45 Re: PostgreSQL and cluster