How to find rows that violate foreign key constraint?

Question

My user table is referenced in multiple tables. Is there some way to find which all rows in my user table is referenced in other tables without checking with individual tables that reference user table?

If i try to delete a user, posgres shows me

ERROR:  update or delete on table "user" violates foreign key constraint "user _client_fkey" on table "client"
DETAIL:  Key (id)=(1) is still referenced from table "user".

Using this feature is there some way can i get all the userids that are referenced in other tables?

https://stackoverflow.com/questions/1152260/postgres-sql-to-list-table-foreign-keys — lat long, Dec 14 '17 at 05:52

score 0 · Answer 1 · answered Dec 12 '18 at 20:22

0

Sure just do a 'select * from client where user_id = 1;

answered Dec 12 '18 at 20:22

Mr Chow

365
6
10

How to find rows that violate foreign key constraint?

1 Answers1