Tom Lane wrote:
> If the view were also supposed to show referenced columns, then I
> think we'd need an additional UNION arm that joined on confrelid and
> confkey[] instead of conrelid/conkey[]. But if I read SQL99
> correctly, only referencing not referenced columns are supposed to be
> shown.
It is supposed to show the referenced (primary key) columns.
Both the current behavior and his proposed correction are incorrect.
Will investigate later.