Josh Berkus <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers