select owner, constraint_name, table_name, column_name, position from dba_cons_columns;
Is there any table like
dba_cons_columns in PostgreSQL database that we get the same information?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
PostgreSQL has the SQL_standard
information_schema which is actually a bunch of views backed by the
information_schema has a fixed structure as mandated by the standard, pg_catalog is liable to change between major PostgreSQL versions.
For the information you want it's probably the table