VIEW NAME

DESCRIPTION

all_objects

All objects accessible to the currently logged in user.

all_synonyms

All public synonyms.

all_tab_columns

All columns in all tables that are accessible to the currently logged in user.

all_tables

All tables that are accessible to the currently logged in user.

all_users

A list of all database users.

all_view_columns

A list of all columns in all views – Non-Oracle standard.

all_views

A list of all views.

DBA_role_privs

A list of all privileges assigned to all roles.

DBA_roles

A list of all database roles.

product_component_version

Version related information.

user_objects

All objects owned by the currently logged in user.

user_synonyms

All public synonyms that are accessible to the currently logged in user.

user_tab_columns

All columns in all tables that are owned by the currently logged in user.

user_tables

All tables that are owned by the currently logged in user.

user_view_columns

A list of all columns in views owned by the current user – Non-Oracle standard.

user_views

A list of all views owned by the current user.

VIEW NAME

DESCRIPTION

sysindexes

All indexes in the database.

sysobjects

All objects in the database.

systables

All tables in the database.

systypes

All data types in the database.

sysusers

All users in the database.

VIEW NAME

DESCRIPTION

applicable_roles

All roles that are assigned to the current user.

check_constraints

All check constraints owned by the current user.

column_domain_usage

All columns using domains owned by the current user.

column_privileges

Privileges granted to columns.  EnterpriseDB only allows privileges to be granted at the table level.  Same information as table privileges.

column_udt_usage

All columns using data types owned by the current user.

columns

All columns in the objects owned or accessible by the current user.

constraint_column_usage

All columns that are used in any type of constraint in any type of object owned by the current user.

constraint_table_usage

All tables that are referenced in any type of constraint in any type of object owned by the current user.

data_type_privileges

All data types that the current user has used in some type of database object.

domain_constraints

All constraints on any domains owned by the current user.

domain_udt_usage

All domains using data types owned by the current user.

domains

All domains in the database.  A domain is a data type that has constraints applied to it, much like a sub-type in Oracle.

element_types

All defined array elements in any object owned or accessible by the current user.

enabled_roles

The same as accessible_roles.

information_schema_catalog_name

The name of the current database.  In EnterpriseDB, every database has its own information_schema catalog.

key_column_usage

All columns that are contained in a Primary Key, Unique Key or Foreign Key in a table owned by the current user.

parameters

All parameters in all stored procedures and functions owned or accessible by the current user.

referential_constraints

All foreign key constraints defined in any table owned by the current user.

role_column_grants

Privileges granted to columns.  EnterpriseDB only allows privileges to be granted at the table level.  Same as column_privileges.

role_routine_grants

All grants on a stored procedure or function to a role in which the current user is a member.  Same as routine_privileges.

role_table_grants

All grants on a table to a role in which the current user is a member.  Same as table_privileges.

role_usage_grants

Empty view.  For future use.

routine_privileges

All grants on any stored procedure or function to the current user or by the current user.

routines

All stored procedures and functions owned or accessible by the current user.

schemata

All schemas in the current database that are owned by the current user.  Unlike Oracle where a schema is a user, a schema in EnterpriseDB is a completely separate concept and only serves as a logical holding place for database objects.

sql_features

Features supported by the current implementation of EnterpriseDB.

sql_implementation_info

Implementation specific features of the current implementation of EnterpriseDB.

sql_languages

SQL Languages supported by EnterpriseDB. Just SQL and Embedded SQL.

sql_packages

The same basic data as sql_features.

sql_sizing

Database limits and maximums.  Cool stuff like maximum table name length, maximum number of columns in a select, etc.  Interesting to investigate.

sql_sizing_profiles

Empty.

table_constraints

All constraints defined in any table owned by the current user.

table_privileges

All grants to a table or view owned or accessible by the current user.

tables

All tables owned or accessible by the current user.

triggered_update_columns

Columns explicitly listed in a for update of table trigger.

triggers

All triggers owned by the current user.

usage_privileges

Grants to public domains.

view_column_usage

All columns used in any view owned by the current user.

view_table_usage

All tables used in any view owned by the current user.

views

All views owned or accessible by the current user.

VIEW NAME

DESCRIPTION

edb_package

All package source code.

edb_pkgelements

All package spec level procedure and function declarations.

pg_aggregate

All defined aggregate functions, including SQL supplied.

pg_am

All index access methods.

pg_amop

All access method operators.

pg_amproc

All access method procedures.

pg_attrdef

All column default values.

pg_attribute

All table columns.

pg_authid

All authorized users and groups (roles).

pg_auth_members

Relationships between roles.

pg_autovacuum

Auto-vacuum settings by table.

pg_buffercache

Realtime information about queries in the buffercache.

pg_cast

All possible data type casts.

pg_class

All table-like objects.

pg_constraint

All defined constraints.

pg_conversion

Language encoding information.

pg_database

Information about all databases in the current cluster.

pg_depend

Dependencies between objects, like all_dependcies in Oracle.

pg_description

Database object comments.

pg_function

All functions in the database.

pg_group

All database groups.

pg_index

Index information.

pg_indexes

Index information with table.

pg_inherits

Parent/Child table inheritance relationships.

pg_language

All procedural languages defined (Like EnterpriseDB SPL and PL/pgSQL)

pg_largeobject

Large objects populated via the lo_* support functions.

pg_listener

Used for events (like alerts).

pg_locks

All transaction locks in the database.

pg_namespace

Schema information.

pg_opclass

Index access methods.

pg_operator

SQL operators.

pg_pltemplate

Template data for pre-defined procedural languages.

pg_prepared_xacts

Prepared Two Phase Commit Transactions.

pg_proc

All stored procedures and functions.

pg_procedure

All user stored procedures.

pg_rewrite

Query rewrite rules.

pg_shadow

All database users.

pg_shdepend

Dependencies on shared objects, i.e. users/tables/roles.

pg_stat_*

General server activity and row-level access statistics.

pg_statio_*

Disk-block-level access statistics.

pg_statistic

Planner statistics.

pg_stats

View over pg_statistic.

pg_synonym

All public synonyms.

pg_tablespace

All tablespaces.

pg_trigger

All triggers.

pg_type

All database data types.

pg_roles

All database roles.

pg_rules

All database rules.

pg_settings

Transaction way to change or view parameter settings.

pg_tables

All tables.

pg_user

All database users.

pg_views

All database views.