1#@!#!123s

: / proc / self / root / opt / alt / postgresql11 / usr / share / doc / alt-postgresql11-9.2.24 / html /
Filename : catalogs.html
back
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>System Catalogs</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Internals"
HREF="internals.html"><LINK
REL="PREVIOUS"
TITLE="Executor"
HREF="executor.html"><LINK
REL="NEXT"
TITLE="Overview"
HREF="catalogs-overview.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Executor"
HREF="executor.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="internals.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Overview"
HREF="catalogs-overview.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="CATALOGS"
></A
>Chapter 45. System Catalogs</H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>45.1. <A
HREF="catalogs-overview.html"
>Overview</A
></DT
><DT
>45.2. <A
HREF="catalog-pg-aggregate.html"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
></A
></DT
><DT
>45.3. <A
HREF="catalog-pg-am.html"
><TT
CLASS="STRUCTNAME"
>pg_am</TT
></A
></DT
><DT
>45.4. <A
HREF="catalog-pg-amop.html"
><TT
CLASS="STRUCTNAME"
>pg_amop</TT
></A
></DT
><DT
>45.5. <A
HREF="catalog-pg-amproc.html"
><TT
CLASS="STRUCTNAME"
>pg_amproc</TT
></A
></DT
><DT
>45.6. <A
HREF="catalog-pg-attrdef.html"
><TT
CLASS="STRUCTNAME"
>pg_attrdef</TT
></A
></DT
><DT
>45.7. <A
HREF="catalog-pg-attribute.html"
><TT
CLASS="STRUCTNAME"
>pg_attribute</TT
></A
></DT
><DT
>45.8. <A
HREF="catalog-pg-authid.html"
><TT
CLASS="STRUCTNAME"
>pg_authid</TT
></A
></DT
><DT
>45.9. <A
HREF="catalog-pg-auth-members.html"
><TT
CLASS="STRUCTNAME"
>pg_auth_members</TT
></A
></DT
><DT
>45.10. <A
HREF="catalog-pg-cast.html"
><TT
CLASS="STRUCTNAME"
>pg_cast</TT
></A
></DT
><DT
>45.11. <A
HREF="catalog-pg-class.html"
><TT
CLASS="STRUCTNAME"
>pg_class</TT
></A
></DT
><DT
>45.12. <A
HREF="catalog-pg-constraint.html"
><TT
CLASS="STRUCTNAME"
>pg_constraint</TT
></A
></DT
><DT
>45.13. <A
HREF="catalog-pg-collation.html"
><TT
CLASS="STRUCTNAME"
>pg_collation</TT
></A
></DT
><DT
>45.14. <A
HREF="catalog-pg-conversion.html"
><TT
CLASS="STRUCTNAME"
>pg_conversion</TT
></A
></DT
><DT
>45.15. <A
HREF="catalog-pg-database.html"
><TT
CLASS="STRUCTNAME"
>pg_database</TT
></A
></DT
><DT
>45.16. <A
HREF="catalog-pg-db-role-setting.html"
><TT
CLASS="STRUCTNAME"
>pg_db_role_setting</TT
></A
></DT
><DT
>45.17. <A
HREF="catalog-pg-default-acl.html"
><TT
CLASS="STRUCTNAME"
>pg_default_acl</TT
></A
></DT
><DT
>45.18. <A
HREF="catalog-pg-depend.html"
><TT
CLASS="STRUCTNAME"
>pg_depend</TT
></A
></DT
><DT
>45.19. <A
HREF="catalog-pg-description.html"
><TT
CLASS="STRUCTNAME"
>pg_description</TT
></A
></DT
><DT
>45.20. <A
HREF="catalog-pg-enum.html"
><TT
CLASS="STRUCTNAME"
>pg_enum</TT
></A
></DT
><DT
>45.21. <A
HREF="catalog-pg-extension.html"
><TT
CLASS="STRUCTNAME"
>pg_extension</TT
></A
></DT
><DT
>45.22. <A
HREF="catalog-pg-foreign-data-wrapper.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_data_wrapper</TT
></A
></DT
><DT
>45.23. <A
HREF="catalog-pg-foreign-server.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_server</TT
></A
></DT
><DT
>45.24. <A
HREF="catalog-pg-foreign-table.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_table</TT
></A
></DT
><DT
>45.25. <A
HREF="catalog-pg-index.html"
><TT
CLASS="STRUCTNAME"
>pg_index</TT
></A
></DT
><DT
>45.26. <A
HREF="catalog-pg-inherits.html"
><TT
CLASS="STRUCTNAME"
>pg_inherits</TT
></A
></DT
><DT
>45.27. <A
HREF="catalog-pg-language.html"
><TT
CLASS="STRUCTNAME"
>pg_language</TT
></A
></DT
><DT
>45.28. <A
HREF="catalog-pg-largeobject.html"
><TT
CLASS="STRUCTNAME"
>pg_largeobject</TT
></A
></DT
><DT
>45.29. <A
HREF="catalog-pg-largeobject-metadata.html"
><TT
CLASS="STRUCTNAME"
>pg_largeobject_metadata</TT
></A
></DT
><DT
>45.30. <A
HREF="catalog-pg-namespace.html"
><TT
CLASS="STRUCTNAME"
>pg_namespace</TT
></A
></DT
><DT
>45.31. <A
HREF="catalog-pg-opclass.html"
><TT
CLASS="STRUCTNAME"
>pg_opclass</TT
></A
></DT
><DT
>45.32. <A
HREF="catalog-pg-operator.html"
><TT
CLASS="STRUCTNAME"
>pg_operator</TT
></A
></DT
><DT
>45.33. <A
HREF="catalog-pg-opfamily.html"
><TT
CLASS="STRUCTNAME"
>pg_opfamily</TT
></A
></DT
><DT
>45.34. <A
HREF="catalog-pg-pltemplate.html"
><TT
CLASS="STRUCTNAME"
>pg_pltemplate</TT
></A
></DT
><DT
>45.35. <A
HREF="catalog-pg-proc.html"
><TT
CLASS="STRUCTNAME"
>pg_proc</TT
></A
></DT
><DT
>45.36. <A
HREF="catalog-pg-range.html"
><TT
CLASS="STRUCTNAME"
>pg_range</TT
></A
></DT
><DT
>45.37. <A
HREF="catalog-pg-rewrite.html"
><TT
CLASS="STRUCTNAME"
>pg_rewrite</TT
></A
></DT
><DT
>45.38. <A
HREF="catalog-pg-seclabel.html"
><TT
CLASS="STRUCTNAME"
>pg_seclabel</TT
></A
></DT
><DT
>45.39. <A
HREF="catalog-pg-shdepend.html"
><TT
CLASS="STRUCTNAME"
>pg_shdepend</TT
></A
></DT
><DT
>45.40. <A
HREF="catalog-pg-shdescription.html"
><TT
CLASS="STRUCTNAME"
>pg_shdescription</TT
></A
></DT
><DT
>45.41. <A
HREF="catalog-pg-shseclabel.html"
><TT
CLASS="STRUCTNAME"
>pg_shseclabel</TT
></A
></DT
><DT
>45.42. <A
HREF="catalog-pg-statistic.html"
><TT
CLASS="STRUCTNAME"
>pg_statistic</TT
></A
></DT
><DT
>45.43. <A
HREF="catalog-pg-tablespace.html"
><TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
></A
></DT
><DT
>45.44. <A
HREF="catalog-pg-trigger.html"
><TT
CLASS="STRUCTNAME"
>pg_trigger</TT
></A
></DT
><DT
>45.45. <A
HREF="catalog-pg-ts-config.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_config</TT
></A
></DT
><DT
>45.46. <A
HREF="catalog-pg-ts-config-map.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_config_map</TT
></A
></DT
><DT
>45.47. <A
HREF="catalog-pg-ts-dict.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_dict</TT
></A
></DT
><DT
>45.48. <A
HREF="catalog-pg-ts-parser.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_parser</TT
></A
></DT
><DT
>45.49. <A
HREF="catalog-pg-ts-template.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_template</TT
></A
></DT
><DT
>45.50. <A
HREF="catalog-pg-type.html"
><TT
CLASS="STRUCTNAME"
>pg_type</TT
></A
></DT
><DT
>45.51. <A
HREF="catalog-pg-user-mapping.html"
><TT
CLASS="STRUCTNAME"
>pg_user_mapping</TT
></A
></DT
><DT
>45.52. <A
HREF="views-overview.html"
>System Views</A
></DT
><DT
>45.53. <A
HREF="view-pg-available-extensions.html"
><TT
CLASS="STRUCTNAME"
>pg_available_extensions</TT
></A
></DT
><DT
>45.54. <A
HREF="view-pg-available-extension-versions.html"
><TT
CLASS="STRUCTNAME"
>pg_available_extension_versions</TT
></A
></DT
><DT
>45.55. <A
HREF="view-pg-cursors.html"
><TT
CLASS="STRUCTNAME"
>pg_cursors</TT
></A
></DT
><DT
>45.56. <A
HREF="view-pg-group.html"
><TT
CLASS="STRUCTNAME"
>pg_group</TT
></A
></DT
><DT
>45.57. <A
HREF="view-pg-indexes.html"
><TT
CLASS="STRUCTNAME"
>pg_indexes</TT
></A
></DT
><DT
>45.58. <A
HREF="view-pg-locks.html"
><TT
CLASS="STRUCTNAME"
>pg_locks</TT
></A
></DT
><DT
>45.59. <A
HREF="view-pg-prepared-statements.html"
><TT
CLASS="STRUCTNAME"
>pg_prepared_statements</TT
></A
></DT
><DT
>45.60. <A
HREF="view-pg-prepared-xacts.html"
><TT
CLASS="STRUCTNAME"
>pg_prepared_xacts</TT
></A
></DT
><DT
>45.61. <A
HREF="view-pg-roles.html"
><TT
CLASS="STRUCTNAME"
>pg_roles</TT
></A
></DT
><DT
>45.62. <A
HREF="view-pg-rules.html"
><TT
CLASS="STRUCTNAME"
>pg_rules</TT
></A
></DT
><DT
>45.63. <A
HREF="view-pg-seclabels.html"
><TT
CLASS="STRUCTNAME"
>pg_seclabels</TT
></A
></DT
><DT
>45.64. <A
HREF="view-pg-settings.html"
><TT
CLASS="STRUCTNAME"
>pg_settings</TT
></A
></DT
><DT
>45.65. <A
HREF="view-pg-shadow.html"
><TT
CLASS="STRUCTNAME"
>pg_shadow</TT
></A
></DT
><DT
>45.66. <A
HREF="view-pg-stats.html"
><TT
CLASS="STRUCTNAME"
>pg_stats</TT
></A
></DT
><DT
>45.67. <A
HREF="view-pg-tables.html"
><TT
CLASS="STRUCTNAME"
>pg_tables</TT
></A
></DT
><DT
>45.68. <A
HREF="view-pg-timezone-abbrevs.html"
><TT
CLASS="STRUCTNAME"
>pg_timezone_abbrevs</TT
></A
></DT
><DT
>45.69. <A
HREF="view-pg-timezone-names.html"
><TT
CLASS="STRUCTNAME"
>pg_timezone_names</TT
></A
></DT
><DT
>45.70. <A
HREF="view-pg-user.html"
><TT
CLASS="STRUCTNAME"
>pg_user</TT
></A
></DT
><DT
>45.71. <A
HREF="view-pg-user-mappings.html"
><TT
CLASS="STRUCTNAME"
>pg_user_mappings</TT
></A
></DT
><DT
>45.72. <A
HREF="view-pg-views.html"
><TT
CLASS="STRUCTNAME"
>pg_views</TT
></A
></DT
></DL
></DIV
><P
>   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.
   <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>'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 always SQL commands to do that.  (For example, <TT
CLASS="COMMAND"
>CREATE
   DATABASE</TT
> inserts a row into the
   <TT
CLASS="STRUCTNAME"
>pg_database</TT
> catalog &mdash; and actually
   creates the database on disk.)  There are some exceptions for
   particularly esoteric operations, such as adding index access methods.
  </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="executor.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="catalogs-overview.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Executor</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="internals.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Overview</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>