|
1 |
| -<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.224 2010/03/25 14:44:33 alvherre Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.225 2010/04/03 07:22:52 petere Exp $ --> |
2 | 2 | <!--
|
3 | 3 | Documentation of the system catalogs, directed toward PostgreSQL developers
|
4 | 4 | -->
|
|
354 | 354 |
|
355 | 355 | <para>
|
356 | 356 | New aggregate functions are registered with the <xref
|
357 |
| - linkend="sql-createaggregate" endterm="sql-createaggregate-title"> |
| 357 | + linkend="sql-createaggregate"> |
358 | 358 | command. See <xref linkend="xaggr"> for more information about
|
359 | 359 | writing aggregate functions and the meaning of the transition
|
360 | 360 | functions, etc.
|
|
886 | 886 | <entry>
|
887 | 887 | <structfield>attstattarget</structfield> controls the level of detail
|
888 | 888 | of statistics accumulated for this column by
|
889 |
| - <xref linkend="sql-analyze" endterm="sql-analyze-title">. |
| 889 | + <xref linkend="sql-analyze">. |
890 | 890 | A zero value indicates that no statistics should be collected.
|
891 | 891 | A negative value says to use the system default statistics target.
|
892 | 892 | The exact meaning of positive values is data type-dependent.
|
|
1274 | 1274 | <para>
|
1275 | 1275 | The catalog <structname>pg_cast</structname> stores data type conversion
|
1276 | 1276 | paths, both built-in paths and those defined with
|
1277 |
| - <xref linkend="sql-createcast" endterm="sql-createcast-title">. |
| 1277 | + <xref linkend="sql-createcast">. |
1278 | 1278 | </para>
|
1279 | 1279 |
|
1280 | 1280 | <para>
|
|
1662 | 1662 | <entry></entry>
|
1663 | 1663 | <entry>
|
1664 | 1664 | Access privileges; see
|
1665 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
1666 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 1665 | + <xref linkend="sql-grant"> and |
| 1666 | + <xref linkend="sql-revoke"> |
1667 | 1667 | for details
|
1668 | 1668 | </entry>
|
1669 | 1669 | </row>
|
|
1962 | 1962 | <para>
|
1963 | 1963 | The catalog <structname>pg_conversion</structname> describes the
|
1964 | 1964 | available encoding conversion procedures. See
|
1965 |
| - <xref linkend="sql-createconversion" endterm="sql-createconversion-title"> |
| 1965 | + <xref linkend="sql-createconversion"> |
1966 | 1966 | for more information.
|
1967 | 1967 | </para>
|
1968 | 1968 |
|
|
2047 | 2047 | <para>
|
2048 | 2048 | The catalog <structname>pg_database</structname> stores information about
|
2049 | 2049 | the available databases. Databases are created with the <xref
|
2050 |
| - linkend="sql-createdatabase" endterm="sql-createdatabase-title"> command. |
| 2050 | + linkend="sql-createdatabase"> command. |
2051 | 2051 | Consult <xref linkend="managing-databases"> for details about the meaning
|
2052 | 2052 | of some of the parameters.
|
2053 | 2053 | </para>
|
|
2185 | 2185 | <entry></entry>
|
2186 | 2186 | <entry>
|
2187 | 2187 | Access privileges; see
|
2188 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
2189 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 2188 | + <xref linkend="sql-grant"> and |
| 2189 | + <xref linkend="sql-revoke"> |
2190 | 2190 | for details
|
2191 | 2191 | </entry>
|
2192 | 2192 | </row>
|
|
2467 | 2467 | <para>
|
2468 | 2468 | The catalog <structname>pg_description</> stores optional descriptions
|
2469 | 2469 | (comments) for each database object. Descriptions can be manipulated
|
2470 |
| - with the <xref linkend="sql-comment" endterm="sql-comment-title"> command and viewed with |
| 2470 | + with the <xref linkend="sql-comment"> command and viewed with |
2471 | 2471 | <application>psql</application>'s <literal>\d</literal> commands.
|
2472 | 2472 | Descriptions of many built-in system objects are provided in the initial
|
2473 | 2473 | contents of <structname>pg_description</structname>.
|
|
2643 | 2643 | <entry></entry>
|
2644 | 2644 | <entry>
|
2645 | 2645 | Access privileges; see
|
2646 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
2647 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 2646 | + <xref linkend="sql-grant"> and |
| 2647 | + <xref linkend="sql-revoke"> |
2648 | 2648 | for details
|
2649 | 2649 | </entry>
|
2650 | 2650 | </row>
|
|
2732 | 2732 | <entry></entry>
|
2733 | 2733 | <entry>
|
2734 | 2734 | Access privileges; see
|
2735 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
2736 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 2735 | + <xref linkend="sql-grant"> and |
| 2736 | + <xref linkend="sql-revoke"> |
2737 | 2737 | for details
|
2738 | 2738 | </entry>
|
2739 | 2739 | </row>
|
|
3000 | 3000 | <para>
|
3001 | 3001 | The catalog <structname>pg_language</structname> registers
|
3002 | 3002 | languages in which you can write functions or stored procedures.
|
3003 |
| - See <xref linkend="sql-createlanguage" endterm="sql-createlanguage-title"> |
| 3003 | + See <xref linkend="sql-createlanguage"> |
3004 | 3004 | and <xref linkend="xplang"> for more information about language handlers.
|
3005 | 3005 | </para>
|
3006 | 3006 |
|
|
3076 | 3076 | <entry>
|
3077 | 3077 | This references a function that is responsible for executing
|
3078 | 3078 | <quote>inline</> anonymous code blocks
|
3079 |
| - (<xref linkend="sql-do" endterm="sql-do-title"> blocks). |
| 3079 | + (<xref linkend="sql-do"> blocks). |
3080 | 3080 | Zero if inline blocks are not supported
|
3081 | 3081 | </entry>
|
3082 | 3082 | </row>
|
|
3098 | 3098 | <entry></entry>
|
3099 | 3099 | <entry>
|
3100 | 3100 | Access privileges; see
|
3101 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
3102 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 3101 | + <xref linkend="sql-grant"> and |
| 3102 | + <xref linkend="sql-revoke"> |
3103 | 3103 | for details
|
3104 | 3104 | </entry>
|
3105 | 3105 | </row>
|
|
3231 | 3231 | <entry></entry>
|
3232 | 3232 | <entry>
|
3233 | 3233 | Access privileges; see
|
3234 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
3235 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 3234 | + <xref linkend="sql-grant"> and |
| 3235 | + <xref linkend="sql-revoke"> |
3236 | 3236 | for details
|
3237 | 3237 | </entry>
|
3238 | 3238 | </row>
|
|
3290 | 3290 | <entry></entry>
|
3291 | 3291 | <entry>
|
3292 | 3292 | Access privileges; see
|
3293 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
3294 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 3293 | + <xref linkend="sql-grant"> and |
| 3294 | + <xref linkend="sql-revoke"> |
3295 | 3295 | for details
|
3296 | 3296 | </entry>
|
3297 | 3297 | </row>
|
|
3418 | 3418 |
|
3419 | 3419 | <para>
|
3420 | 3420 | The catalog <structname>pg_operator</> stores information about operators.
|
3421 |
| - See <xref linkend="sql-createoperator" endterm="sql-createoperator-title"> |
| 3421 | + See <xref linkend="sql-createoperator"> |
3422 | 3422 | and <xref linkend="xoper"> for more information.
|
3423 | 3423 | </para>
|
3424 | 3424 |
|
|
3745 | 3745 |
|
3746 | 3746 | <para>
|
3747 | 3747 | The catalog <structname>pg_proc</> stores information about functions (or procedures).
|
3748 |
| - See <xref linkend="sql-createfunction" endterm="sql-createfunction-title"> |
| 3748 | + See <xref linkend="sql-createfunction"> |
3749 | 3749 | and <xref linkend="xfunc"> for more information.
|
3750 | 3750 | </para>
|
3751 | 3751 |
|
|
4011 | 4011 | <entry></entry>
|
4012 | 4012 | <entry>
|
4013 | 4013 | Access privileges; see
|
4014 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
4015 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 4014 | + <xref linkend="sql-grant"> and |
| 4015 | + <xref linkend="sql-revoke"> |
4016 | 4016 | for details
|
4017 | 4017 | </entry>
|
4018 | 4018 | </row>
|
|
4368 | 4368 | <para>
|
4369 | 4369 | The catalog <structname>pg_shdescription</structname> stores optional
|
4370 | 4370 | descriptions (comments) for shared database objects. Descriptions can be
|
4371 |
| - manipulated with the <xref linkend="sql-comment" |
4372 |
| - endterm="sql-comment-title"> command and viewed with |
| 4371 | + manipulated with the <xref linkend="sql-comment"> command and viewed with |
4373 | 4372 | <application>psql</application>'s <literal>\d</literal> commands.
|
4374 | 4373 | </para>
|
4375 | 4374 |
|
|
4437 | 4436 | <para>
|
4438 | 4437 | The catalog <structname>pg_statistic</structname> stores
|
4439 | 4438 | statistical data about the contents of the database. Entries are
|
4440 |
| - created by <xref linkend="sql-analyze" endterm="sql-analyze-title"> |
| 4439 | + created by <xref linkend="sql-analyze"> |
4441 | 4440 | and subsequently used by the query planner. Note that all the
|
4442 | 4441 | statistical data is inherently approximate, even assuming that it
|
4443 | 4442 | is up-to-date.
|
|
4668 | 4667 | <entry></entry>
|
4669 | 4668 | <entry>
|
4670 | 4669 | Access privileges; see
|
4671 |
| - <xref linkend="sql-grant" endterm="sql-grant-title"> and |
4672 |
| - <xref linkend="sql-revoke" endterm="sql-revoke-title"> |
| 4670 | + <xref linkend="sql-grant"> and |
| 4671 | + <xref linkend="sql-revoke"> |
4673 | 4672 | for details
|
4674 | 4673 | </entry>
|
4675 | 4674 | </row>
|
|
4697 | 4696 |
|
4698 | 4697 | <para>
|
4699 | 4698 | The catalog <structname>pg_trigger</structname> stores triggers on tables.
|
4700 |
| - See <xref linkend="sql-createtrigger" endterm="sql-createtrigger-title"> |
| 4699 | + See <xref linkend="sql-createtrigger"> |
4701 | 4700 | for more information.
|
4702 | 4701 | </para>
|
4703 | 4702 |
|
|
5250 | 5249 | <para>
|
5251 | 5250 | The catalog <structname>pg_type</structname> stores information about data
|
5252 | 5251 | types. Base types and enum types (scalar types) are created with
|
5253 |
| - <xref linkend="sql-createtype" endterm="sql-createtype-title">, and |
| 5252 | + <xref linkend="sql-createtype">, and |
5254 | 5253 | domains with
|
5255 |
| - <xref linkend="sql-createdomain" endterm="sql-createdomain-title">. |
| 5254 | + <xref linkend="sql-createdomain">. |
5256 | 5255 | A composite type is automatically created for each table in the database, to
|
5257 | 5256 | represent the row structure of the table. It is also possible to create
|
5258 | 5257 | composite types with <command>CREATE TYPE AS</command>.
|
|
5917 | 5916 | <itemizedlist>
|
5918 | 5917 | <listitem>
|
5919 | 5918 | <para>
|
5920 |
| - via the <xref linkend="sql-declare" endterm="sql-declare-title"> |
| 5919 | + via the <xref linkend="sql-declare"> |
5921 | 5920 | statement in SQL
|
5922 | 5921 | </para>
|
5923 | 5922 | </listitem>
|
|
6414 | 6413 | <para>
|
6415 | 6414 | The <structname>pg_prepared_statements</structname> view displays
|
6416 | 6415 | all the prepared statements that are available in the current
|
6417 |
| - session. See <xref linkend="sql-prepare" |
6418 |
| - endterm="sql-prepare-title"> for more information about prepared |
| 6416 | + session. See <xref linkend="sql-prepare"> for more information about prepared |
6419 | 6417 | statements.
|
6420 | 6418 | </para>
|
6421 | 6419 |
|
6422 | 6420 | <para>
|
6423 | 6421 | <structname>pg_prepared_statements</structname> contains one row
|
6424 | 6422 | for each prepared statement. Rows are added to the view when a new
|
6425 | 6423 | prepared statement is created and removed when a prepared statement
|
6426 |
| - is released (for example, via the <xref linkend="sql-deallocate" |
6427 |
| - endterm="sql-deallocate-title"> command). |
| 6424 | + is released (for example, via the <xref linkend="sql-deallocate"> command). |
6428 | 6425 | </para>
|
6429 | 6426 |
|
6430 | 6427 | <table>
|
|
6504 | 6501 | <para>
|
6505 | 6502 | The view <structname>pg_prepared_xacts</structname> displays
|
6506 | 6503 | information about transactions that are currently prepared for two-phase
|
6507 |
| - commit (see <xref linkend="sql-prepare-transaction" |
6508 |
| - endterm="sql-prepare-transaction-title"> for details). |
| 6504 | + commit (see <xref linkend="sql-prepare-transaction"> for details). |
6509 | 6505 | </para>
|
6510 | 6506 |
|
6511 | 6507 | <para>
|
|
6780 | 6776 | <para>
|
6781 | 6777 | The view <structname>pg_settings</structname> provides access to
|
6782 | 6778 | run-time parameters of the server. It is essentially an alternative
|
6783 |
| - interface to the <xref linkend="sql-show" endterm="sql-show-title"> |
6784 |
| - and <xref linkend="sql-set" endterm="sql-set-title"> commands. |
| 6779 | + interface to the <xref linkend="sql-show"> |
| 6780 | + and <xref linkend="sql-set"> commands. |
6785 | 6781 | It also provides access to some facts about each parameter that are
|
6786 | 6782 | not directly available from <command>SHOW</>, such as minimum and
|
6787 | 6783 | maximum values.
|
|
6900 | 6896 | The <structname>pg_settings</structname> view cannot be inserted into or
|
6901 | 6897 | deleted from, but it can be updated. An <command>UPDATE</command> applied
|
6902 | 6898 | to a row of <structname>pg_settings</structname> is equivalent to executing
|
6903 |
| - the <xref linkend="sql-set" endterm="sql-set-title"> command on that named |
| 6899 | + the <xref linkend="sql-set"> command on that named |
6904 | 6900 | parameter. The change only affects the value used by the current
|
6905 | 6901 | session. If an <command>UPDATE</command> is issued within a transaction
|
6906 | 6902 | that is later aborted, the effects of the <command>UPDATE</command> command
|
|
0 commit comments