| PostgreSQL 8.3.3 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 44. System Catalogs | Fast Forward | Next |
The catalog pg_am stores information about index access methods. There is one row for each index access method supported by the system. The contents of this catalog are discussed in detail in Chapter 50.
Table 44-3. pg_am Columns
| Name | Type | References | Description |
|---|---|---|---|
| amname | name | Name of the access method | |
| amstrategies | int2 | Number of operator strategies for this access method, or zero if access method does not have a fixed set of operator strategies | |
| amsupport | int2 | Number of support routines for this access method | |
| amcanorder | bool | Does the access method support ordered scans? | |
| amcanunique | bool | Does the access method support unique indexes? | |
| amcanmulticol | bool | Does the access method support multicolumn indexes? | |
| amoptionalkey | bool | Does the access method support a scan without any constraint for the first index column? | |
| amindexnulls | bool | Does the access method support null index entries? | |
| amsearchnulls | bool | Does the access method support IS NULL searches? | |
| amstorage | bool | Can index storage data type differ from column data type? | |
| amclusterable | bool | Can an index of this type be clustered on? | |
| aminsert | regproc | pg_proc.oid | "Insert this tuple" function |
| ambeginscan | regproc | pg_proc.oid | "Start new scan" function |
| amgettuple | regproc | pg_proc.oid | "Next valid tuple" function |
| amgetmulti | regproc | pg_proc.oid | "Fetch multiple tuples" function |
| amrescan | regproc | pg_proc.oid | "Restart this scan" function |
| amendscan | regproc | pg_proc.oid | "End this scan" function |
| ammarkpos | regproc | pg_proc.oid | "Mark current scan position" function |
| amrestrpos | regproc | pg_proc.oid | "Restore marked scan position" function |
| ambuild | regproc | pg_proc.oid | "Build new index" function |
| ambulkdelete | regproc | pg_proc.oid | Bulk-delete function |
| amvacuumcleanup | regproc | pg_proc.oid | Post-VACUUM cleanup function |
| amcostestimate | regproc | pg_proc.oid | Function to estimate cost of an index scan |
| amoptions | regproc | pg_proc.oid | Function to parse and validate reloptions for an index |
No comments could be found for this page.
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
In order to submit a comment, you must have a community account.
* denotes required field