regression | s8 | dbname | db1

(6 rows)

SELECT * FROM information_schema.user_mappings ORDER BY1, 2, 3;

SELECT * FROM information_schema.user_mappings ORDER BYlower(authorization_identifier), 2, 3;

authorization_identifier | foreign_server_catalog | foreign_server_name

--------------------------+------------------------+---------------------

foreign_data_user | regression | s4

foreign_data_user | regression | s8

PUBLIC | regression | s4

PUBLIC | regression | s8

PUBLIC | regression | st1

foreign_data_user | regression | s4

foreign_data_user | regression | s8

regress_test_role | regression | s5

regress_test_role | regression | s6

regress_test_role | regression | st1

(8 rows)

SELECT * FROM information_schema.user_mapping_options ORDER BY1, 2, 3, 4;

SELECT * FROM information_schema.user_mapping_options ORDER BYlower(authorization_identifier), 2, 3, 4;

authorization_identifier | foreign_server_catalog | foreign_server_name | option_name | option_value

--------------------------+------------------------+---------------------+-------------+--------------

foreign_data_user | regression | s8 | password | public

PUBLIC | regression | s4 | mapping | is public

PUBLIC | regression | st1 | modified | 1

foreign_data_user | regression | s8 | password | public

regress_test_role | regression | s5 | modified | 1

regress_test_role | regression | s6 | username | test

regress_test_role | regression | st1 | password | boo

SELECT*FROMinformation_schema.foreign_data_wrapper_optionsORDER BY1,2,3;

SELECT*FROMinformation_schema.foreign_serversORDER BY1,2;

SELECT*FROMinformation_schema.foreign_server_optionsORDER BY1,2,3;

SELECT*FROMinformation_schema.user_mappingsORDER BY1,2,3;

SELECT*FROMinformation_schema.user_mapping_optionsORDER BY1,2,3,4;

SELECT*FROMinformation_schema.user_mappingsORDER BYlower(authorization_identifier),2,3;

SELECT*FROMinformation_schema.user_mapping_optionsORDER BYlower(authorization_identifier),2,3,4;

SELECT*FROMinformation_schema.usage_privilegesWHERE object_typeLIKE'FOREIGN%'ORDER BY1,2,3,4,5;

SELECT*FROMinformation_schema.role_usage_grantsWHERE object_typeLIKE'FOREIGN%'ORDER BY1,2,3,4,5;

SET ROLE regress_test_role;