From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Formating psql query output |
Date: | 2021-07-19 17:33:02 |
Message-ID: | alpine.LNX.2.20.2107191021180.13362@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
The current command line is:
psql -d bustrac -f prospecting_log.sql -o contacts.txt --csv
However, using the --csv output conversion makes separate fields from a
varchar column that can contain commas with the text contents.
Without --csv I get normal psql output with column headings and separator
lines such as these:
person_nbr | act_date | act_type | notes | person_nbr | lname | fname | org_nbr | org_nbr | org_name
------------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------------+------------+---------+---------+----------------------
Is there an option that will retain the '|' separator but exclude the
headings? Reading the psql document page I don't see such an option.
TIA,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Basques, Bob (CI-StPaul) | 2021-07-19 17:41:24 | RE: Formating psql query output |
Previous Message | Adrian Klaver | 2021-07-17 17:33:41 | Re: Getting "ERROR: upper bound of FOR loop cannot be null" when trying to use a stored proc in a check constraint def. |