PostgreSQL View the primary foreign key relationship for the current table

PostgreSQL see which references to the current table are referenced as reference tables

--pg_constraint.contype:p (primary key), F (foreign key), U (unique), C (check)
--View the current table ID
SELECT OID, relname from pg_class WHERE relname = ' syslogfilter ';
--View the primary foreign KEY constraint information referencing the current table ID as a reference table
SELECT * from pg_constraint WHERE confrelid = ' 24935 ';
--View the names of those foreign keys
SELECT OID, relname from Pg_class WHERE oid in
(
SELECT conrelid from pg_constraint WHERE confrelid = ' 24935 '
);

PostgreSQL View the primary foreign key relationship for the current table