Документация по PostgreSQL 8.2devel
Prev	Fast Backward		Fast Forward	Next

Chapter 31. The Information Schema

Table of Contents
31.1. The Schema
31.2. Data Types
31.3. information_schema_catalog_name
31.4. administrable_role_authorizations
31.5. applicable_roles
31.6. attributes
31.7. check_constraint_routine_usage
31.8. check_constraints
31.9. column_domain_usage
31.10. column_privileges
31.11. column_udt_usage
31.12. columns
31.13. constraint_column_usage
31.14. constraint_table_usage
31.15. data_type_privileges
31.16. domain_constraints
31.17. domain_udt_usage
31.18. domains
31.19. element_types
31.20. enabled_roles
31.21. key_column_usage
31.22. parameters
31.23. referential_constraints
31.24. role_column_grants
31.25. role_routine_grants
31.26. role_table_grants
31.27. role_usage_grants
31.28. routine_privileges
31.29. routines
31.30. schemata
31.31. sequences
31.32. sql_features
31.33. sql_implementation_info
31.34. sql_languages
31.35. sql_packages
31.36. sql_parts
31.37. sql_sizing
31.38. sql_sizing_profiles
31.39. table_constraints
31.40. table_privileges
31.41. tables
31.42. triggers
31.43. usage_privileges
31.44. view_column_usage
31.45. view_routine_usage
31.46. view_table_usage
31.47. views

The information schema consists of a set of views that contain information about the objects defined in the current database. The information schema is defined in the SQL standard and can therefore be expected to be portable and remain stable — unlike the system catalogs, which are specific to PostgreSQL and are modelled after implementation concerns. The information schema views do not, however, contain information about PostgreSQL-specific features; to inquire about those you need to query the system catalogs or other PostgreSQL-specific views.