Doc Index

- [Reference Guide](./ref_guide.md)
    - [SQL Commands](./sql_commands/sql_ref.md)
        - [ABORT](./sql_commands/ABORT.md)
        - [ALTER AGGREGATE](./sql_commands/ALTER_AGGREGATE.md)
        - [ALTER COLLATION](./sql_commands/ALTER_COLLATION.md)
        - [ALTER CONVERSION](./sql_commands/ALTER_CONVERSION.md)
        - [ALTER DATABASE](./sql_commands/ALTER_DATABASE.md)
        - [ALTER DEFAULT PRIVILEGES](./sql_commands/ALTER_DEFAULT_PRIVILEGES.md)
        - [ALTER DOMAIN](./sql_commands/ALTER_DOMAIN.md)
        - [ALTER EXTENSION](./sql_commands/ALTER_EXTENSION.md)
        - [ALTER EXTERNAL TABLE](./sql_commands/ALTER_EXTERNAL_TABLE.md)
        - [ALTER FOREIGN DATA WRAPPER](./sql_commands/ALTER_FOREIGN_DATA_WRAPPER.md)
        - [ALTER FOREIGN TABLE](./sql_commands/ALTER_FOREIGN_TABLE.md)
        - [ALTER FUNCTION](./sql_commands/ALTER_FUNCTION.md)
        - [ALTER GROUP](./sql_commands/ALTER_GROUP.md)
        - [ALTER INDEX](./sql_commands/ALTER_INDEX.md)
        - [ALTER LANGUAGE](./sql_commands/ALTER_LANGUAGE.md)
        - [ALTER MATERIALIZED VIEW](./sql_commands/ALTER_MATERIALIZED_VIEW.md)
        - [ALTER OPERATOR](./sql_commands/ALTER_OPERATOR.md)
        - [ALTER OPERATOR CLASS](./sql_commands/ALTER_OPERATOR_CLASS.md)
        - [ALTER OPERATOR FAMILY](./sql_commands/ALTER_OPERATOR_FAMILY.md)
        - [ALTER POLICY](./sql_commands/ALTER_POLICY.md)
        - [ALTER PROCEDURE](./sql_commands/ALTER_PROCEDURE.md)
        - [ALTER PROTOCOL](./sql_commands/ALTER_PROTOCOL.md)
        - [ALTER RESOURCE GROUP](./sql_commands/ALTER_RESOURCE_GROUP.md)
        - [ALTER RESOURCE QUEUE](./sql_commands/ALTER_RESOURCE_QUEUE.md)
        - [ALTER ROLE](./sql_commands/ALTER_ROLE.md)
        - [ALTER ROUTINE](./sql_commands/ALTER_ROUTINE.md)
        - [ALTER SCHEMA](./sql_commands/ALTER_SCHEMA.md)
        - [ALTER SEQUENCE](./sql_commands/ALTER_SEQUENCE.md)
        - [ALTER SERVER](./sql_commands/ALTER_SERVER.md)
        - [ALTER STATISTICS](./sql_commands/ALTER_STATISTICS.md)
        - [ALTER TABLE](./sql_commands/ALTER_TABLE.md)
        - [ALTER TABLESPACE](./sql_commands/ALTER_TABLESPACE.md)
        - [ALTER TEXT SEARCH CONFIGURATION](./sql_commands/ALTER_TEXT_SEARCH_CONFIGURATION.md)
        - [ALTER TEXT SEARCH DICTIONARY](./sql_commands/ALTER_TEXT_SEARCH_DICTIONARY.md)
        - [ALTER TEXT SEARCH PARSER](./sql_commands/ALTER_TEXT_SEARCH_PARSER.md)
        - [ALTER TEXT SEARCH TEMPLATE](./sql_commands/ALTER_TEXT_SEARCH_TEMPLATE.md)
        - [ALTER TYPE](./sql_commands/ALTER_TYPE.md)
        - [ALTER USER](./sql_commands/ALTER_USER.md)
        - [ALTER USER MAPPING](./sql_commands/ALTER_USER_MAPPING.md)
        - [ALTER VIEW](./sql_commands/ALTER_VIEW.md)
        - [ANALYZE](./sql_commands/ANALYZE.md)
        - [BEGIN](./sql_commands/BEGIN.md)
        - [CALL](./sql_commands/CALL.md)
        - [CHECKPOINT](./sql_commands/CHECKPOINT.md)
        - [CLOSE](./sql_commands/CLOSE.md)
        - [CLUSTER](./sql_commands/CLUSTER.md)
        - [COMMENT](./sql_commands/COMMENT.md)
        - [COMMIT](./sql_commands/COMMIT.md)
        - [COPY](./sql_commands/COPY.md)
        - [CREATE ACCESS METHOD](./sql_commands/CREATE_ACCESS_METHOD.md)
        - [CREATE AGGREGATE](./sql_commands/CREATE_AGGREGATE.md)
        - [CREATE CAST](./sql_commands/CREATE_CAST.md)
        - [CREATE COLLATION](./sql_commands/CREATE_COLLATION.md)
        - [CREATE CONVERSION](./sql_commands/CREATE_CONVERSION.md)
        - [CREATE DATABASE](./sql_commands/CREATE_DATABASE.md)
        - [CREATE DOMAIN](./sql_commands/CREATE_DOMAIN.md)
        - [CREATE EXTENSION](./sql_commands/CREATE_EXTENSION.md)
        - [CREATE EXTERNAL TABLE](./sql_commands/CREATE_EXTERNAL_TABLE.md)
        - [CREATE FOREIGN DATA WRAPPER](./sql_commands/CREATE_FOREIGN_DATA_WRAPPER.md)
        - [CREATE FOREIGN TABLE](./sql_commands/CREATE_FOREIGN_TABLE.md)
        - [CREATE FUNCTION](./sql_commands/CREATE_FUNCTION.md)
        - [CREATE GROUP](./sql_commands/CREATE_GROUP.md)
        - [CREATE INDEX](./sql_commands/CREATE_INDEX.md)
        - [CREATE LANGUAGE](./sql_commands/CREATE_LANGUAGE.md)
        - [CREATE MATERIALIZED VIEW](./sql_commands/CREATE_MATERIALIZED_VIEW.md)
        - [CREATE OPERATOR](./sql_commands/CREATE_OPERATOR.md)
        - [CREATE OPERATOR CLASS](./sql_commands/CREATE_OPERATOR_CLASS.md)
        - [CREATE OPERATOR FAMILY](./sql_commands/CREATE_OPERATOR_FAMILY.md)
        - [CREATE POLICY](./sql_commands/CREATE_POLICY.md)
        - [CREATE PROCEDURE](./sql_commands/CREATE_PROCEDURE.md)
        - [CREATE PROTOCOL](./sql_commands/CREATE_PROTOCOL.md)
        - [CREATE RESOURCE GROUP](./sql_commands/CREATE_RESOURCE_GROUP.md)
        - [CREATE RESOURCE QUEUE](./sql_commands/CREATE_RESOURCE_QUEUE.md)
        - [CREATE ROLE](./sql_commands/CREATE_ROLE.md)
        - [CREATE RULE](./sql_commands/CREATE_RULE.md)
        - [CREATE SCHEMA](./sql_commands/CREATE_SCHEMA.md)
        - [CREATE SEQUENCE](./sql_commands/CREATE_SEQUENCE.md)
        - [CREATE SERVER](./sql_commands/CREATE_SERVER.md)
        - [CREATE STATISTICS](./sql_commands/CREATE_STATISTICS.md)
        - [CREATE TABLE](./sql_commands/CREATE_TABLE.md)
        - [CREATE TABLE AS](./sql_commands/CREATE_TABLE_AS.md)
        - [CREATE TABLESPACE](./sql_commands/CREATE_TABLESPACE.md)
        - [CREATE TEXT SEARCH CONFIGURATION](./sql_commands/CREATE_TEXT_SEARCH_CONFIGURATION.md)
        - [CREATE TEXT SEARCH DICTIONARY](./sql_commands/CREATE_TEXT_SEARCH_DICTIONARY.md)
        - [CREATE TEXT SEARCH PARSER](./sql_commands/CREATE_TEXT_SEARCH_PARSER.md)
        - [CREATE TEXT SEARCH TEMPLATE](./sql_commands/CREATE_TEXT_SEARCH_TEMPLATE.md)
        - [CREATE TRANSFORM](./sql_commands/CREATE_TRANSFORM.md)
        - [CREATE TYPE](./sql_commands/CREATE_TYPE.md)
        - [CREATE USER](./sql_commands/CREATE_USER.md)
        - [CREATE USER MAPPING](./sql_commands/CREATE_USER_MAPPING.md)
        - [CREATE VIEW](./sql_commands/CREATE_VIEW.md)
        - [DEALLOCATE](./sql_commands/DEALLOCATE.md)
        - [DECLARE](./sql_commands/DECLARE.md)
        - [DELETE](./sql_commands/DELETE.md)
        - [DISCARD](./sql_commands/DISCARD.md)
        - [DO](./sql_commands/DO.md)
        - [DROP ACCESS METHOD](./sql_commands/DROP_ACCESS_METHOD.md)
        - [DROP AGGREGATE](./sql_commands/DROP_AGGREGATE.md)
        - [DROP CAST](./sql_commands/DROP_CAST.md)
        - [DROP COLLATION](./sql_commands/DROP_COLLATION.md)
        - [DROP CONVERSION](./sql_commands/DROP_CONVERSION.md)
        - [DROP DATABASE](./sql_commands/DROP_DATABASE.md)
        - [DROP DOMAIN](./sql_commands/DROP_DOMAIN.md)
        - [DROP EXTENSION](./sql_commands/DROP_EXTENSION.md)
        - [DROP EXTERNAL TABLE](./sql_commands/DROP_EXTERNAL_TABLE.md)
        - [DROP FOREIGN DATA WRAPPER](./sql_commands/DROP_FOREIGN_DATA_WRAPPER.md)
        - [DROP FOREIGN TABLE](./sql_commands/DROP_FOREIGN_TABLE.md)
        - [DROP FUNCTION](./sql_commands/DROP_FUNCTION.md)
        - [DROP GROUP](./sql_commands/DROP_GROUP.md)
        - [DROP INDEX](./sql_commands/DROP_INDEX.md)
        - [DROP LANGUAGE](./sql_commands/DROP_LANGUAGE.md)
        - [DROP MATERIALIZED VIEW](./sql_commands/DROP_MATERIALIZED_VIEW.md)
        - [DROP OPERATOR](./sql_commands/DROP_OPERATOR.md)
        - [DROP OPERATOR CLASS](./sql_commands/DROP_OPERATOR_CLASS.md)
        - [DROP OPERATOR FAMILY](./sql_commands/DROP_OPERATOR_FAMILY.md)
        - [DROP OWNED](./sql_commands/DROP_OWNED.md)
        - [DROP POLICY](./sql_commands/DROP_POLICY.md)
        - [DROP PROCEDURE](./sql_commands/DROP_PROCEDURE.md)
        - [DROP PROTOCOL](./sql_commands/DROP_PROTOCOL.md)
        - [DROP RESOURCE GROUP](./sql_commands/DROP_RESOURCE_GROUP.md)
        - [DROP RESOURCE QUEUE](./sql_commands/DROP_RESOURCE_QUEUE.md)
        - [DROP ROLE](./sql_commands/DROP_ROLE.md)
        - [DROP ROUTINE](./sql_commands/DROP_ROUTINE.md)
        - [DROP RULE](./sql_commands/DROP_RULE.md)
        - [DROP SCHEMA](./sql_commands/DROP_SCHEMA.md)
        - [DROP SEQUENCE](./sql_commands/DROP_SEQUENCE.md)
        - [DROP SERVER](./sql_commands/DROP_SERVER.md)
        - [DROP STATISTICS](./sql_commands/DROP_STATISTICS.md)
        - [DROP TABLE](./sql_commands/DROP_TABLE.md)
        - [DROP TABLESPACE](./sql_commands/DROP_TABLESPACE.md)
        - [DROP TEXT SEARCH CONFIGURATION](./sql_commands/DROP_TEXT_SEARCH_CONFIGURATION.md)
        - [DROP TEXT SEARCH DICTIONARY](./sql_commands/DROP_TEXT_SEARCH_DICTIONARY.md)
        - [DROP TEXT SEARCH PARSER](./sql_commands/DROP_TEXT_SEARCH_PARSER.md)
        - [DROP TEXT SEARCH TEMPLATE](./sql_commands/DROP_TEXT_SEARCH_TEMPLATE.md)
        - [DROP TRANSFORM](./sql_commands/DROP_TRANSFORM.md)
        - [DROP TYPE](./sql_commands/DROP_TYPE.md)
        - [DROP USER](./sql_commands/DROP_USER.md)
        - [DROP USER MAPPING](./sql_commands/DROP_USER_MAPPING.md)
        - [DROP VIEW](./sql_commands/DROP_VIEW.md)
        - [END](./sql_commands/END.md)
        - [EXECUTE](./sql_commands/EXECUTE.md)
        - [EXPLAIN](./sql_commands/EXPLAIN.md)
        - [FETCH](./sql_commands/FETCH.md)
        - [GRANT](./sql_commands/GRANT.md)
        - [IMPORT FOREIGN SCHEMA](./sql_commands/IMPORT_FOREIGN_SCHEMA.md)
        - [INSERT](./sql_commands/INSERT.md)
        - [LISTEN](./sql_commands/LISTEN.md)
        - [LOAD](./sql_commands/LOAD.md)
        - [LOCK](./sql_commands/LOCK.md)
        - [MOVE](./sql_commands/MOVE.md)
        - [NOTIFY](./sql_commands/NOTIFY.md)
        - [PREPARE](./sql_commands/PREPARE.md)
        - [REASSIGN OWNED](./sql_commands/REASSIGN_OWNED.md)
        - [REFRESH MATERIALIZED VIEW](./sql_commands/REFRESH_MATERIALIZED_VIEW.md)
        - [REINDEX](./sql_commands/REINDEX.md)
        - [RELEASE SAVEPOINT](./sql_commands/RELEASE_SAVEPOINT.md)
        - [RESET](./sql_commands/RESET.md)
        - [RETRIEVE](./sql_commands/RETRIEVE.md)
        - [REVOKE](./sql_commands/REVOKE.md)
        - [ROLLBACK](./sql_commands/ROLLBACK.md)
        - [ROLLBACK TO SAVEPOINT](./sql_commands/ROLLBACK_TO_SAVEPOINT.md)
        - [SAVEPOINT](./sql_commands/SAVEPOINT.md)
        - [SELECT](./sql_commands/SELECT.md)
        - [SELECT INTO](./sql_commands/SELECT_INTO.md)
        - [SET](./sql_commands/SET.md)
        - [SET CONSTRAINTS](./sql_commands/SET_CONSTRAINTS.md)
        - [SET ROLE](./sql_commands/SET_ROLE.md)
        - [SET SESSION AUTHORIZATION](./sql_commands/SET_SESSION_AUTHORIZATION.md)
        - [SET TRANSACTION](./sql_commands/SET_TRANSACTION.md)
        - [SHOW](./sql_commands/SHOW.md)
        - [START TRANSACTION](./sql_commands/START_TRANSACTION.md)
        - [TRUNCATE](./sql_commands/TRUNCATE.md)
        - [UNLISTEN](./sql_commands/UNLISTEN.md)
        - [UPDATE](./sql_commands/UPDATE.md)
        - [VACUUM](./sql_commands/VACUUM.md)
        - [VALUES](./sql_commands/VALUES.md)
    - [Data Types](./data_types.md)
        - [Date/Time Types](./datatype-datetime.md)
        - [Pseudo-Types](./datatype-pseudo.md)
        - [Text Search Data Types](./datatype-textsearch.md)
        - [Range Types](./datatype-range.md)
    - [Summary of Built-in Functions](./function-summary.md)
    - [Additional Supplied Modules](./modules/intro.md)
        - [advanced\_password\_check](./modules/adv_passwd_check.md)
        - [auto\_explain](./modules/auto-explain.md)
        - [btree\_gin](./modules/btree_gin.md)
        - [citext](./modules/citext.md)
        - [dblink](./modules/dblink.md)
        - [diskquota](./modules/diskquota.md)
        - [fuzzystrmatch](./modules/fuzzystrmatch.md)
        - [gp\_exttable\_fdw](./modules/gp_exttable_fdw.md)
        - [gp\_legacy\_string\_agg](./modules/gp_legacy_string_agg.md)
        - [gp\_sparse\_vector](./modules/gp_sparse_vector.md)
        - [greenplum_fdw](./modules/greenplum_fdw.md)
        - [hstore](./modules/hstore.md)
        - [ip4r](./modules/ip4r.md)
        - [ltree](./modules/ltree.md)
        - [orafce](./modules/orafce_ref.md)
        - [pageinspect](./modules/pageinspect.md)
        - [pg\_trgm](./modules/pg_trgm.md)
        - [pgcrypto](./modules/pgcrypto.md)
        - [pgvector](./modules/pgvector/pgvector.md)
        - [postgres\_fdw](./modules/postgres_fdw.md)
        - [postgresql-hll](./modules/postgresql-hll.md)
        - [sslinfo](./modules/sslinfo.md)
        - [tablefunc](./modules/tablefunc.md)
        - [timestamp9](./modules/timestamp9.md)
        - [uuid-ossp](./modules/uuid-ossp.md)
    - [Character Set Support](./character_sets.md)
    - [Server Configuration Parameters](./config_params/guc_config.md)
        - [Parameter Categories](./config_params/guc_category-list.md)
        - [Configuration Parameters](./config_params/guc-list.md)
    - [System Catalogs](./system_catalogs/catalog_ref.md)
        - [System Tables](./system_catalogs/catalog_ref-tables.md)
        - [System Views](./system_catalogs/catalog_ref-views.md)
        - [System Catalogs Definitions](./system_catalogs/catalog_ref-html.md)
            - [foreign\_data\_wrapper\_options](./system_catalogs/foreign_data_wrapper_options.md)
            - [foreign\_data\_wrappers](./system_catalogs/foreign_data_wrappers.md)
            - [foreign\_server\_options](./system_catalogs/foreign_server_options.md)
            - [foreign\_servers](./system_catalogs/foreign_servers.md)
            - [foreign\_table\_options](./system_catalogs/foreign_table_options.md)
            - [foreign\_tables](./system_catalogs/foreign_tables.md)
            - [gp\_configuration\_history](./system_catalogs/gp_configuration_history.md)
            - [gp\_distribution\_policy](./system_catalogs/gp_distribution_policy.md)
            - [gpexpand.status](./system_catalogs/gp_expansion_status.md)
            - [gpexpand.status\_detail](./system_catalogs/gp_expansion_tables.md)
            - [gp\_fastsequence](./system_catalogs/gp_fastsequence.md)
            - [gp\_id](./system_catalogs/gp_id.md)
            - [gp\_partition\_template](./system_catalogs/gp_partition_template.md)
            - [gp\_segment\_configuration](./system_catalogs/gp_segment_configuration.md)
            - [gp\_version\_at\_initdb](./system_catalogs/gp_version_at_initdb.md)
            - [pg\_aggregate](./system_catalogs/pg_aggregate.md)
            - [pg\_am](./system_catalogs/pg_am.md)
            - [pg\_amop](./system_catalogs/pg_amop.md)
            - [pg\_amproc](./system_catalogs/pg_amproc.md)
            - [pg\_appendonly](./system_catalogs/pg_appendonly.md)
            - [pg\_attrdef](./system_catalogs/pg_attrdef.md)
            - [pg\_attribute](./system_catalogs/pg_attribute.md)
            - [pg\_attribute\_encoding](./system_catalogs/pg_attribute_encoding.md)
            - [pg\_auth\_members](./system_catalogs/pg_auth_members.md)
            - [pg\_authid](./system_catalogs/pg_authid.md)
            - [pg\_available\_extension\_versions](./system_catalogs/pg_available_extension_versions.md)
            - [pg\_available\_extensions](./system_catalogs/pg_available_extensions.md)
            - [pg\_cast](./system_catalogs/pg_cast.md)
            - [pg\_class](./system_catalogs/pg_class.md)
            - [pg\_compression](./system_catalogs/pg_compression.md)
            - [pg\_constraint](./system_catalogs/pg_constraint.md)
            - [pg\_conversion](./system_catalogs/pg_conversion.md)
            - [pg\_database](./system_catalogs/pg_database.md)
            - [pg\_db\_role\_setting](./system_catalogs/pg_db_role_setting.md)
            - [pg\_depend](./system_catalogs/pg_depend.md)
            - [pg\_description](./system_catalogs/pg_description.md)
            - [pg\_enum](./system_catalogs/pg_enum.md)
            - [pg\_extension](./system_catalogs/pg_extension.md)
            - [pg\_exttable](./system_catalogs/pg_exttable.md)
            - [pg\_foreign\_data\_wrapper](./system_catalogs/pg_foreign_data_wrapper.md)
            - [pg\_foreign\_server](./system_catalogs/pg_foreign_server.md)
            - [pg\_foreign\_table](./system_catalogs/pg_foreign_table.md)
            - [pg\_index](./system_catalogs/pg_index.md)
            - [pg\_inherits](./system_catalogs/pg_inherits.md)
            - [pg\_language](./system_catalogs/pg_language.md)
            - [pg\_largeobject](./system_catalogs/pg_largeobject.md)
            - [pg\_locks](./system_catalogs/pg_locks.md)
            - [pg\_namespace](./system_catalogs/pg_namespace.md)
            - [pg\_opclass](./system_catalogs/pg_opclass.md)
            - [pg\_operator](./system_catalogs/pg_operator.md)
            - [pg\_opfamily](./system_catalogs/pg_opfamily.md)
            - [pg\_partitioned\_table](./system_catalogs/pg_partitioned_table.md)
            - [pg\_pltemplate](./system_catalogs/pg_pltemplate.md)
            - [pg\_policy](./system_catalogs/pg_policy.md)
            - [pg\_prepared\_statements](./system_catalogs/pg_prepared_statements.md)
            - [pg\_proc](./system_catalogs/pg_proc.md)
            - [pg\_resgroup](./system_catalogs/pg_resgroup.md)
            - [pg\_resgroupcapability](./system_catalogs/pg_resgroupcapability.md)
            - [pg\_resourcetype](./system_catalogs/pg_resourcetype.md)
            - [pg\_resqueue](./system_catalogs/pg_resqueue.md)
            - [pg\_resqueuecapability](./system_catalogs/pg_resqueuecapability.md)
            - [pg\_rewrite](./system_catalogs/pg_rewrite.md)
            - [pg\_roles](./system_catalogs/pg_roles.md)
            - [pg\_rules](./system_catalogs/pg_rules.md)
            - [pg\_shdepend](./system_catalogs/pg_shdepend.md)
            - [pg\_shdescription](./system_catalogs/pg_shdescription.md)
            - [pg\_stat\_last\_operation](./system_catalogs/pg_stat_last_operation.md)
            - [pg\_stat\_last\_shoperation](./system_catalogs/pg_stat_last_shoperation.md)
            - [pg\_stat\_operations](./system_catalogs/pg_stat_operations.md)
            - [pg\_statistic](./system_catalogs/pg_statistic.md)
            - [pg\_statistic\_ext](./system_catalogs/pg_statistic_ext.md)
            - [pg\_statistic\_ext\_data](./system_catalogs/pg_statistic_ext_data.md)
            - [pg\_tablespace](./system_catalogs/pg_tablespace.md)
            - [pg\_trigger](./system_catalogs/pg_trigger.md)
            - [pg\_type](./system_catalogs/pg_type.md)
            - [pg\_type\_encoding](./system_catalogs/pg_type_encoding.md)
            - [pg\_user\_mapping](./system_catalogs/pg_user_mapping.md)
            - [pg\_user\_mappings](./system_catalogs/pg_user_mappings.md)
            - [user\_mapping\_options](./system_catalogs/user_mapping_options.md)
            - [user\_mappings](./system_catalogs/user_mappings.md)
    - [The gp\_toolkit Administrative Schema](./gp_toolkit.md)
    - [Server Programmatic Interfaces](./extensions/srvapi_intro.md)
        - [Greenplum Partner Connector API](./extensions/gppc.md)
        - [Developing a Background Worker Process](./extensions/bgworker.md)
    - [SQL Features, Reserved and Key Words, and Compliance](./misc.md)
        - [Summary of Greenplum Features](./feature_summary.md)
        - [Reserved Identifiers and SQL Key Words](./sql-keywords.md)
        - [SQL 2008 Optional Feature Compliance](./SQL2008_support.md)
    - [Objects Removed in Greenplum 6](./removed-objects.md)
