List foreign keys dependencies that refer to a given table
You are looking for the columns confupdtype and confdeltype in the catalog pg_constraint.

The codes mean:


  Foreign key deletion action code: a = no action, r = restrict, c = cascade, n = set null, d = set default