create_access_method(7)

NAME#

CREATE_ACCESS_METHOD - define a new access method

SYNOPSIS#

CREATE ACCESS METHOD \nname\n
\n
    TYPE \naccess_method_type\n
\n
    HANDLER \nhandler_function

DESCRIPTION#

CREATE ACCESS METHOD creates a new access method.

The access method name must be unique within the database.

Only superusers can define new access methods.

PARAMETERS#

name

access_method_type

handler_function

EXAMPLES#

Create an index access method heptree with handler function heptree_handler:

CREATE ACCESS METHOD heptree TYPE INDEX HANDLER heptree_handler;

COMPATIBILITY#

CREATE ACCESS METHOD is a PostgreSQL extension.

SEE ALSO#

DROP ACCESS METHOD (DROP_ACCESS_METHOD(7)), CREATE OPERATOR CLASS (CREATE_OPERATOR_CLASS(7)), CREATE OPERATOR FAMILY (CREATE_OPERATOR_FAMILY(7))