Re: Analyze plan of foreign data wrapper - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Analyze plan of foreign data wrapper
Date
Msg-id 1530220664.3220.2.camel@cybertec.at
Whole thread Raw
In response to Analyze plan of foreign data wrapper  (Mathieu PUJOL <mathieu.pujol@realfusio.com>)
Responses Re: Analyze plan of foreign data wrapper  (Mathieu PUJOL <mathieu.pujol@realfusio.com>)
List pgsql-general
Mathieu PUJOL wrote:
> I'am writing a foreign data wrapper. To avoid returning data for a column that is not used, I parse 'targetlist' and
'qual'of the Plan.
 
> I'am able to find Var nodes but I can't figure out how i could now if this node is related to a column my foreign
table.

For a Var v, v->varattno contains the attribute number of the column.
That is the same as the attnum column in pg_attribute.

If v->varattno == 0, it is a whole-row reference, like in

   SELECT mytab FROM mytab;

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: plperl and plperlu language extentsions
Next
From: Thomas Munro
Date:
Subject: Re: incorrect resource manager data checksum in record