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

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

Solution

You can query the INFORMATION_SCHEMA:

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