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

From Adrian Klaver
Subject Re: Formating psql query output
Date
Msg-id ab964598-22ac-5bcf-bc4a-3ff7166de5f1@aklaver.com
Whole thread Raw
In response to Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 7/19/21 11:58 AM, Rich Shepard wrote:
> On Mon, 19 Jul 2021, Adrian Klaver wrote:
> 
>> Is there a reason you can't just restrict the query to the columns you 
>> want?
> 
> Adrian,
> 
> As far as I know I need to specify FK and PK columns when tables are 
> joined;

You need them in the JOIN and/or WHERE sections, but not necessarily in 
the field list in the SELECT portion.

> I don't need those key columns in the output.
> 
> Thanks,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Formating psql query output
Next
From: Pavel Stehule
Date:
Subject: Re: Formating psql query output