Add foreign key details to postgres_foreign_keys view

What does this MR do and why?

Describe in detail what your merge request does and why.

Adds additional information to the postgres_foreign_keys view. This information is necessary for recreating foreign keys to fix #383310 (closed).

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.