Re: Formating psql query output

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Formating psql query output
Дата
Msg-id 4f001abb-7f6d-d098-ed10-1c5445c0ba1c@aklaver.com
обсуждение исходный текст
Ответ на Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Formating psql query output  (Rob Sargent <robjsargent@gmail.com>)
Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: David Santamauro
Дата:
Сообщение: Re: Formating psql query output
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Formating psql query output