information_schema中的所有表和视图

select table_name from information_schema.tables where table_schema = ‘information_schema’;

“attributes”
“character_sets”
“check_constraint_routine_usage”
“information_schema_catalog_name”
“applicable_roles”
“administrable_role_authorizations”
“check_constraints”
“collations”
“collation_character_set_applicability”
“column_domain_usage”
“column_privileges”
“column_udt_usage”
“columns”
“constraint_column_usage”
“constraint_table_usage”
“domain_constraints”
“domain_udt_usage”
“domains”
“enabled_roles”
“key_column_usage”
“parameters”
“referential_constraints”
“role_column_grants”
“routine_privileges”
“role_routine_grants”
“routines”
“schemata”
“sequences”
“sql_features”
“sql_implementation_info”
“sql_languages”
“sql_packages”
“sql_parts”
“sql_sizing”
“sql_sizing_profiles”
“table_constraints”
“table_privileges”
“role_table_grants”
“tables”
“transforms”
“triggered_update_columns”
“triggers”
“udt_privileges”
“role_udt_grants”
“usage_privileges”
“role_usage_grants”
“user_defined_types”
“view_column_usage”
“view_routine_usage”
“view_table_usage”
“views”
“data_type_privileges”
“element_types”
“_pg_foreign_table_columns”
“column_options”
“_pg_foreign_data_wrappers”
“foreign_data_wrapper_options”
“foreign_data_wrappers”
“_pg_foreign_servers”
“foreign_server_options”
“foreign_servers”
“_pg_foreign_tables”
“foreign_table_options”
“foreign_tables”
“_pg_user_mappings”
“user_mapping_options”
“user_mappings”

参考：http://www.postgresql.org/docs/9.1/static/information-schema.html