Information schema

The information schema consists of a set of views that contain information about the objects defined in the current database.

The following table provides an overview of the PostgreSQL views.

View	Description
administrable_role_authorizations	Provides information about all roles for which the current user has administrative privileges.
applicable_roles	Provides information about all roles whose privileges the current user can use.
attributes	Provides information about the attributes of composite data types defined in the database.
character_sets	Provides information about all character sets available in the current database.
check_constraint_routine_usage	Provides information about routines used by check constraints.
check_constraints	Provides information about all check constraints owned by currently enabled roles.
collations	Provides information about collations available in the current database.
collation_character_set_applicability	Provides information about character sets to which available collations apply.
columns	Provides information about all table or view columns in the database.
column_column_usage	Provides information about generated columns that depend on other base columns.
column_domain_usage	Provides information about columns that use domains owned by currently enabled roles.
column_options	Provides information about options defined for foreign table columns.
column_privileges	Provides information about privileges granted on columns.
column_udt_usage	Provides information about columns that use data types owned by currently enabled roles.
constraint_column_usage	Provides information about columns used by constraints.
constraint_table_usage	Provides information about tables used by constraints.
domains	Provides information about all domains defined in the database.
domain_constraints	Provides information about all domain constraints.
domain_udt_usage	Provides information about domains based on owned data types.
element_types	Provides information about element types used by arrays.
foreign_data_wrappers	Provides information about all foreign-data wrappers in the database.
foreign_data_wrapper_options	Provides information about foreign-data wrapper options.
foreign_servers	Provides information about foreign servers defined in the database.
foreign_server_options	Provides information about options defined for foreign servers.
foreign_tables	Provides information about all foreign tables in the database.
foreign_table_options	Provides information about options defined for foreign tables.
information_schema_catalog_name	Provides information about a table in the information schema that always contains exactly one row and one column, representing the name of the current database.
key_column_usage	Provides information about columns restricted by key constraints.
parameters	Provides information about parameters of functions and procedures.
referential_constraints	Provides information about referential (foreign key) constraints.
role_column_grants	Provides information about privileges granted on columns.
role_routine_grants	Provides information about privileges granted on routines.
role_table_grants	Provides information about privileges granted on tables or views.
role_udt_grants	Provides information about USAGE privileges on user-defined types.
role_usage_grants	Provides information about USAGE privileges on various object types.
routines	Provides information about all routines (functions and procedures).
routine_column_usage	Provides information about columns used by routines.
routine_privileges	Provides information about privileges granted on routines.
routine_sequence_usage	Provides information about sequences used by routines.
routine_table_usage	Provides information about tables used by routines.
schemata	Provides information about all schemas accessible to the current user.
sequences	Provides information about all sequences in the database.
sql_features	Provides information about SQL standard features supported by PostgreSQL.
sql_implementation_info	Provides information about implementation-defined SQL characteristics.
sql_parts	Provides information about SQL standard parts supported by PostgreSQL.
sql_sizing	Provides information about PostgreSQL size limits and maximum values.
tables	Provides information about all tables and views.
table_constraints	Provides information about table constraints for accessible tables.
table_privileges	Provides information about privileges granted on tables and views.
transforms	Provides information about transforms defined in the database.
triggers	Provides information about all triggers on tables and views.
triggered_update_columns	Provides information about columns affected by UPDATE OF triggers.
udt_privileges	Provides information about USAGE privileges on user-defined types.
usage_privileges	Provides information about USAGE privileges on various database objects.
user_defined_types	Provides information about composite types defined by users.
user_mappings	Provides information about all user mappings.
user_mapping_options	Provides information about options associated with user mappings.
views	Provides information about all views defined in the database.
view_column_usage	Provides information about columns used in view definitions.
view_routine_usage	Provides information about routines used in view definitions.
view_table_usage	Provides information about tables used in view definitions.