|
1 | 1 | <!--
|
2 | 2 | Documentation of the system catalogs, directed toward PostgreSQL developers
|
3 |
| - $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.35 2002/03/20 19:43:24 tgl Exp $ |
| 3 | + $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.36 2002/03/22 19:20:03 petere Exp $ |
4 | 4 | -->
|
5 | 5 |
|
6 | 6 | <chapter id="catalogs">
|
|
222 | 222 | <entry>aggbasetype</entry>
|
223 | 223 | <entry><type>oid</type></entry>
|
224 | 224 | <entry>pg_type.oid</entry>
|
225 |
| - <entry>The input datatype for this aggregate function</entry> |
| 225 | + <entry>The input data type for this aggregate function</entry> |
226 | 226 | </row>
|
227 | 227 | <row>
|
228 | 228 | <entry>aggtranstype</entry>
|
|
386 | 386 | of statistics accumulated for this column by
|
387 | 387 | <command>ANALYZE</command>.
|
388 | 388 | A zero value indicates that no statistics should be collected.
|
389 |
| - The exact meaning of positive values is datatype-dependent. |
390 |
| - For scalar datatypes, <structfield>attstattarget</structfield> |
| 389 | + The exact meaning of positive values is data type-dependent. |
| 390 | + For scalar data types, <structfield>attstattarget</structfield> |
391 | 391 | is both the target number of <quote>most common values</quote>
|
392 | 392 | to collect, and the target number of histogram bins to create.
|
393 | 393 | </entry>
|
|
533 | 533 | <title>pg_class</title>
|
534 | 534 |
|
535 | 535 | <para>
|
536 |
| - <structname>pg_class</structname> catalogues tables and mostly |
| 536 | + <structname>pg_class</structname> catalogs tables and mostly |
537 | 537 | everything else that has columns or is otherwise similar to a
|
538 | 538 | table. This includes indexes (but see also
|
539 | 539 | <structname>pg_index</structname>), sequences, views, and some
|
|
584 | 584 | <entry>relam</entry>
|
585 | 585 | <entry><type>oid</type></entry>
|
586 | 586 | <entry>pg_am.oid</entry>
|
587 |
| - <entry>If this is an index, the access method used (btree, hash, etc.)</entry> |
| 587 | + <entry>If this is an index, the access method used (B-tree, hash, etc.)</entry> |
588 | 588 | </row>
|
589 | 589 |
|
590 | 590 | <row>
|
|
624 | 624 | <entry><type>oid</type></entry>
|
625 | 625 | <entry>pg_class.oid</entry>
|
626 | 626 | <entry>
|
627 |
| - Oid of the TOAST table associated with this table, 0 if none. |
| 627 | + OID of the TOAST table associated with this table, 0 if none. |
628 | 628 | The TOAST table stores large attributes <quote>out of
|
629 | 629 | line</quote> in a secondary table.
|
630 | 630 | </entry>
|
|
909 | 909 | The pg_description table can store an optional description or
|
910 | 910 | comment for each database object. Descriptions can be manipulated
|
911 | 911 | with the <command>COMMENT</command> command. Client applications
|
912 |
| - can view the descriptions by joining with this table. Many builtin |
| 912 | + can view the descriptions by joining with this table. Many built-in |
913 | 913 | system objects have comments associated with them that are shown by
|
914 | 914 | <application>psql</application>'s <literal>\d</literal> commands.
|
915 | 915 | </para>
|
|
1648 | 1648 | <entry><type>bool</type></entry>
|
1649 | 1649 | <entry></entry>
|
1650 | 1650 | <entry>Function returns a set (ie, multiple values of the specified
|
1651 |
| - datatype)</entry> |
| 1651 | + data type)</entry> |
1652 | 1652 | </row>
|
1653 | 1653 |
|
1654 | 1654 | <row>
|
|
2128 | 2128 | <entry></entry>
|
2129 | 2129 | <entry>Column data values of the appropriate kind for the Nth
|
2130 | 2130 | <quote>slot</quote>, or NULL if the slot kind does not store any data values.
|
2131 |
| - For datatype independence, all column data values are converted |
| 2131 | + For data-type independence, all column data values are converted |
2132 | 2132 | to external textual form and stored as TEXT datums.
|
2133 | 2133 | </entry>
|
2134 | 2134 | </row>
|
|
2271 | 2271 | <title>pg_type</title>
|
2272 | 2272 |
|
2273 | 2273 | <para>
|
2274 |
| - This catalog stores information about datatypes. Scalar types |
| 2274 | + This catalog stores information about data types. Scalar types |
2275 | 2275 | (<quote>base types</>) are created with <command>CREATE TYPE</command>.
|
2276 | 2276 | A complex type is also created for each table in the database, to
|
2277 | 2277 | represent the row structure of the table. It is also possible to create
|
|
2369 | 2369 | <entry></entry>
|
2370 | 2370 | <entry>Character that separates two values of this type when parsing
|
2371 | 2371 | array input. Note that the delimiter is associated with the array
|
2372 |
| - element datatype, not the array datatype.</entry> |
| 2372 | + element data type, not the array data type.</entry> |
2373 | 2373 | </row>
|
2374 | 2374 |
|
2375 | 2375 | <row>
|
|
2402 | 2402 | <type>name</type> and <type>oidvector</type>.
|
2403 | 2403 | If a fixed-length type has a <structfield>typelem</structfield> then
|
2404 | 2404 | its internal representation must be N values of the
|
2405 |
| - <structfield>typelem</structfield> datatype with no other data. |
| 2405 | + <structfield>typelem</structfield> data type with no other data. |
2406 | 2406 | Variable-length array types have a header defined by the array
|
2407 | 2407 | subroutines.
|
2408 | 2408 | </entry>
|
|
0 commit comments