Chapter 48. System Catalogs

Table of Contents

48.1. Overview
48.2. lt_attri_ext
48.3. lt_database_ext
48.4. lt_global_temp_table_ext
48.5. lt_object_ext
48.6. lt_package
48.7. lt_partition_ext
48.8. lt_proc_ext
48.9. lt_trigger_ext
48.10. lt_recyclebin
48.11. lt_type_ext
48.12. lt_variable
48.13. lt_namespace_ext
48.14. pg_aggregate
48.15. pg_am
48.16. pg_amop
48.17. pg_amproc
48.18. pg_attrdef
48.19. pg_attribute
48.20. pg_authid
48.21. pg_auth_members
48.22. pg_cast
48.23. pg_class
48.24. pg_collation
48.25. pg_constraint
48.26. pg_conversion
48.27. pg_database
48.28. pg_db_role_setting
48.29. pg_default_acl
48.30. pg_depend
48.31. pg_description
48.32. pg_enum
48.33. pg_event_trigger
48.34. pg_extension
48.35. pg_foreign_data_wrapper
48.36. pg_foreign_server
48.37. pg_foreign_table
48.38. pg_index
48.39. pg_inherits
48.40. pg_init_privs
48.41. pg_language
48.42. pg_largeobject
48.43. pg_largeobject_metadata
48.44. pg_namespace
48.45. pg_opclass
48.46. pg_operator
48.47. pg_opfamily
48.48. pg_partitioned_table
48.49. pg_policy
48.50. pg_proc
48.51. pg_publication
48.52. pg_publication_rel
48.53. pg_range
48.54. pg_replication_origin
48.55. pg_rewrite
48.56. pg_seclabel
48.57. pg_sequence
48.58. pg_shdepend
48.59. pg_shdescription
48.60. pg_shseclabel
48.61. pg_statistic
48.62. pg_statistic_ext
48.63. pg_statistic_ext_data
48.64. pg_subscription
48.65. pg_subscription_rel
48.66. pg_tablespace
48.67. pg_trigger
48.68. pg_ts_config
48.69. pg_ts_config_map
48.70. pg_ts_dict
48.71. pg_ts_parser
48.72. pg_ts_template
48.73. pg_type
48.74. pg_user_mapping
48.75. System Views
48.76. pg_available_extensions
48.77. pg_available_extension_versions
48.78. pg_config
48.79. pg_cursors
48.80. pg_file_settings
48.81. pg_group
48.82. pg_hba_file_rules
48.83. pg_indexes
48.84. pg_locks
48.85. pg_policies
48.86. pg_prepared_statements
48.87. pg_prepared_xacts
48.88. pg_publication_tables
48.89. pg_replication_origin_status
48.90. pg_replication_slots
48.91. pg_roles
48.92. pg_rules
48.93. pg_seclabels
48.94. pg_sequences
48.95. pg_settings
48.96. pg_shadow
48.97. pg_shmem_allocations
48.98. pg_stats
48.99. pg_stats_ext
48.100. pg_tables
48.101. pg_timezone_abbrevs
48.102. pg_timezone_names
48.103. pg_user
48.104. pg_user_mappings
48.105. pg_views
48.106. Oracle Compatible System View
48.106.1. [DBA/ALL/USER]_SEQUENCES
48.106.2. [DBA/ALL/USER]_SYNONYMS
48.106.3. [DBA/ALL/USER]_TAB_COLS, COLS, [DBA/ALL/USER]_TAB_COLUMNS
48.106.4. [DBA/ALL/USER]_TAB_COL_STATISTICS
48.106.5. [DBA/ALL/USER]_OBJECTS, OBJ
48.106.6. [DBA/ALL/USER]_CATALOG
48.106.7. DICTIONARY, DICT
48.106.8. [DBA/ALL/USER]_DEPENDENCIES
48.106.9. [DBA/ALL/USER]_SOURCE
48.106.10. [DBA/ALL/USER]_PROCEDURES
48.106.11. [DBA/ALL/USER]_TRIGGERS
48.106.12. [DBA/ALL/USER]_TRIGGER_COLS
48.106.13. [DBA/ALL/USER]_TYPES
48.106.14. [DBA/ALL/USER]_CONSTRAINTS
48.106.15. [DBA/ALL/USER]_CONS_COLUMNS
48.106.16. [DBA/ALL/USER]_VIEWS
48.106.17. [DBA/ALL/USER]_TABLES, [DBA/ALL/USER]_ALL_TABLES, TAB
48.106.18. [DBA/ALL/USER]_TAB_STATISTICS
48.106.19. [DBA/ALL/USER]_TAB_COMMENTS
48.106.20. [DBA/ALL/USER]_COL_COMMENTS
48.106.21. [DBA/ALL/USER]_TAB_MODIFICATIONS
48.106.22. [DBA/ALL/USER]_INDEXES, IND
48.106.23. [DBA/ALL/USER]_INDEX_USAGE
48.106.24. [DBA/ALL/USER]_IND_COLUMNS
48.106.25. [DBA/ALL/USER]_IND_EXPRESSIONS
48.106.26. [DBA/ALL/USER]_IND_STATISTICS
48.106.27. [DBA/ALL/USER]_USERS
48.106.28. DBA_ROLES
48.106.29. [DBA/USER]_ROLE_PRIVS
48.106.30. PRODUCT_COMPONENT_VERSION
48.106.31. PLAN_TABLE
48.106.32. DBA_DATA_FILES
48.106.33. [DBA/ALL/USER]_JOBS
48.106.34. DBA_JOBS_RUNNING
48.106.35. [DBA/USER]_TABLESPACES
48.106.36. NLS_[DATABASE/INSTANCE/SESSION]_PARAMETERS
48.106.37. [DBA/USER]_SEGMENTS
48.106.38. [DBA/USER/ALL]_PART_TABLES
48.106.39. [DBA/USER/ALL]_TAB_PARTITIONS
48.106.40. [DBA/USER/ALL]_TAB_SUBPARTITIONS
48.106.41. [DBA/USER/ALL]_PART_KEY_COLUMNS
48.106.42. [DBA/USER/ALL]_SUBPART_KEY_COLUMNS
48.106.43. [DBA/USER/ALL]_IND_PARTITIONS
48.106.44. [DBA/USER/ALL]_PART_INDEXES
48.106.45. COL
48.106.46. [DBA/USER]_RECYCLEBIN

The system catalogs are the place where a relational database management system stores schema metadata, such as information about tables and columns, and internal bookkeeping information. LightDB's system catalogs are regular tables. You can drop and recreate the tables, add columns, insert and update values, and severely mess up your system that way. Normally, one should not change the system catalogs by hand, there are normally SQL commands to do that. (For example, CREATE DATABASE inserts a row into the pg_database catalog — and actually creates the database on disk.) There are some exceptions for particularly esoteric operations, but many of those have been made available as SQL commands over time, and so the need for direct manipulation of the system catalogs is ever decreasing.