how to check whether on delete property is set or not in a foreign key constraint in postgresql?

Question

Is there is any query to check whether "on delete" property is being set or not set in a foreign key constraint in postgresql ?

score 1 · Accepted Answer · answered Mar 04 '14 at 11:15

1

You can query the INFORMATION_SCHEMA:

SELECT  UPDATE_RULE, DELETE_RULE
FROM    INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
WHERE   CONSTRAINT_NAME = 'FK_YourForeignKey';

answered Mar 04 '14 at 11:15

GarethD

score 0 · Answer 2 · answered Mar 04 '14 at 11:21

The pg_constraint table in the system catalog contains this information. You can query that:

select confdeltype from pg_constraint where conrelid=xx and contype='f' and conname='xxxx';

The where clauses here are an example - tweak them to suit.

2 Answers2