CREATE ACCESS METHOD

A DDL command for defining an access method

CREATE ACCESS METHOD is a DDL command for defining an access method.

CREATE ACCESS METHOD was added in PostgreSQL 9.6.

Available access methods

As of PostgreSQL 12, both table and index access methods are supported.

In PostgreSQL 11 and earlier, only the index access method was available.

Notes

There is no ALTER ACCESS METHOD command.

Tthe "heptree" index access method noted in the documentation is fictitious.

Change history

CREATE ACCESS METHOD has not been modified since it was added in PostgreSQL 9.6.

Categories

DDL, SQL command

See also

DROP ACCESS METHOD