|
Hello, all. I’m trying to build a query that joins several information_schema views. The role I’m using has SELECT and USAGE permissions into the account whose tables I care about. I connect as the role and run this: select count(*) from information_schema.table_constraints; count ------- 1125 (1 row) All good. Now I run this: select count(*) from information_schema.constraint_column_usage; count ------- 0 (1 row) This view is missing data on several foreign key constraints that exist in the schema I care about. When I run these queries as ‘postgres’, they work fine (naturally). What permissions do I need to grant the querying role so it can see the constraint columns belonging to another schema? Why does querying on the table_constraints view work, but on constraint_column_usage not work?
This message is intended only for the recipient(s) to which it is addressed and may contain information that is privileged and confidential. If you have received this message in error, please notify the sender immediately
and delete all copies. |
BEGIN:VCARD VERSION:2.1 N:Fritz;Erwin;;; ORG:GLJ Petroleum Consultants TITLE:IS Operations Manager EMAIL;PREF;internet:efritz@xxxxxxxxx TEL;VOICE;WORK:+1 (403) 266-9570 TEL;FAX;WORK:+1 (403) 262-1855 ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 4100, 400 Third Ave SW;Calgary;Alberta;T2P 4H2;Canada FN:Erwin Fritz REV:20180907T151644Z END:VCARD
