Josh Berkus <josh@agliodbs.com> writes:
> By information_schema, you wouldn't have any idea that errors_file_fkey
> is defined on the table Errors, let alone what columns it's defined
> against.
Look into key_column_usage.
> I'm happy to write some code to fix it, if we can agree what these views
> should show. I think constraint_column_usage and constraint_table_usage
> should be showing the data of both the referenced and referencing tables.
You might think that, but the specification is 100% clear that you're
wrong.
regards, tom lane