Re: Formating psql query output - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Formating psql query output
Date
Msg-id 4f001abb-7f6d-d098-ed10-1c5445c0ba1c@aklaver.com
Whole thread Raw
In response to Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Formating psql query output  (Rob Sargent <robjsargent@gmail.com>)
Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 7/19/21 10:33 AM, Rich Shepard wrote:
> Until I finish building the python/tkinter/psycopg2 front end to my 
> business
> tracking tool I continue to work using the psql shell.'
> 
> I have a working .sql script that reports my contacts between two dates; 
> the
> script returns more columns than I want included in the report. I want to
> pipe the output through an awk script to extract, in order, the columns I
> need. I'm stuck at the point of defining options to psql.

Is there a reason you can't just restrict the query to the columns you want?


> 
> TIA,
> 
> Rich
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: David Santamauro
Date:
Subject: Re: Formating psql query output
Next
From: Rob Sargent
Date:
Subject: Re: Formating psql query output