Find foreign keys referencing a table: postgres

daniel —Mon, 12/17/2012 - 4:05pm

SELECT tc.table_schema, tc.constraint_name, tc.table_name, kcu.column_name, ccu.table_name AS foreign_table_name, ccu.column_name AS foreign_column_name FROM information_schema.table_constraints tc JOIN information_schema.key_column_usage kcu ON tc.constraint_name = kcu.constraint_name JOIN information_schema.constraint_column_usage ccu ON ccu.constraint_name = tc.constraint_name WHERE constraint_type = 'FOREIGN KEY' AND ccu.table_name='myTableName'

From: errorbank.blogspot.com

Navigation

Quotes

daniel —Wed, 03/04/2009 - 8:33am

We must not let our rulers load us with perpetual debt. We must make our election between economy and liberty or profusion and servitude. If we run into such debt, as that we must be taxed in our meat and in our drink, in our necessaries and our comforts, in our labors and our amusements, for our calling and our creeds...[we will] have no time to think, no means of calling our miss-managers to account but be glad to obtain subsistence by hiring ourselves to rivet their chains on the necks of our fellow-sufferers... And this is the tendency of all human governments. A departure from principle in one instance becomes a precedent for[ another]... till the bulk of society is reduced to be mere automatons of misery... And the fore-horse of this frightful team is public debt. Taxation follows that, and in its train wretchedness and oppression.

—

Thomas Jefferson

Log in to post comments
daniel's quotes

BowerStudios.com