Josh Berkus 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.
Folks,
I've been trying to extract some information about referencing tables
from information_schema, and discovering that it isn't there.
For example, take the following FK, from table Errors to table Files:
CONSTRAINT errors_file_fkey FOREIGN KEY (file)
REFERENCES files (id) MATCH S
