Syntax diagrams for PostgreSQL

Created August 30, 2017, from gram.y, using Grammar Conversion and Railroad Diagram Generator.


stmtblock: stmt ; no referencesstmt: AlterEventTrigStmt AlterCollationStmt AlterDatabaseStmt AlterDatabaseSetStmt AlterDefaultPrivilegesStmt AlterDomainStmt AlterEnumStmt AlterExtensionStmt AlterExtensionContentsStmt AlterFdwStmt AlterForeignServerStmt AlterForeignTableStmt AlterFunctionStmt AlterGroupStmt AlterObjectDependsStmt AlterObjectSchemaStmt AlterOwnerStmt AlterOperatorStmt AlterPolicyStmt AlterSeqStmt AlterSystemStmt AlterTableStmt AlterTblSpcStmt AlterCompositeTypeStmt AlterPublicationStmt AlterRoleSetStmt AlterRoleStmt AlterSubscriptionStmt AlterTSConfigurationStmt AlterTSDictionaryStmt AlterUserMappingStmt AnalyzeStmt CheckPointStmt ClosePortalStmt ClusterStmt CommentStmt ConstraintsSetStmt CopyStmt CreateAmStmt CreateAsStmt CreateAssertStmt CreateCastStmt CreateConversionStmt CreateDomainStmt CreateExtensionStmt CreateFdwStmt CreateForeignServerStmt CreateForeignTableStmt CreateFunctionStmt CreateGroupStmt CreateMatViewStmt CreateOpClassStmt CreateOpFamilyStmt CreatePublicationStmt AlterOpFamilyStmt CreatePolicyStmt CreatePLangStmt CreateSchemaStmt CreateSeqStmt CreateStmt CreateSubscriptionStmt CreateStatsStmt CreateTableSpaceStmt CreateTransformStmt CreateTrigStmt CreateEventTrigStmt CreateRoleStmt CreateUserStmt CreateUserMappingStmt CreatedbStmt DeallocateStmt DeclareCursorStmt DefineStmt DeleteStmt DiscardStmt DoStmt DropAssertStmt DropCastStmt DropOpClassStmt DropOpFamilyStmt DropOwnedStmt DropPLangStmt DropStmt DropSubscriptionStmt DropTableSpaceStmt DropTransformStmt DropRoleStmt DropUserMappingStmt DropdbStmt ExecuteStmt ExplainStmt FetchStmt GrantStmt GrantRoleStmt ImportForeignSchemaStmt IndexStmt InsertStmt ListenStmt RefreshMatViewStmt LoadStmt LockStmt NotifyStmt PrepareStmt ReassignOwnedStmt ReindexStmt RemoveAggrStmt RemoveFuncStmt RemoveOperStmt RenameStmt RevokeStmt RevokeRoleStmt RuleStmt SecLabelStmt SelectStmt TransactionStmt TruncateStmt UnlistenStmt UpdateStmt VacuumStmt VariableResetStmt VariableSetStmt VariableShowStmt ViewStmt referenced by: stmtblock CreateRoleStmt: CREATE ROLE RoleId opt_with OptRoleList referenced by: stmt opt_with: WITH WITH_LA referenced by: AlterRoleStmt CopyStmt CreateExtensionStmt CreateGroupStmt CreateRoleStmt CreateUserStmt CreatedbStmt SeqOptElem alter_identity_column_option OptRoleList: CreateOptRoleElem referenced by: CreateGroupStmt CreateRoleStmt CreateUserStmt AlterOptRoleList: AlterOptRoleElem referenced by: AlterRoleStmt AlterOptRoleElem: PASSWORD Sconst NULL_P ENCRYPTED UNENCRYPTED PASSWORD VALID UNTIL Sconst INHERIT CONNECTION LIMIT SignedIconst USER role_list IDENT referenced by: AlterOptRoleList CreateOptRoleElem CreateOptRoleElem: AlterOptRoleElem SYSID Iconst ADMIN ROLE IN_P ROLE GROUP_P role_list referenced by: OptRoleList CreateUserStmt: CREATE USER RoleId opt_with OptRoleList referenced by: stmt AlterRoleStmt: ALTER ROLE USER RoleSpec opt_with AlterOptRoleList referenced by: stmt opt_in_database: IN_P DATABASE database_name referenced by: AlterRoleSetStmt AlterRoleSetStmt: ALTER ROLE USER RoleSpec ALL opt_in_database SetResetClause referenced by: stmt DropRoleStmt: DROP ROLE USER GROUP_P IF_P EXISTS role_list referenced by: stmt CreateGroupStmt: CREATE GROUP_P RoleId opt_with OptRoleList referenced by: stmt AlterGroupStmt: ALTER GROUP_P RoleSpec add_drop USER role_list referenced by: stmt add_drop: ADD_P DROP referenced by: AlterExtensionContentsStmt AlterGroupStmt CreateSchemaStmt: CREATE SCHEMA IF_P NOT EXISTS OptSchemaName AUTHORIZATION RoleSpec ColId OptSchemaEltList referenced by: stmt OptSchemaName: ColId referenced by: CreateSchemaStmt OptSchemaEltList: schema_stmt referenced by: CreateSchemaStmt schema_stmt: CreateStmt IndexStmt CreateSeqStmt CreateTrigStmt GrantStmt ViewStmt referenced by: OptSchemaEltList VariableSetStmt: SET LOCAL SESSION set_rest referenced by: stmt set_rest: SESSION CHARACTERISTICS AS TRANSACTION transaction_mode_list set_rest_more referenced by: SetResetClause VariableSetStmt generic_set: var_name TO = var_list DEFAULT referenced by: AlterSystemStmt set_rest_more set_rest_more: generic_set var_name FROM CURRENT_P TIME ZONE zone_value CATALOG_P SCHEMA TRANSACTION SNAPSHOT Sconst NAMES opt_encoding ROLE NonReservedWord_or_Sconst SESSION AUTHORIZATION NonReservedWord_or_Sconst DEFAULT XML_P OPTION document_or_content referenced by: FunctionSetResetClause set_rest var_name: ColId . referenced by: VariableShowStmt generic_reset generic_set set_rest_more var_list: var_value , referenced by: generic_set var_value: opt_boolean_or_string NumericOnly referenced by: var_list iso_level: READ UNCOMMITTED COMMITTED REPEATABLE READ SERIALIZABLE referenced by: transaction_mode_item opt_boolean_or_string: TRUE_P FALSE_P ON NonReservedWord_or_Sconst referenced by: copy_generic_opt_arg copy_generic_opt_arg_list_item createdb_opt_item explain_option_arg var_value zone_value: Sconst IDENT ConstInterval Sconst opt_interval ( Iconst ) Sconst NumericOnly DEFAULT LOCAL referenced by: set_rest_more opt_encoding: Sconst DEFAULT referenced by: set_rest_more NonReservedWord_or_Sconst: NonReservedWord Sconst referenced by: CreatePLangStmt DropPLangStmt alter_extension_opt_item create_extension_opt_item createfunc_opt_item dostmt_opt_item opt_boolean_or_string opt_provider set_rest_more VariableResetStmt: RESET reset_rest referenced by: FunctionSetResetClause SetResetClause stmt reset_rest: generic_reset TIME ZONE TRANSACTION ISOLATION LEVEL SESSION AUTHORIZATION referenced by: VariableResetStmt generic_reset: var_name ALL referenced by: AlterSystemStmt reset_rest SetResetClause: SET set_rest VariableResetStmt referenced by: AlterDatabaseSetStmt AlterRoleSetStmt FunctionSetResetClause: SET set_rest_more VariableResetStmt referenced by: common_func_opt_item VariableShowStmt: SHOW var_name TIME ZONE TRANSACTION ISOLATION LEVEL SESSION AUTHORIZATION ALL referenced by: stmt ConstraintsSetStmt: SET CONSTRAINTS constraints_set_list constraints_set_mode referenced by: stmt constraints_set_list: ALL qualified_name_list referenced by: ConstraintsSetStmt constraints_set_mode: DEFERRED IMMEDIATE referenced by: ConstraintsSetStmt CheckPointStmt: CHECKPOINT referenced by: stmt DiscardStmt: DISCARD ALL TEMP TEMPORARY PLANS SEQUENCES referenced by: stmt AlterTableStmt: ALTER TABLE IF_P EXISTS relation_expr alter_table_cmds partition_cmd ALL IN_P TABLESPACE name OWNED BY role_list SET TABLESPACE name opt_nowait INDEX MATERIALIZED VIEW IF_P EXISTS qualified_name alter_table_cmds ALL IN_P TABLESPACE name OWNED BY role_list SET TABLESPACE name opt_nowait SEQUENCE VIEW IF_P EXISTS qualified_name alter_table_cmds referenced by: stmt alter_table_cmds: alter_table_cmd , referenced by: AlterForeignTableStmt AlterTableStmt partition_cmd: ATTACH PARTITION qualified_name ForValues DETACH PARTITION qualified_name referenced by: AlterTableStmt alter_table_cmd: ADD_P COLUMN IF_P NOT EXISTS columnDef TableConstraint ALTER opt_column ColId alter_column_default DROP NOT NULL_P IDENTITY_P IF_P EXISTS SET NOT NULL_P STATISTICS SignedIconst reloptions STORAGE ColId RESET reloptions ADD_P GENERATED generated_when AS IDENTITY_P OptParenthesizedSeqOptList alter_identity_column_option opt_set_data TYPE_P Typename opt_collate_clause alter_using alter_generic_options CONSTRAINT name ConstraintAttributeSpec DROP opt_column IF_P EXISTS ColId CONSTRAINT IF_P EXISTS name opt_drop_behavior VALIDATE CONSTRAINT CLUSTER ON name SET WITH OIDS WITHOUT OIDS CLUSTER LOGGED UNLOGGED TABLESPACE name reloptions ENABLE_P TRIGGER name ALL USER ALWAYS REPLICA TRIGGER RULE RULE name ROW LEVEL SECURITY DISABLE_P TRIGGER name ALL USER RULE name ROW LEVEL SECURITY NO INHERIT qualified_name FORCE ROW LEVEL SECURITY OF any_name NOT OF OWNER TO RoleSpec RESET reloptions REPLICA IDENTITY_P replica_identity alter_generic_options referenced by: alter_table_cmds alter_column_default: SET DEFAULT a_expr DROP DEFAULT referenced by: AlterDomainStmt alter_table_cmd opt_drop_behavior: CASCADE RESTRICT referenced by: AlterDomainStmt DefACLAction DropAssertStmt DropCastStmt DropOpClassStmt DropOpFamilyStmt DropOwnedStmt DropPLangStmt DropStmt DropSubscriptionStmt DropTransformStmt RemoveAggrStmt RemoveFuncStmt RemoveOperStmt RenameStmt RevokeRoleStmt RevokeStmt TruncateStmt alter_table_cmd alter_type_cmd opt_collate_clause: COLLATE any_name referenced by: TableFuncElement alter_table_cmd alter_type_cmd alter_using: USING a_expr referenced by: alter_table_cmd replica_identity: NOTHING FULL DEFAULT USING INDEX name referenced by: alter_table_cmd reloptions: ( reloption_elem , ) referenced by: AlterTblSpcStmt OptWith alter_table_cmd opt_reloptions opt_reloptions: WITH reloptions referenced by: CreateTableSpaceStmt IndexStmt ViewStmt create_mv_target reloption_elem: ColLabel . ColLabel = def_arg referenced by: reloptions alter_identity_column_option: RESTART opt_with NumericOnly SET SeqOptElem GENERATED generated_when referenced by: alter_table_cmd ForValues: FOR VALUES IN_P ( partbound_datum , FROM ( range_datum_list ) TO ( range_datum_list ) referenced by: CreateForeignTableStmt CreateStmt partition_cmd partbound_datum: Sconst NumericOnly NULL_P referenced by: ForValues PartitionRangeDatum range_datum_list: PartitionRangeDatum , referenced by: ForValues PartitionRangeDatum: MINVALUE MAXVALUE partbound_datum referenced by: range_datum_list AlterCompositeTypeStmt: ALTER TYPE_P any_name alter_type_cmd , referenced by: stmt alter_type_cmd: ADD_P ATTRIBUTE TableFuncElement ALTER ATTRIBUTE ColId opt_set_data TYPE_P Typename opt_collate_clause DROP ATTRIBUTE IF_P EXISTS ColId opt_drop_behavior referenced by: AlterCompositeTypeStmt ClosePortalStmt: CLOSE cursor_name ALL referenced by: stmt CopyStmt: COPY opt_binary qualified_name opt_column_list opt_oids copy_from opt_program copy_file_name copy_delimiter ( PreparableStmt ) TO opt_program copy_file_name opt_with copy_options referenced by: stmt copy_from: FROM TO referenced by: CopyStmt opt_program: PROGRAM referenced by: CopyStmt copy_file_name: Sconst STDIN STDOUT referenced by: CopyStmt copy_options: copy_opt_item ( copy_generic_opt_elem , ) referenced by: CopyStmt copy_opt_item: BINARY OIDS FREEZE DELIMITER NULL_P QUOTE ESCAPE opt_as ENCODING Sconst CSV HEADER_P FORCE QUOTE columnList * NOT NULL_P columnList referenced by: copy_options opt_binary: BINARY referenced by: CopyStmt opt_oids: WITH OIDS referenced by: CopyStmt copy_delimiter: opt_using DELIMITERS Sconst referenced by: CopyStmt opt_using: USING referenced by: copy_delimiter copy_generic_opt_elem: ColLabel copy_generic_opt_arg referenced by: copy_options copy_generic_opt_arg: opt_boolean_or_string NumericOnly * ( copy_generic_opt_arg_list_item , ) referenced by: copy_generic_opt_elem copy_generic_opt_arg_list_item: opt_boolean_or_string referenced by: copy_generic_opt_arg CreateStmt: CREATE OptTemp TABLE IF_P NOT EXISTS qualified_name ( OptTableElementList ) OptInherit OF any_name OptTypedTableElementList PARTITION OF qualified_name OptTypedTableElementList ForValues OptPartitionSpec OptWith OnCommitOption OptTableSpace referenced by: schema_stmt stmt OptTemp: LOCAL GLOBAL TEMPORARY TEMP UNLOGGED referenced by: CreateAsStmt CreateSeqStmt CreateStmt ExecuteStmt ViewStmt OptTableElementList: TableElement , referenced by: CreateForeignTableStmt CreateStmt OptTypedTableElementList: ( TypedTableElement , ) referenced by: CreateForeignTableStmt CreateStmt TableElement: columnDef TableLikeClause TableConstraint referenced by: OptTableElementList TypedTableElement: columnOptions TableConstraint referenced by: OptTypedTableElementList columnDef: ColId Typename create_generic_options ColQualList referenced by: TableElement alter_table_cmd columnOptions: ColId WITH OPTIONS ColQualList referenced by: TypedTableElement ColQualList: ColConstraint referenced by: CreateDomainStmt columnDef columnOptions ColConstraint: CONSTRAINT name ColConstraintElem ConstraintAttr COLLATE any_name referenced by: ColQualList ColConstraintElem: NOT NULL_P UNIQUE PRIMARY KEY opt_definition OptConsTableSpace CHECK ( a_expr ) opt_no_inherit DEFAULT b_expr GENERATED generated_when AS IDENTITY_P OptParenthesizedSeqOptList REFERENCES qualified_name opt_column_list key_match key_actions referenced by: ColConstraint generated_when: ALWAYS BY DEFAULT referenced by: ColConstraintElem alter_identity_column_option alter_table_cmd ConstraintAttr: NOT DEFERRABLE INITIALLY DEFERRED IMMEDIATE referenced by: ColConstraint TableLikeClause: LIKE qualified_name INCLUDING EXCLUDING TableLikeOption referenced by: TableElement TableLikeOption: DEFAULTS CONSTRAINTS IDENTITY_P INDEXES STORAGE COMMENTS ALL referenced by: TableLikeClause TableConstraint: CONSTRAINT name ConstraintElem referenced by: AlterDomainStmt TableElement TypedTableElement alter_table_cmd ConstraintElem: CHECK ( a_expr ) EXCLUDE access_method_clause ( ExclusionConstraintElem , ) opt_definition OptConsTableSpace ExclusionWhereClause FOREIGN KEY ( columnList ) REFERENCES qualified_name opt_column_list key_match key_actions UNIQUE PRIMARY KEY ( columnList ) opt_definition OptConsTableSpace ExistingIndex ConstraintAttributeSpec referenced by: TableConstraint opt_no_inherit: NO INHERIT referenced by: ColConstraintElem opt_column_list: ( columnList ) referenced by: ColConstraintElem ConstraintElem CopyStmt ViewStmt create_as_target create_mv_target privilege columnList: columnElem , referenced by: ConstraintElem TriggerOneEvent ViewStmt copy_opt_item opt_column_list privileges columnElem: ColId referenced by: columnList key_match: MATCH FULL PARTIAL SIMPLE referenced by: ColConstraintElem ConstraintElem ExclusionConstraintElem: index_elem WITH any_operator OPERATOR ( any_operator ) referenced by: ConstraintElem ExclusionWhereClause: WHERE ( a_expr ) referenced by: ConstraintElem key_actions: key_update key_delete key_delete key_update referenced by: ColConstraintElem ConstraintElem key_update: ON UPDATE key_action referenced by: key_actions key_delete: ON DELETE_P key_action referenced by: key_actions key_action: NO ACTION RESTRICT CASCADE SET NULL_P DEFAULT referenced by: key_delete key_update OptInherit: INHERITS ( qualified_name_list ) referenced by: CreateForeignTableStmt CreateStmt OptPartitionSpec: PartitionSpec referenced by: CreateStmt PartitionSpec: PARTITION BY part_strategy ( part_elem , ) referenced by: OptPartitionSpec part_strategy: IDENT unreserved_keyword referenced by: PartitionSpec part_elem: ColId func_expr_windowless ( a_expr ) opt_collate opt_class referenced by: PartitionSpec OptWith: WITH reloptions OIDS WITHOUT OIDS referenced by: CreateStmt create_as_target OnCommitOption: ON COMMIT DROP DELETE_P PRESERVE ROWS referenced by: CreateStmt create_as_target OptTableSpace: TABLESPACE name referenced by: CreateStmt IndexStmt create_as_target create_mv_target OptConsTableSpace: USING INDEX TABLESPACE name referenced by: ColConstraintElem ConstraintElem ExistingIndex: USING INDEX index_name referenced by: ConstraintElem CreateStatsStmt: CREATE STATISTICS IF_P NOT EXISTS any_name opt_name_list ON expr_list FROM from_list referenced by: stmt CreateAsStmt: CREATE OptTemp TABLE IF_P NOT EXISTS create_as_target AS SelectStmt opt_with_data referenced by: ExplainableStmt stmt create_as_target: qualified_name opt_column_list OptWith OnCommitOption OptTableSpace referenced by: CreateAsStmt ExecuteStmt opt_with_data: WITH NO DATA_P referenced by: CreateAsStmt CreateMatViewStmt ExecuteStmt RefreshMatViewStmt CreateMatViewStmt: CREATE OptNoLog MATERIALIZED VIEW IF_P NOT EXISTS create_mv_target AS SelectStmt opt_with_data referenced by: ExplainableStmt stmt create_mv_target: qualified_name opt_column_list opt_reloptions OptTableSpace referenced by: CreateMatViewStmt OptNoLog: UNLOGGED referenced by: CreateMatViewStmt RefreshMatViewStmt: REFRESH MATERIALIZED VIEW opt_concurrently qualified_name opt_with_data referenced by: ExplainableStmt stmt CreateSeqStmt: CREATE OptTemp SEQUENCE IF_P NOT EXISTS qualified_name OptSeqOptList referenced by: schema_stmt stmt AlterSeqStmt: ALTER SEQUENCE IF_P EXISTS qualified_name SeqOptList referenced by: stmt OptSeqOptList: SeqOptList referenced by: CreateSeqStmt OptParenthesizedSeqOptList: ( SeqOptList ) referenced by: ColConstraintElem alter_table_cmd SeqOptList: SeqOptElem referenced by: AlterSeqStmt OptParenthesizedSeqOptList OptSeqOptList SeqOptElem: AS SimpleTypename CACHE INCREMENT opt_by MAXVALUE MINVALUE START opt_with NumericOnly CYCLE NO CYCLE MAXVALUE MINVALUE OWNED BY SEQUENCE NAME_P any_name RESTART opt_with NumericOnly referenced by: SeqOptList alter_identity_column_option opt_by: BY referenced by: SeqOptElem NumericOnly: + - FCONST SignedIconst referenced by: AlterOwnerStmt CommentStmt SecLabelStmt SeqOptElem alter_identity_column_option common_func_opt_item copy_generic_opt_arg def_arg explain_option_arg operator_def_arg partbound_datum privilege_target var_value zone_value CreatePLangStmt: CREATE opt_or_replace opt_trusted opt_procedural LANGUAGE NonReservedWord_or_Sconst HANDLER handler_name opt_inline_handler opt_validator referenced by: stmt opt_trusted: TRUSTED referenced by: CreatePLangStmt handler_name: name attrs referenced by: CreateAmStmt CreatePLangStmt fdw_option opt_inline_handler validator_clause opt_inline_handler: INLINE_P handler_name referenced by: CreatePLangStmt validator_clause: VALIDATOR handler_name NO VALIDATOR referenced by: opt_validator opt_validator: validator_clause referenced by: CreatePLangStmt DropPLangStmt: DROP opt_procedural LANGUAGE IF_P EXISTS NonReservedWord_or_Sconst opt_drop_behavior referenced by: stmt opt_procedural: PROCEDURAL referenced by: AlterExtensionContentsStmt AlterOwnerStmt CreatePLangStmt DropPLangStmt RenameStmt comment_type_name security_label_type_name CreateTableSpaceStmt: CREATE TABLESPACE name OptTableSpaceOwner LOCATION Sconst opt_reloptions referenced by: stmt OptTableSpaceOwner: OWNER RoleSpec referenced by: CreateTableSpaceStmt DropTableSpaceStmt: DROP TABLESPACE IF_P EXISTS name referenced by: stmt CreateExtensionStmt: CREATE EXTENSION IF_P NOT EXISTS name opt_with create_extension_opt_list referenced by: stmt create_extension_opt_list: create_extension_opt_item referenced by: CreateExtensionStmt create_extension_opt_item: SCHEMA name VERSION_P FROM NonReservedWord_or_Sconst CASCADE referenced by: create_extension_opt_list AlterExtensionStmt: ALTER EXTENSION name UPDATE alter_extension_opt_item referenced by: stmt alter_extension_opt_item: TO NonReservedWord_or_Sconst referenced by: AlterExtensionStmt AlterExtensionContentsStmt: ALTER EXTENSION name add_drop ACCESS METHOD opt_procedural TRANSFORM FOR Typename LANGUAGE SCHEMA EVENT TRIGGER SERVER name AGGREGATE aggregate_with_argtypes CAST ( Typename AS Typename ) COLLATION CONVERSION_P TABLE SEQUENCE MATERIALIZED VIEW TEXT_P SEARCH PARSER DICTIONARY TEMPLATE CONFIGURATION any_name DOMAIN_P TYPE_P Typename FUNCTION function_with_argtypes OPERATOR operator_with_argtypes CLASS FAMILY any_name USING access_method FOREIGN TABLE any_name DATA_P WRAPPER name referenced by: stmt CreateFdwStmt: CREATE FOREIGN DATA_P WRAPPER name opt_fdw_options create_generic_options referenced by: stmt fdw_option: HANDLER VALIDATOR handler_name NO HANDLER VALIDATOR referenced by: fdw_options fdw_options: fdw_option referenced by: AlterFdwStmt opt_fdw_options opt_fdw_options: fdw_options referenced by: AlterFdwStmt CreateFdwStmt AlterFdwStmt: ALTER FOREIGN DATA_P WRAPPER name opt_fdw_options alter_generic_options fdw_options referenced by: stmt create_generic_options: OPTIONS ( generic_option_elem , ) referenced by: CreateFdwStmt CreateForeignServerStmt CreateForeignTableStmt CreateUserMappingStmt ImportForeignSchemaStmt columnDef alter_generic_options: OPTIONS ( alter_generic_option_elem , ) referenced by: AlterFdwStmt AlterForeignServerStmt AlterUserMappingStmt alter_table_cmd alter_generic_option_elem: SET ADD_P generic_option_elem DROP generic_option_name referenced by: alter_generic_options generic_option_elem: generic_option_name generic_option_arg referenced by: alter_generic_option_elem create_generic_options generic_option_name: ColLabel referenced by: alter_generic_option_elem generic_option_elem generic_option_arg: Sconst referenced by: generic_option_elem CreateForeignServerStmt: CREATE SERVER IF_P NOT EXISTS name opt_type opt_foreign_server_version FOREIGN DATA_P WRAPPER name create_generic_options referenced by: stmt opt_type: TYPE_P Sconst referenced by: CreateForeignServerStmt foreign_server_version: VERSION_P Sconst NULL_P referenced by: AlterForeignServerStmt opt_foreign_server_version opt_foreign_server_version: foreign_server_version referenced by: CreateForeignServerStmt AlterForeignServerStmt: ALTER SERVER name foreign_server_version alter_generic_options alter_generic_options referenced by: stmt CreateForeignTableStmt: CREATE FOREIGN TABLE IF_P NOT EXISTS qualified_name ( OptTableElementList ) OptInherit PARTITION OF qualified_name OptTypedTableElementList ForValues SERVER name create_generic_options referenced by: stmt AlterForeignTableStmt: ALTER FOREIGN TABLE IF_P EXISTS relation_expr alter_table_cmds referenced by: stmt ImportForeignSchemaStmt: IMPORT_P FOREIGN SCHEMA name import_qualification FROM SERVER name INTO name create_generic_options referenced by: stmt import_qualification_type: LIMIT TO EXCEPT referenced by: import_qualification import_qualification: import_qualification_type ( relation_expr_list ) referenced by: ImportForeignSchemaStmt CreateUserMappingStmt: CREATE USER MAPPING IF_P NOT EXISTS FOR auth_ident SERVER name create_generic_options referenced by: stmt auth_ident: RoleSpec USER referenced by: AlterUserMappingStmt CreateUserMappingStmt DropUserMappingStmt DropUserMappingStmt: DROP USER MAPPING IF_P EXISTS FOR auth_ident SERVER name referenced by: stmt AlterUserMappingStmt: ALTER USER MAPPING FOR auth_ident SERVER name alter_generic_options referenced by: stmt CreatePolicyStmt: CREATE POLICY name ON qualified_name RowSecurityDefaultPermissive RowSecurityDefaultForCmd RowSecurityDefaultToRole RowSecurityOptionalExpr RowSecurityOptionalWithCheck referenced by: stmt AlterPolicyStmt: ALTER POLICY name ON qualified_name RowSecurityOptionalToRole RowSecurityOptionalExpr RowSecurityOptionalWithCheck referenced by: stmt RowSecurityOptionalExpr: USING ( a_expr ) referenced by: AlterPolicyStmt CreatePolicyStmt RowSecurityOptionalWithCheck: WITH CHECK ( a_expr ) referenced by: AlterPolicyStmt CreatePolicyStmt RowSecurityDefaultToRole: TO role_list referenced by: CreatePolicyStmt RowSecurityOptionalToRole: TO role_list referenced by: AlterPolicyStmt RowSecurityDefaultPermissive: AS IDENT referenced by: CreatePolicyStmt RowSecurityDefaultForCmd: FOR row_security_cmd referenced by: CreatePolicyStmt row_security_cmd: ALL SELECT INSERT UPDATE DELETE_P referenced by: RowSecurityDefaultForCmd CreateAmStmt: CREATE ACCESS METHOD name TYPE_P INDEX HANDLER handler_name referenced by: stmt CreateTrigStmt: CREATE TRIGGER name TriggerActionTime TriggerEvents ON qualified_name TriggerReferencing TriggerForSpec CONSTRAINT TRIGGER name AFTER TriggerEvents ON qualified_name OptConstrFromTable ConstraintAttributeSpec FOR EACH ROW TriggerWhen EXECUTE PROCEDURE func_name ( TriggerFuncArgs ) referenced by: schema_stmt stmt TriggerActionTime: BEFORE AFTER INSTEAD OF referenced by: CreateTrigStmt TriggerEvents: TriggerOneEvent OR referenced by: CreateTrigStmt TriggerOneEvent: INSERT DELETE_P UPDATE OF columnList TRUNCATE referenced by: TriggerEvents TriggerReferencing: REFERENCING TriggerTransition referenced by: CreateTrigStmt TriggerTransition: TransitionOldOrNew TransitionRowOrTable opt_as TransitionRelName referenced by: TriggerReferencing TransitionOldOrNew: NEW OLD referenced by: TriggerTransition TransitionRowOrTable: TABLE ROW referenced by: TriggerTransition TransitionRelName: ColId referenced by: TriggerTransition TriggerForSpec: FOR TriggerForOptEach TriggerForType referenced by: CreateTrigStmt TriggerForOptEach: EACH referenced by: TriggerForSpec TriggerForType: ROW STATEMENT referenced by: TriggerForSpec TriggerWhen: WHEN ( a_expr ) referenced by: CreateTrigStmt TriggerFuncArgs: TriggerFuncArg , TriggerFuncArg referenced by: CreateTrigStmt TriggerFuncArg: Iconst FCONST Sconst ColLabel referenced by: TriggerFuncArgs OptConstrFromTable: FROM qualified_name referenced by: CreateTrigStmt ConstraintAttributeSpec: ConstraintAttributeElem referenced by: ConstraintElem CreateAssertStmt CreateTrigStmt alter_table_cmd ConstraintAttributeElem: NOT DEFERRABLE VALID DEFERRABLE INITIALLY IMMEDIATE DEFERRED NO INHERIT referenced by: ConstraintAttributeSpec CreateEventTrigStmt: CREATE EVENT TRIGGER name ON ColLabel WHEN event_trigger_when_item AND EXECUTE PROCEDURE func_name ( ) referenced by: stmt event_trigger_when_item: ColId IN_P ( SCONST , ) referenced by: CreateEventTrigStmt AlterEventTrigStmt: ALTER EVENT TRIGGER name enable_trigger referenced by: stmt enable_trigger: ENABLE_P REPLICA ALWAYS DISABLE_P referenced by: AlterEventTrigStmt CreateAssertStmt: CREATE ASSERTION name CHECK ( a_expr ) ConstraintAttributeSpec referenced by: stmt DropAssertStmt: DROP ASSERTION name opt_drop_behavior referenced by: stmt DefineStmt: CREATE AGGREGATE func_name aggr_args definition old_aggr_definition OPERATOR any_operator TEXT_P SEARCH PARSER DICTIONARY TEMPLATE CONFIGURATION any_name definition TYPE_P any_name definition AS ( OptTableFuncElementList ENUM_P ( opt_enum_val_list ) RANGE definition COLLATION IF_P NOT EXISTS any_name definition FROM any_name referenced by: stmt definition: ( def_elem , ) referenced by: AlterPublicationStmt AlterSubscriptionStmt AlterTSDictionaryStmt DefineStmt opt_definition def_elem: ColLabel = def_arg referenced by: definition def_arg: func_type reserved_keyword qual_all_Op NumericOnly Sconst NONE referenced by: def_elem old_aggr_elem reloption_elem old_aggr_definition: ( old_aggr_elem , ) referenced by: DefineStmt old_aggr_elem: IDENT = def_arg referenced by: old_aggr_definition opt_enum_val_list: Sconst , referenced by: DefineStmt AlterEnumStmt: ALTER TYPE_P any_name ADD_P VALUE_P opt_if_not_exists Sconst BEFORE AFTER RENAME VALUE_P Sconst TO Sconst referenced by: stmt opt_if_not_exists: IF_P NOT EXISTS referenced by: AlterEnumStmt CreateOpClassStmt: CREATE OPERATOR CLASS any_name opt_default FOR TYPE_P Typename USING access_method opt_opfamily AS opclass_item_list referenced by: stmt opclass_item_list: opclass_item , referenced by: AlterOpFamilyStmt CreateOpClassStmt opclass_item: OPERATOR Iconst any_operator operator_with_argtypes opclass_purpose opt_recheck FUNCTION Iconst ( type_list ) function_with_argtypes STORAGE Typename referenced by: opclass_item_list opt_default: DEFAULT referenced by: CreateConversionStmt CreateOpClassStmt opt_opfamily: FAMILY any_name referenced by: CreateOpClassStmt opclass_purpose: FOR SEARCH ORDER BY any_name referenced by: opclass_item opt_recheck: RECHECK referenced by: opclass_item CreateOpFamilyStmt: CREATE OPERATOR FAMILY any_name USING access_method referenced by: stmt AlterOpFamilyStmt: ALTER OPERATOR FAMILY any_name USING access_method ADD_P opclass_item_list DROP opclass_drop , referenced by: stmt opclass_drop: OPERATOR FUNCTION Iconst ( type_list ) referenced by: AlterOpFamilyStmt DropOpClassStmt: DROP OPERATOR CLASS IF_P EXISTS any_name USING access_method opt_drop_behavior referenced by: stmt DropOpFamilyStmt: DROP OPERATOR FAMILY IF_P EXISTS any_name USING access_method opt_drop_behavior referenced by: stmt DropOwnedStmt: DROP OWNED BY role_list opt_drop_behavior referenced by: stmt ReassignOwnedStmt: REASSIGN OWNED BY role_list TO RoleSpec referenced by: stmt DropStmt: DROP drop_type_any_name INDEX CONCURRENTLY IF_P EXISTS any_name_list drop_type_name IF_P EXISTS name_list drop_type_name_on_any_name IF_P EXISTS name ON any_name TYPE_P DOMAIN_P IF_P EXISTS type_name_list opt_drop_behavior referenced by: stmt drop_type_any_name: FOREIGN TABLE SEQUENCE MATERIALIZED VIEW INDEX COLLATION CONVERSION_P STATISTICS TEXT_P SEARCH PARSER DICTIONARY TEMPLATE CONFIGURATION referenced by: DropStmt drop_type_name: ACCESS METHOD EVENT TRIGGER EXTENSION FOREIGN DATA_P WRAPPER PUBLICATION SCHEMA SERVER referenced by: DropStmt drop_type_name_on_any_name: POLICY RULE TRIGGER referenced by: DropStmt any_name_list: any_name , referenced by: AlterTSConfigurationStmt DropStmt privilege_target any_name: ColId attrs referenced by: AlterCollationStmt AlterCompositeTypeStmt AlterDomainStmt AlterEnumStmt AlterExtensionContentsStmt AlterObjectSchemaStmt AlterOpFamilyStmt AlterOwnerStmt AlterTSConfigurationStmt AlterTSDictionaryStmt ColConstraint CommentStmt CreateConversionStmt CreateDomainStmt CreateOpClassStmt CreateOpFamilyStmt CreateStatsStmt CreateStmt DefineStmt DropOpClassStmt DropOpFamilyStmt DropStmt RenameStmt SecLabelStmt SeqOptElem a_expr alter_table_cmd any_name_list opclass_purpose opt_class opt_collate opt_collate_clause opt_opfamily attrs: . attr_name referenced by: GenericType any_name func_type handler_name type_name_list: Typename , referenced by: DropStmt TruncateStmt: TRUNCATE opt_table relation_expr_list opt_restart_seqs opt_drop_behavior referenced by: stmt opt_restart_seqs: CONTINUE_P RESTART IDENTITY_P referenced by: TruncateStmt CommentStmt: COMMENT ON comment_type_any_name POLICY RULE TRIGGER name ON CONSTRAINT name ON DOMAIN_P any_name comment_type_name TRANSFORM FOR Typename LANGUAGE name TYPE_P DOMAIN_P Typename AGGREGATE aggregate_with_argtypes FUNCTION function_with_argtypes LARGE_P OBJECT_P NumericOnly CAST ( Typename AS Typename ) OPERATOR operator_with_argtypes CLASS FAMILY any_name USING access_method IS comment_text referenced by: stmt comment_type_any_name: COLUMN INDEX SEQUENCE STATISTICS FOREIGN TABLE MATERIALIZED VIEW COLLATION CONVERSION_P TEXT_P SEARCH CONFIGURATION DICTIONARY PARSER TEMPLATE referenced by: CommentStmt comment_type_name: ACCESS METHOD DATABASE EVENT TRIGGER EXTENSION FOREIGN DATA_P WRAPPER opt_procedural LANGUAGE PUBLICATION ROLE SCHEMA SERVER SUBSCRIPTION TABLESPACE referenced by: CommentStmt comment_text: Sconst NULL_P referenced by: CommentStmt SecLabelStmt: SECURITY LABEL opt_provider ON security_label_type_any_name any_name security_label_type_name name TYPE_P DOMAIN_P Typename AGGREGATE aggregate_with_argtypes FUNCTION function_with_argtypes LARGE_P OBJECT_P NumericOnly IS security_label referenced by: stmt opt_provider: FOR NonReservedWord_or_Sconst referenced by: SecLabelStmt security_label_type_any_name: COLUMN FOREIGN TABLE SEQUENCE MATERIALIZED VIEW referenced by: SecLabelStmt security_label_type_name: DATABASE EVENT TRIGGER opt_procedural LANGUAGE PUBLICATION ROLE SCHEMA SUBSCRIPTION TABLESPACE referenced by: SecLabelStmt security_label: Sconst NULL_P referenced by: SecLabelStmt FetchStmt: FETCH MOVE fetch_args referenced by: stmt fetch_args: from_in NEXT PRIOR FIRST_P LAST_P ABSOLUTE_P RELATIVE_P SignedIconst ALL FORWARD BACKWARD SignedIconst ALL opt_from_in cursor_name referenced by: FetchStmt from_in: FROM IN_P referenced by: fetch_args opt_from_in opt_from_in: from_in referenced by: fetch_args GrantStmt: GRANT privileges ON privilege_target TO grantee_list opt_grant_grant_option referenced by: schema_stmt stmt RevokeStmt: REVOKE GRANT OPTION FOR privileges ON privilege_target FROM grantee_list opt_drop_behavior referenced by: stmt privileges: privilege_list ALL PRIVILEGES ( columnList ) referenced by: DefACLAction GrantStmt RevokeStmt privilege_list: privilege , referenced by: GrantRoleStmt RevokeRoleStmt privileges privilege: SELECT REFERENCES CREATE ColId opt_column_list referenced by: privilege_list privilege_target: TABLE SEQUENCE qualified_name_list FOREIGN DATA_P WRAPPER SERVER DATABASE LANGUAGE ALL TABLES SEQUENCES FUNCTIONS IN_P SCHEMA TABLESPACE name_list FUNCTION function_with_argtypes_list DOMAIN_P TYPE_P any_name_list LARGE_P OBJECT_P NumericOnly , referenced by: GrantStmt RevokeStmt grantee_list: grantee , referenced by: DefACLAction GrantStmt RevokeStmt grantee: GROUP_P RoleSpec referenced by: grantee_list opt_grant_grant_option: WITH GRANT OPTION referenced by: DefACLAction GrantStmt GrantRoleStmt: GRANT privilege_list TO role_list opt_grant_admin_option opt_granted_by referenced by: stmt RevokeRoleStmt: REVOKE ADMIN OPTION FOR privilege_list FROM role_list opt_granted_by opt_drop_behavior referenced by: stmt opt_grant_admin_option: WITH ADMIN OPTION referenced by: GrantRoleStmt opt_granted_by: GRANTED BY RoleSpec referenced by: GrantRoleStmt RevokeRoleStmt AlterDefaultPrivilegesStmt: ALTER DEFAULT PRIVILEGES DefACLOption DefACLAction referenced by: stmt DefACLOption: IN_P SCHEMA name_list FOR ROLE USER role_list referenced by: AlterDefaultPrivilegesStmt DefACLAction: GRANT privileges ON defacl_privilege_target TO grantee_list opt_grant_grant_option REVOKE GRANT OPTION FOR privileges ON defacl_privilege_target FROM grantee_list opt_drop_behavior referenced by: AlterDefaultPrivilegesStmt defacl_privilege_target: TABLES FUNCTIONS SEQUENCES TYPES_P SCHEMAS referenced by: DefACLAction IndexStmt: CREATE opt_unique INDEX opt_concurrently opt_index_name IF_P NOT EXISTS index_name ON qualified_name access_method_clause ( index_params ) opt_reloptions OptTableSpace where_clause referenced by: schema_stmt stmt opt_unique: UNIQUE referenced by: IndexStmt opt_concurrently: CONCURRENTLY referenced by: IndexStmt RefreshMatViewStmt opt_index_name: index_name referenced by: IndexStmt access_method_clause: USING access_method referenced by: ConstraintElem IndexStmt index_params: index_elem , referenced by: IndexStmt opt_conf_expr index_elem: ColId func_expr_windowless ( a_expr ) opt_collate opt_class opt_asc_desc opt_nulls_order referenced by: ExclusionConstraintElem index_params opt_collate: COLLATE any_name referenced by: index_elem part_elem opt_class: any_name referenced by: index_elem part_elem opt_asc_desc: ASC DESC referenced by: index_elem sortby opt_nulls_order: NULLS_LA FIRST_P LAST_P referenced by: index_elem sortby CreateFunctionStmt: CREATE opt_or_replace FUNCTION func_name func_args_with_defaults RETURNS func_return TABLE ( table_func_column , ) createfunc_opt_list opt_definition referenced by: stmt opt_or_replace: OR REPLACE referenced by: CreateFunctionStmt CreatePLangStmt CreateTransformStmt RuleStmt func_args: ( func_arg , ) referenced by: function_with_argtypes function_with_argtypes_list: function_with_argtypes , referenced by: RemoveFuncStmt privilege_target function_with_argtypes: func_name func_args type_func_name_keyword ColId indirection referenced by: AlterExtensionContentsStmt AlterFunctionStmt AlterObjectDependsStmt AlterObjectSchemaStmt AlterOwnerStmt CommentStmt CreateCastStmt RenameStmt SecLabelStmt function_with_argtypes_list opclass_item transform_element_list func_args_with_defaults: ( func_arg_with_default , ) referenced by: CreateFunctionStmt func_arg: arg_class param_name param_name arg_class func_type referenced by: aggr_arg func_arg_with_default func_args arg_class: IN_P OUT_P OUT_P INOUT VARIADIC referenced by: func_arg param_name: type_function_name referenced by: func_arg func_arg_expr table_func_column func_return: func_type referenced by: CreateFunctionStmt func_type: Typename SETOF type_function_name attrs % TYPE_P referenced by: def_arg func_arg func_return operator_def_arg table_func_column func_arg_with_default: func_arg DEFAULT = a_expr referenced by: func_args_with_defaults aggr_arg: func_arg referenced by: aggr_args_list aggr_args: ( * aggr_args_list ORDER BY aggr_args_list ) referenced by: DefineStmt aggregate_with_argtypes aggr_args_list: aggr_arg , referenced by: aggr_args aggregate_with_argtypes: func_name aggr_args referenced by: AlterExtensionContentsStmt AlterObjectSchemaStmt AlterOwnerStmt CommentStmt RenameStmt SecLabelStmt aggregate_with_argtypes_list aggregate_with_argtypes_list: aggregate_with_argtypes , referenced by: RemoveAggrStmt createfunc_opt_list: createfunc_opt_item referenced by: CreateFunctionStmt common_func_opt_item: CALLED RETURNS NULL_P ON NULL_P INPUT_P STRICT_P IMMUTABLE STABLE VOLATILE EXTERNAL SECURITY DEFINER INVOKER NOT LEAKPROOF COST ROWS NumericOnly FunctionSetResetClause PARALLEL ColId referenced by: AlterFunctionStmt createfunc_opt_item createfunc_opt_item: AS func_as LANGUAGE NonReservedWord_or_Sconst TRANSFORM FOR TYPE_P Typename , WINDOW common_func_opt_item referenced by: createfunc_opt_list func_as: Sconst , Sconst referenced by: createfunc_opt_item opt_definition: WITH definition referenced by: AlterSubscriptionStmt ColConstraintElem ConstraintElem CreateFunctionStmt CreatePublicationStmt CreateSubscriptionStmt table_func_column: param_name func_type referenced by: CreateFunctionStmt AlterFunctionStmt: ALTER FUNCTION function_with_argtypes common_func_opt_item opt_restrict referenced by: stmt opt_restrict: RESTRICT referenced by: AlterFunctionStmt RemoveFuncStmt: DROP FUNCTION IF_P EXISTS function_with_argtypes_list opt_drop_behavior referenced by: stmt RemoveAggrStmt: DROP AGGREGATE IF_P EXISTS aggregate_with_argtypes_list opt_drop_behavior referenced by: stmt RemoveOperStmt: DROP OPERATOR IF_P EXISTS operator_with_argtypes_list opt_drop_behavior referenced by: stmt oper_argtypes: ( Typename , Typename NONE NONE , Typename ) referenced by: operator_with_argtypes any_operator: ColId . all_Op referenced by: DefineStmt ExclusionConstraintElem opclass_item operator_with_argtypes qual_Op qual_all_Op subquery_Op operator_with_argtypes_list: operator_with_argtypes , referenced by: RemoveOperStmt operator_with_argtypes: any_operator oper_argtypes referenced by: AlterExtensionContentsStmt AlterObjectSchemaStmt AlterOperatorStmt AlterOwnerStmt CommentStmt opclass_item operator_with_argtypes_list DoStmt: DO dostmt_opt_item referenced by: stmt dostmt_opt_item: Sconst LANGUAGE NonReservedWord_or_Sconst referenced by: DoStmt CreateCastStmt: CREATE CAST ( Typename AS Typename ) WITH FUNCTION function_with_argtypes INOUT WITHOUT FUNCTION cast_context referenced by: stmt cast_context: AS IMPLICIT_P ASSIGNMENT referenced by: CreateCastStmt DropCastStmt: DROP CAST opt_if_exists ( Typename AS Typename ) opt_drop_behavior referenced by: stmt opt_if_exists: IF_P EXISTS referenced by: DropCastStmt DropTransformStmt CreateTransformStmt: CREATE opt_or_replace TRANSFORM FOR Typename LANGUAGE name ( transform_element_list ) referenced by: stmt transform_element_list: FROM SQL_P WITH FUNCTION function_with_argtypes , TO TO SQL_P WITH FUNCTION function_with_argtypes , FROM SQL_P WITH FUNCTION function_with_argtypes referenced by: CreateTransformStmt DropTransformStmt: DROP TRANSFORM opt_if_exists FOR Typename LANGUAGE name opt_drop_behavior referenced by: stmt ReindexStmt: REINDEX ( reindex_option_list ) reindex_target_type qualified_name reindex_target_multitable name referenced by: stmt reindex_target_type: INDEX TABLE referenced by: ReindexStmt reindex_target_multitable: SCHEMA SYSTEM_P DATABASE referenced by: ReindexStmt reindex_option_list: reindex_option_elem , referenced by: ReindexStmt reindex_option_elem: VERBOSE referenced by: reindex_option_list AlterTblSpcStmt: ALTER TABLESPACE name SET RESET reloptions referenced by: stmt RenameStmt: ALTER AGGREGATE aggregate_with_argtypes COLLATION CONVERSION_P STATISTICS TEXT_P SEARCH PARSER DICTIONARY TEMPLATE CONFIGURATION any_name FUNCTION function_with_argtypes opt_procedural LANGUAGE PUBLICATION SCHEMA SERVER SUBSCRIPTION EVENT TRIGGER TABLESPACE name RULE TRIGGER POLICY IF_P EXISTS name ON SEQUENCE VIEW INDEX IF_P EXISTS qualified_name OPERATOR CLASS FAMILY any_name USING access_method RENAME DOMAIN_P any_name RENAME CONSTRAINT name TABLE IF_P EXISTS relation_expr RENAME opt_column CONSTRAINT name MATERIALIZED VIEW IF_P EXISTS qualified_name RENAME opt_column name FOREIGN DATA_P WRAPPER name RENAME TABLE IF_P EXISTS relation_expr RENAME opt_column name TO name DATABASE database_name RENAME TO database_name GROUP_P ROLE USER RoleId RENAME TO RoleId TYPE_P any_name RENAME TO name ATTRIBUTE name TO name opt_drop_behavior referenced by: stmt opt_column: COLUMN referenced by: RenameStmt alter_table_cmd opt_set_data: SET DATA_P referenced by: alter_table_cmd alter_type_cmd AlterObjectDependsStmt: ALTER FUNCTION function_with_argtypes TRIGGER name ON MATERIALIZED VIEW INDEX qualified_name DEPENDS ON EXTENSION name referenced by: stmt AlterObjectSchemaStmt: ALTER AGGREGATE aggregate_with_argtypes COLLATION CONVERSION_P DOMAIN_P STATISTICS TYPE_P TEXT_P SEARCH PARSER DICTIONARY TEMPLATE CONFIGURATION any_name EXTENSION name FUNCTION function_with_argtypes OPERATOR operator_with_argtypes CLASS FAMILY any_name USING access_method FOREIGN TABLE IF_P EXISTS relation_expr SEQUENCE MATERIALIZED VIEW IF_P EXISTS qualified_name SET SCHEMA name referenced by: stmt AlterOperatorStmt: ALTER OPERATOR operator_with_argtypes SET ( operator_def_elem , ) referenced by: stmt operator_def_elem: ColLabel = NONE operator_def_arg referenced by: AlterOperatorStmt operator_def_arg: func_type reserved_keyword qual_all_Op NumericOnly Sconst referenced by: operator_def_elem AlterOwnerStmt: ALTER AGGREGATE aggregate_with_argtypes COLLATION CONVERSION_P DOMAIN_P TYPE_P STATISTICS TEXT_P SEARCH DICTIONARY CONFIGURATION any_name DATABASE database_name FUNCTION function_with_argtypes opt_procedural LANGUAGE SCHEMA TABLESPACE FOREIGN DATA_P WRAPPER SERVER EVENT TRIGGER PUBLICATION SUBSCRIPTION name LARGE_P OBJECT_P NumericOnly OPERATOR operator_with_argtypes CLASS FAMILY any_name USING access_method OWNER TO RoleSpec referenced by: stmt CreatePublicationStmt: CREATE PUBLICATION name opt_publication_for_tables opt_definition referenced by: stmt opt_publication_for_tables: publication_for_tables referenced by: CreatePublicationStmt publication_for_tables: FOR TABLE relation_expr_list ALL TABLES referenced by: opt_publication_for_tables AlterPublicationStmt: ALTER PUBLICATION name SET definition TABLE relation_expr_list ADD_P DROP TABLE relation_expr_list referenced by: stmt CreateSubscriptionStmt: CREATE SUBSCRIPTION name CONNECTION Sconst PUBLICATION publication_name_list opt_definition referenced by: stmt publication_name_list: publication_name_item , referenced by: AlterSubscriptionStmt CreateSubscriptionStmt publication_name_item: ColLabel referenced by: publication_name_list AlterSubscriptionStmt: ALTER SUBSCRIPTION name SET definition PUBLICATION publication_name_list opt_definition CONNECTION Sconst REFRESH PUBLICATION opt_definition ENABLE_P DISABLE_P referenced by: stmt DropSubscriptionStmt: DROP SUBSCRIPTION IF_P EXISTS name opt_drop_behavior referenced by: stmt RuleStmt: CREATE opt_or_replace RULE name AS ON event TO qualified_name where_clause DO opt_instead RuleActionList referenced by: stmt RuleActionList: NOTHING RuleActionStmt ( RuleActionStmtOrEmpty ; ) referenced by: RuleStmt RuleActionStmt: SelectStmt InsertStmt UpdateStmt DeleteStmt NotifyStmt referenced by: RuleActionList RuleActionStmtOrEmpty RuleActionStmtOrEmpty: RuleActionStmt referenced by: RuleActionList event: SELECT UPDATE DELETE_P INSERT referenced by: RuleStmt opt_instead: INSTEAD ALSO referenced by: RuleStmt NotifyStmt: NOTIFY ColId notify_payload referenced by: RuleActionStmt stmt notify_payload: , Sconst referenced by: NotifyStmt ListenStmt: LISTEN ColId referenced by: stmt UnlistenStmt: UNLISTEN ColId * referenced by: stmt TransactionStmt: ABORT_P END_P opt_transaction BEGIN_P opt_transaction START TRANSACTION transaction_mode_list_or_empty COMMIT opt_transaction PREPARED Sconst ROLLBACK opt_transaction TO SAVEPOINT ColId PREPARED Sconst SAVEPOINT RELEASE SAVEPOINT ColId PREPARE TRANSACTION Sconst referenced by: stmt opt_transaction: WORK TRANSACTION referenced by: TransactionStmt transaction_mode_item: ISOLATION LEVEL iso_level READ ONLY WRITE NOT DEFERRABLE referenced by: transaction_mode_list transaction_mode_list: transaction_mode_item , referenced by: set_rest transaction_mode_list_or_empty transaction_mode_list_or_empty: transaction_mode_list referenced by: TransactionStmt ViewStmt: CREATE OR REPLACE OptTemp VIEW qualified_name opt_column_list RECURSIVE VIEW qualified_name ( columnList ) opt_reloptions AS SelectStmt opt_check_option referenced by: schema_stmt stmt opt_check_option: WITH CASCADED LOCAL CHECK OPTION referenced by: ViewStmt LoadStmt: LOAD file_name referenced by: stmt CreatedbStmt: CREATE DATABASE database_name opt_with createdb_opt_list referenced by: stmt createdb_opt_list: createdb_opt_item referenced by: AlterDatabaseStmt CreatedbStmt createdb_opt_item: createdb_opt_name opt_equal SignedIconst opt_boolean_or_string DEFAULT referenced by: createdb_opt_list createdb_opt_name: IDENT CONNECTION LIMIT ENCODING LOCATION OWNER TABLESPACE TEMPLATE referenced by: createdb_opt_item opt_equal: = referenced by: createdb_opt_item AlterDatabaseStmt: ALTER DATABASE database_name WITH createdb_opt_list SET TABLESPACE name referenced by: stmt AlterDatabaseSetStmt: ALTER DATABASE database_name SetResetClause referenced by: stmt DropdbStmt: DROP DATABASE IF_P EXISTS database_name referenced by: stmt AlterCollationStmt: ALTER COLLATION any_name REFRESH VERSION_P referenced by: stmt AlterSystemStmt: ALTER SYSTEM_P SET generic_set RESET generic_reset referenced by: stmt CreateDomainStmt: CREATE DOMAIN_P any_name opt_as Typename ColQualList referenced by: stmt AlterDomainStmt: ALTER DOMAIN_P any_name alter_column_default DROP NOT NULL_P CONSTRAINT IF_P EXISTS name opt_drop_behavior SET NOT NULL_P ADD_P TableConstraint VALIDATE CONSTRAINT name referenced by: stmt opt_as: AS referenced by: CreateDomainStmt TriggerTransition copy_opt_item AlterTSDictionaryStmt: ALTER TEXT_P SEARCH DICTIONARY any_name definition referenced by: stmt AlterTSConfigurationStmt: ALTER TEXT_P SEARCH CONFIGURATION any_name ADD_P MAPPING FOR name_list any_with any_name_list ALTER MAPPING FOR name_list any_with any_name_list REPLACE any_name any_with any_name REPLACE any_name any_with any_name DROP MAPPING IF_P EXISTS FOR name_list referenced by: stmt any_with: WITH WITH_LA referenced by: AlterTSConfigurationStmt CreateConversionStmt: CREATE opt_default CONVERSION_P any_name FOR Sconst TO Sconst FROM any_name referenced by: stmt ClusterStmt: CLUSTER opt_verbose qualified_name cluster_index_specification index_name ON qualified_name referenced by: stmt cluster_index_specification: USING index_name referenced by: ClusterStmt VacuumStmt: VACUUM opt_full opt_freeze opt_verbose qualified_name AnalyzeStmt ( vacuum_option_list ) qualified_name opt_name_list referenced by: stmt vacuum_option_list: vacuum_option_elem , referenced by: VacuumStmt vacuum_option_elem: analyze_keyword VERBOSE FREEZE FULL IDENT referenced by: vacuum_option_list AnalyzeStmt: analyze_keyword opt_verbose qualified_name opt_name_list referenced by: VacuumStmt stmt analyze_keyword: ANALYZE ANALYSE referenced by: AnalyzeStmt ExplainStmt explain_option_name vacuum_option_elem opt_verbose: VERBOSE referenced by: AnalyzeStmt ClusterStmt ExplainStmt VacuumStmt opt_full: FULL referenced by: VacuumStmt opt_freeze: FREEZE referenced by: VacuumStmt opt_name_list: ( name_list ) referenced by: AnalyzeStmt CreateStatsStmt VacuumStmt common_table_expr ExplainStmt: EXPLAIN analyze_keyword opt_verbose VERBOSE ( explain_option_elem , ) ExplainableStmt referenced by: stmt ExplainableStmt: SelectStmt InsertStmt UpdateStmt DeleteStmt DeclareCursorStmt CreateAsStmt CreateMatViewStmt RefreshMatViewStmt ExecuteStmt referenced by: ExplainStmt explain_option_elem: explain_option_name explain_option_arg referenced by: ExplainStmt explain_option_name: NonReservedWord analyze_keyword referenced by: explain_option_elem explain_option_arg: opt_boolean_or_string NumericOnly referenced by: explain_option_elem PrepareStmt: PREPARE name prep_type_clause AS PreparableStmt referenced by: stmt prep_type_clause: ( type_list ) referenced by: PrepareStmt PreparableStmt: SelectStmt InsertStmt UpdateStmt DeleteStmt referenced by: CopyStmt PrepareStmt common_table_expr ExecuteStmt: EXECUTE name execute_param_clause CREATE OptTemp TABLE create_as_target AS EXECUTE name execute_param_clause opt_with_data referenced by: ExplainableStmt stmt execute_param_clause: ( expr_list ) referenced by: ExecuteStmt DeallocateStmt: DEALLOCATE PREPARE name ALL referenced by: stmt InsertStmt: opt_with_clause INSERT INTO insert_target insert_rest opt_on_conflict returning_clause referenced by: ExplainableStmt PreparableStmt RuleActionStmt stmt insert_target: qualified_name AS ColId referenced by: InsertStmt insert_rest: ( insert_column_list ) OVERRIDING override_kind VALUE_P SelectStmt DEFAULT VALUES referenced by: InsertStmt override_kind: USER SYSTEM_P referenced by: insert_rest insert_column_list: insert_column_item , referenced by: insert_rest insert_column_item: ColId opt_indirection referenced by: insert_column_list opt_on_conflict: ON CONFLICT opt_conf_expr DO UPDATE SET set_clause_list where_clause NOTHING referenced by: InsertStmt opt_conf_expr: ( index_params ) where_clause ON CONSTRAINT name referenced by: opt_on_conflict returning_clause: RETURNING target_list referenced by: DeleteStmt InsertStmt UpdateStmt DeleteStmt: opt_with_clause DELETE_P FROM relation_expr_opt_alias using_clause where_or_current_clause returning_clause referenced by: ExplainableStmt PreparableStmt RuleActionStmt stmt using_clause: USING from_list referenced by: DeleteStmt LockStmt: LOCK_P opt_table relation_expr_list opt_lock opt_nowait referenced by: stmt opt_lock: IN_P lock_type MODE referenced by: LockStmt lock_type: ACCESS ROW SHARE EXCLUSIVE SHARE UPDATE ROW EXCLUSIVE EXCLUSIVE referenced by: opt_lock opt_nowait: NOWAIT referenced by: AlterTableStmt LockStmt opt_nowait_or_skip: NOWAIT SKIP LOCKED referenced by: for_locking_item UpdateStmt: opt_with_clause UPDATE relation_expr_opt_alias SET set_clause_list from_clause where_or_current_clause returning_clause referenced by: ExplainableStmt PreparableStmt RuleActionStmt stmt set_clause_list: set_clause , referenced by: UpdateStmt opt_on_conflict set_clause: set_target ( set_target , ) = a_expr referenced by: set_clause_list set_target: ColId opt_indirection referenced by: set_clause DeclareCursorStmt: DECLARE cursor_name NO SCROLL BINARY INSENSITIVE CURSOR opt_hold FOR SelectStmt referenced by: ExplainableStmt stmt cursor_name: name referenced by: ClosePortalStmt DeclareCursorStmt fetch_args where_or_current_clause opt_hold: WITH WITHOUT HOLD referenced by: DeclareCursorStmt SelectStmt: select_no_parens select_with_parens referenced by: CreateAsStmt CreateMatViewStmt DeclareCursorStmt ExplainableStmt PreparableStmt RuleActionStmt ViewStmt insert_rest stmt select_with_parens: ( select_no_parens select_with_parens ) referenced by: SelectStmt a_expr c_expr in_expr select_clause select_with_parens table_ref select_no_parens: simple_select select_clause sort_clause opt_sort_clause for_locking_clause opt_select_limit select_limit opt_for_locking_clause with_clause select_clause sort_clause opt_sort_clause for_locking_clause opt_select_limit select_limit opt_for_locking_clause referenced by: SelectStmt select_with_parens select_clause: simple_select select_with_parens referenced by: select_no_parens simple_select simple_select: SELECT opt_all_clause opt_target_list distinct_clause target_list into_clause from_clause where_clause group_clause having_clause window_clause VALUES ( expr_list ) , TABLE relation_expr select_clause UNION INTERSECT EXCEPT all_or_distinct select_clause referenced by: select_clause select_no_parens with_clause: WITH RECURSIVE WITH_LA cte_list referenced by: opt_with_clause select_no_parens cte_list: common_table_expr , referenced by: with_clause common_table_expr: name opt_name_list AS ( PreparableStmt ) referenced by: cte_list opt_with_clause: with_clause referenced by: DeleteStmt InsertStmt UpdateStmt into_clause: INTO OptTempTableName referenced by: simple_select OptTempTableName: LOCAL GLOBAL TEMPORARY TEMP UNLOGGED opt_table TABLE qualified_name referenced by: into_clause opt_table: TABLE referenced by: LockStmt OptTempTableName TruncateStmt all_or_distinct: ALL DISTINCT referenced by: simple_select distinct_clause: DISTINCT ON ( expr_list ) referenced by: simple_select opt_all_clause: ALL referenced by: simple_select opt_sort_clause: sort_clause referenced by: AexprConst func_application select_no_parens window_specification sort_clause: ORDER BY sortby , referenced by: opt_sort_clause select_no_parens within_group_clause sortby: a_expr USING qual_all_Op opt_asc_desc opt_nulls_order referenced by: sort_clause select_limit: limit_clause offset_clause offset_clause limit_clause referenced by: opt_select_limit select_no_parens opt_select_limit: select_limit referenced by: select_no_parens limit_clause: LIMIT select_limit_value , select_offset_value FETCH first_or_next opt_select_fetch_first_value row_or_rows ONLY referenced by: select_limit offset_clause: OFFSET select_offset_value select_offset_value2 row_or_rows referenced by: select_limit select_limit_value: a_expr ALL referenced by: limit_clause select_offset_value: a_expr referenced by: limit_clause offset_clause opt_select_fetch_first_value: SignedIconst ( a_expr ) referenced by: limit_clause select_offset_value2: c_expr referenced by: offset_clause row_or_rows: ROW ROWS referenced by: limit_clause offset_clause first_or_next: FIRST_P NEXT referenced by: limit_clause group_clause: GROUP_P BY group_by_list referenced by: simple_select group_by_list: group_by_item , referenced by: group_clause grouping_sets_clause group_by_item: a_expr empty_grouping_set cube_clause rollup_clause grouping_sets_clause referenced by: group_by_list empty_grouping_set: ( ) referenced by: group_by_item rollup_clause: ROLLUP ( expr_list ) referenced by: group_by_item cube_clause: CUBE ( expr_list ) referenced by: group_by_item grouping_sets_clause: GROUPING SETS ( group_by_list ) referenced by: group_by_item having_clause: HAVING a_expr referenced by: simple_select for_locking_clause: for_locking_item FOR READ ONLY referenced by: opt_for_locking_clause select_no_parens opt_for_locking_clause: for_locking_clause referenced by: select_no_parens for_locking_item: for_locking_strength locked_rels_list opt_nowait_or_skip referenced by: for_locking_clause for_locking_strength: FOR NO KEY UPDATE KEY SHARE referenced by: for_locking_item locked_rels_list: OF qualified_name_list referenced by: for_locking_item from_clause: FROM from_list referenced by: UpdateStmt simple_select from_list: table_ref , referenced by: CreateStatsStmt from_clause using_clause table_ref: relation_expr opt_alias_clause tablesample_clause LATERAL_P func_table func_alias_clause xmltable select_with_parens opt_alias_clause joined_table ( joined_table ) alias_clause referenced by: from_list joined_table joined_table: ( joined_table ) table_ref CROSS NATURAL join_type JOIN table_ref join_type JOIN table_ref join_qual referenced by: joined_table table_ref alias_clause: AS ColId ( name_list ) referenced by: func_alias_clause opt_alias_clause table_ref opt_alias_clause: alias_clause referenced by: table_ref func_alias_clause: alias_clause AS ColId ColId ( TableFuncElementList ) referenced by: table_ref join_type: FULL LEFT RIGHT join_outer INNER_P referenced by: joined_table join_outer: OUTER_P referenced by: join_type join_qual: USING ( name_list ) ON a_expr referenced by: joined_table relation_expr: qualified_name * ONLY qualified_name ( qualified_name ) referenced by: AlterForeignTableStmt AlterObjectSchemaStmt AlterTableStmt RenameStmt relation_expr_list relation_expr_opt_alias simple_select table_ref relation_expr_list: relation_expr , referenced by: AlterPublicationStmt LockStmt TruncateStmt import_qualification publication_for_tables relation_expr_opt_alias: relation_expr AS ColId referenced by: DeleteStmt UpdateStmt tablesample_clause: TABLESAMPLE func_name ( expr_list ) opt_repeatable_clause referenced by: table_ref opt_repeatable_clause: REPEATABLE ( a_expr ) referenced by: tablesample_clause func_table: func_expr_windowless ROWS FROM ( rowsfrom_item , ) opt_ordinality referenced by: table_ref rowsfrom_item: func_expr_windowless opt_col_def_list referenced by: func_table opt_col_def_list: AS ( TableFuncElementList ) referenced by: rowsfrom_item opt_ordinality: WITH_LA ORDINALITY referenced by: func_table where_clause: WHERE a_expr referenced by: IndexStmt RuleStmt opt_conf_expr opt_on_conflict simple_select where_or_current_clause: WHERE a_expr CURRENT_P OF cursor_name referenced by: DeleteStmt UpdateStmt OptTableFuncElementList: TableFuncElementList referenced by: DefineStmt TableFuncElementList: TableFuncElement , referenced by: OptTableFuncElementList func_alias_clause opt_col_def_list TableFuncElement: ColId Typename opt_collate_clause referenced by: TableFuncElementList alter_type_cmd xmltable: XMLTABLE ( XMLNAMESPACES ( xml_namespace_el , ) , c_expr xmlexists_argument COLUMNS xmltable_column_list ) referenced by: table_ref xmltable_column_list: xmltable_column_el , referenced by: xmltable xmltable_column_el: ColId Typename xmltable_column_option_el FOR ORDINALITY referenced by: xmltable_column_list xmltable_column_option_el: IDENT DEFAULT b_expr NOT NULL_P referenced by: xmltable_column_el xml_namespace_el: b_expr AS ColLabel DEFAULT b_expr referenced by: xmltable Typename: SETOF SimpleTypename opt_array_bounds ARRAY [ Iconst ] referenced by: AlterExtensionContentsStmt CommentStmt CreateCastStmt CreateDomainStmt CreateOpClassStmt CreateTransformStmt DropCastStmt DropTransformStmt SecLabelStmt TableFuncElement a_expr alter_table_cmd alter_type_cmd b_expr columnDef createfunc_opt_item func_expr_common_subexpr func_type opclass_item oper_argtypes type_list type_name_list xmltable_column_el opt_array_bounds: [ Iconst ] referenced by: Typename SimpleTypename: GenericType Numeric Bit Character ConstDatetime ConstInterval opt_interval ( Iconst ) referenced by: SeqOptElem Typename func_expr_common_subexpr ConstTypename: Numeric ConstBit ConstCharacter ConstDatetime referenced by: AexprConst GenericType: type_function_name attrs opt_type_modifiers referenced by: SimpleTypename opt_type_modifiers: ( expr_list ) referenced by: GenericType Numeric Numeric: INT_P INTEGER SMALLINT BIGINT REAL FLOAT_P opt_float DOUBLE_P PRECISION DECIMAL_P DEC NUMERIC opt_type_modifiers BOOLEAN_P referenced by: ConstTypename SimpleTypename opt_float: ( Iconst ) referenced by: Numeric Bit: BitWithLength BitWithoutLength referenced by: SimpleTypename ConstBit: BitWithLength BitWithoutLength referenced by: ConstTypename BitWithLength: BIT opt_varying ( expr_list ) referenced by: Bit ConstBit BitWithoutLength: BIT opt_varying referenced by: Bit ConstBit Character: CharacterWithLength CharacterWithoutLength referenced by: SimpleTypename ConstCharacter: CharacterWithLength CharacterWithoutLength referenced by: ConstTypename CharacterWithLength: character ( Iconst ) referenced by: Character ConstCharacter CharacterWithoutLength: character referenced by: Character ConstCharacter character: NATIONAL CHARACTER CHAR_P NCHAR opt_varying VARCHAR referenced by: CharacterWithLength CharacterWithoutLength opt_varying: VARYING referenced by: BitWithLength BitWithoutLength character ConstDatetime: TIMESTAMP TIME ( Iconst ) opt_timezone referenced by: ConstTypename SimpleTypename ConstInterval: INTERVAL referenced by: AexprConst SimpleTypename zone_value opt_timezone: WITH_LA WITHOUT TIME ZONE referenced by: ConstDatetime opt_interval: YEAR_P TO MONTH_P MONTH_P DAY_P TO HOUR_P MINUTE_P interval_second HOUR_P TO MINUTE_P interval_second MINUTE_P TO interval_second interval_second referenced by: AexprConst SimpleTypename zone_value interval_second: SECOND_P ( Iconst ) referenced by: opt_interval a_expr: c_expr a_expr TYPECAST Typename COLLATE any_name AT TIME ZONE + - * / % ^ < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS BETWEEN opt_asymmetric SYMMETRIC b_expr AND OR LIKE ILIKE SIMILAR TO a_expr ESCAPE a_expr qual_Op a_expr NOT_LA LIKE ILIKE SIMILAR TO a_expr ESCAPE BETWEEN opt_asymmetric SYMMETRIC b_expr AND a_expr IN_P in_expr IS NOT NULL_P TRUE_P FALSE_P UNKNOWN DISTINCT FROM a_expr OF ( type_list ) DOCUMENT_P ISNULL NOTNULL IN_P in_expr subquery_Op sub_type select_with_parens ( a_expr ) + - qual_Op NOT NOT_LA a_expr row OVERLAPS row UNIQUE select_with_parens DEFAULT referenced by: ColConstraintElem ConstraintElem CreateAssertStmt ExclusionWhereClause RowSecurityOptionalExpr RowSecurityOptionalWithCheck TriggerWhen a_expr alter_column_default alter_using c_expr case_arg case_default expr_list extract_list filter_clause frame_bound func_arg_expr func_arg_with_default func_expr_common_subexpr group_by_item having_clause implicit_row index_elem indirection_el join_qual opt_repeatable_clause opt_select_fetch_first_value opt_slice_bound overlay_list overlay_placing part_elem row select_limit_value select_offset_value set_clause sortby substr_for substr_from substr_list target_el trim_list when_clause where_clause where_or_current_clause xml_attribute_el xml_root_version b_expr: c_expr b_expr TYPECAST Typename + - * / % ^ < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS b_expr qual_Op b_expr IS NOT DISTINCT FROM b_expr OF ( type_list ) DOCUMENT_P + - qual_Op b_expr referenced by: ColConstraintElem a_expr b_expr position_list xml_namespace_el xmltable_column_option_el c_expr: columnref AexprConst PARAM ( a_expr ) opt_indirection case_expr func_expr select_with_parens indirection EXISTS select_with_parens ARRAY select_with_parens array_expr explicit_row implicit_row GROUPING ( expr_list ) referenced by: a_expr b_expr func_expr_common_subexpr select_offset_value2 xmlexists_argument xmltable func_application: func_name ( VARIADIC func_arg_expr ALL DISTINCT func_arg_list func_arg_list , VARIADIC func_arg_expr opt_sort_clause * ) referenced by: func_expr func_expr_windowless func_expr: func_application within_group_clause filter_clause over_clause func_expr_common_subexpr referenced by: c_expr func_expr_windowless: func_application func_expr_common_subexpr referenced by: func_table index_elem part_elem rowsfrom_item func_expr_common_subexpr: COLLATION FOR ( NULLIF ( a_expr , a_expr CAST TREAT ( a_expr AS Typename EXTRACT ( extract_list OVERLAY ( overlay_list POSITION ( position_list SUBSTRING ( substr_list COALESCE GREATEST LEAST XMLCONCAT ( expr_list XMLEXISTS ( c_expr xmlexists_argument XMLFOREST ( xml_attribute_list XMLPARSE ( document_or_content a_expr xml_whitespace_option XMLROOT ( a_expr , xml_root_version opt_xml_root_standalone XMLSERIALIZE ( document_or_content a_expr AS SimpleTypename TRIM ( BOTH LEADING TRAILING trim_list XMLPI ( NAME_P ColLabel , a_expr XMLELEMENT ( NAME_P ColLabel , xml_attributes , expr_list expr_list ) CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP LOCALTIME LOCALTIMESTAMP ( Iconst ) CURRENT_ROLE CURRENT_USER SESSION_USER USER CURRENT_CATALOG CURRENT_SCHEMA referenced by: func_expr func_expr_windowless xml_root_version: VERSION_P a_expr NO VALUE_P referenced by: func_expr_common_subexpr opt_xml_root_standalone: , STANDALONE_P YES_P NO VALUE_P referenced by: func_expr_common_subexpr xml_attributes: XMLATTRIBUTES ( xml_attribute_list ) referenced by: func_expr_common_subexpr xml_attribute_list: xml_attribute_el , referenced by: func_expr_common_subexpr xml_attributes xml_attribute_el: a_expr AS ColLabel referenced by: xml_attribute_list document_or_content: DOCUMENT_P CONTENT_P referenced by: func_expr_common_subexpr set_rest_more xml_whitespace_option: PRESERVE STRIP_P WHITESPACE_P referenced by: func_expr_common_subexpr xmlexists_argument: PASSING BY REF c_expr BY REF referenced by: func_expr_common_subexpr xmltable within_group_clause: WITHIN GROUP_P ( sort_clause ) referenced by: func_expr filter_clause: FILTER ( WHERE a_expr ) referenced by: func_expr window_clause: WINDOW window_definition , referenced by: simple_select window_definition: ColId AS window_specification referenced by: window_clause over_clause: OVER window_specification ColId referenced by: func_expr window_specification: ( opt_existing_window_name opt_partition_clause opt_sort_clause opt_frame_clause ) referenced by: over_clause window_definition opt_existing_window_name: ColId referenced by: window_specification opt_partition_clause: PARTITION BY expr_list referenced by: window_specification opt_frame_clause: RANGE ROWS frame_extent referenced by: window_specification frame_extent: BETWEEN frame_bound AND frame_bound referenced by: opt_frame_clause frame_bound: UNBOUNDED a_expr PRECEDING FOLLOWING CURRENT_P ROW referenced by: frame_extent row: ROW ( expr_list ( expr_list , a_expr ) referenced by: a_expr explicit_row: ROW ( expr_list ) referenced by: c_expr implicit_row: ( expr_list , a_expr ) referenced by: c_expr sub_type: ANY SOME ALL referenced by: a_expr all_Op: Op MathOp referenced by: any_operator qual_all_Op subquery_Op MathOp: + - * / % ^ < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS referenced by: all_Op qual_Op: Op OPERATOR ( any_operator ) referenced by: a_expr b_expr qual_all_Op: all_Op OPERATOR ( any_operator ) referenced by: def_arg operator_def_arg sortby subquery_Op: all_Op OPERATOR ( any_operator ) NOT_LA LIKE ILIKE referenced by: a_expr expr_list: a_expr , referenced by: BitWithLength CreateStatsStmt array_expr c_expr cube_clause distinct_clause execute_param_clause explicit_row func_expr_common_subexpr implicit_row in_expr opt_partition_clause opt_type_modifiers rollup_clause row simple_select substr_list tablesample_clause trim_list func_arg_list: func_arg_expr , referenced by: AexprConst func_application func_arg_expr: param_name COLON_EQUALS EQUALS_GREATER a_expr referenced by: func_application func_arg_list type_list: Typename , referenced by: a_expr b_expr opclass_drop opclass_item prep_type_clause array_expr: [ expr_list array_expr , ] referenced by: array_expr c_expr extract_list: extract_arg FROM a_expr referenced by: func_expr_common_subexpr extract_arg: IDENT YEAR_P MONTH_P DAY_P HOUR_P MINUTE_P SECOND_P Sconst referenced by: extract_list overlay_list: a_expr overlay_placing substr_from substr_for referenced by: func_expr_common_subexpr overlay_placing: PLACING a_expr referenced by: overlay_list position_list: b_expr IN_P b_expr referenced by: func_expr_common_subexpr substr_list: a_expr substr_from substr_for substr_for substr_from expr_list referenced by: func_expr_common_subexpr substr_from: FROM a_expr referenced by: overlay_list substr_list substr_for: FOR a_expr referenced by: overlay_list substr_list trim_list: a_expr FROM expr_list referenced by: func_expr_common_subexpr in_expr: select_with_parens ( expr_list ) referenced by: a_expr case_expr: CASE case_arg when_clause case_default END_P referenced by: c_expr when_clause: WHEN a_expr THEN a_expr referenced by: case_expr case_default: ELSE a_expr referenced by: case_expr case_arg: a_expr referenced by: case_expr columnref: ColId indirection referenced by: c_expr indirection_el: . attr_name * [ a_expr opt_slice_bound : opt_slice_bound ] referenced by: indirection opt_indirection opt_slice_bound: a_expr referenced by: indirection_el indirection: indirection_el referenced by: c_expr columnref func_name function_with_argtypes qualified_name opt_indirection: indirection_el referenced by: c_expr insert_column_item set_target opt_asymmetric: ASYMMETRIC referenced by: a_expr opt_target_list: target_list referenced by: simple_select target_list: target_el , referenced by: opt_target_list returning_clause simple_select target_el: a_expr AS ColLabel IDENT * referenced by: target_list qualified_name_list: qualified_name , referenced by: OptInherit constraints_set_list locked_rels_list privilege_target qualified_name: ColId indirection referenced by: AlterObjectDependsStmt AlterObjectSchemaStmt AlterPolicyStmt AlterSeqStmt AlterTableStmt AnalyzeStmt ClusterStmt ColConstraintElem ConstraintElem CopyStmt CreateForeignTableStmt CreatePolicyStmt CreateSeqStmt CreateStmt CreateTrigStmt IndexStmt OptConstrFromTable OptTempTableName RefreshMatViewStmt ReindexStmt RenameStmt RuleStmt TableLikeClause VacuumStmt ViewStmt alter_table_cmd create_as_target create_mv_target insert_target partition_cmd qualified_name_list relation_expr name_list: name , referenced by: AlterTSConfigurationStmt DefACLOption DropStmt alias_clause join_qual opt_name_list privilege_target name: ColId referenced by: AlterDatabaseStmt AlterDomainStmt AlterEventTrigStmt AlterExtensionContentsStmt AlterExtensionStmt AlterFdwStmt AlterForeignServerStmt AlterObjectDependsStmt AlterObjectSchemaStmt AlterOwnerStmt AlterPolicyStmt AlterPublicationStmt AlterSubscriptionStmt AlterTableStmt AlterTblSpcStmt AlterUserMappingStmt ColConstraint CommentStmt CreateAmStmt CreateAssertStmt CreateEventTrigStmt CreateExtensionStmt CreateFdwStmt CreateForeignServerStmt CreateForeignTableStmt CreatePolicyStmt CreatePublicationStmt CreateSubscriptionStmt CreateTableSpaceStmt CreateTransformStmt CreateTrigStmt CreateUserMappingStmt DeallocateStmt DropAssertStmt DropStmt DropSubscriptionStmt DropTableSpaceStmt DropTransformStmt DropUserMappingStmt ExecuteStmt ImportForeignSchemaStmt OptConsTableSpace OptTableSpace PrepareStmt ReindexStmt RenameStmt RuleStmt SecLabelStmt TableConstraint alter_table_cmd common_table_expr create_extension_opt_item cursor_name handler_name name_list opt_conf_expr replica_identity database_name: ColId referenced by: AlterDatabaseSetStmt AlterDatabaseStmt AlterOwnerStmt CreatedbStmt DropdbStmt RenameStmt opt_in_database access_method: ColId referenced by: AlterExtensionContentsStmt AlterObjectSchemaStmt AlterOpFamilyStmt AlterOwnerStmt CommentStmt CreateOpClassStmt CreateOpFamilyStmt DropOpClassStmt DropOpFamilyStmt RenameStmt access_method_clause attr_name: ColLabel referenced by: attrs indirection_el index_name: ColId referenced by: ClusterStmt ExistingIndex IndexStmt cluster_index_specification opt_index_name file_name: Sconst referenced by: LoadStmt func_name: type_function_name ColId indirection referenced by: AexprConst CreateEventTrigStmt CreateFunctionStmt CreateTrigStmt DefineStmt aggregate_with_argtypes func_application function_with_argtypes tablesample_clause AexprConst: Iconst FCONST ConstTypename func_name ( func_arg_list opt_sort_clause ) Sconst BCONST XCONST ConstInterval Sconst opt_interval ( Iconst ) Sconst TRUE_P FALSE_P NULL_P referenced by: c_expr Iconst: ICONST referenced by: AexprConst CharacterWithLength ConstDatetime CreateOptRoleElem SignedIconst SimpleTypename TriggerFuncArg Typename func_expr_common_subexpr interval_second opclass_drop opclass_item opt_array_bounds opt_float zone_value Sconst: SCONST referenced by: AexprConst AlterEnumStmt AlterOptRoleElem AlterSubscriptionStmt CreateConversionStmt CreateSubscriptionStmt CreateTableSpaceStmt NonReservedWord_or_Sconst TransactionStmt TriggerFuncArg comment_text copy_delimiter copy_file_name copy_opt_item def_arg dostmt_opt_item extract_arg file_name foreign_server_version func_as generic_option_arg notify_payload operator_def_arg opt_encoding opt_enum_val_list opt_type partbound_datum security_label set_rest_more zone_value SignedIconst: + - Iconst referenced by: AlterOptRoleElem NumericOnly alter_table_cmd createdb_opt_item fetch_args opt_select_fetch_first_value RoleId: RoleSpec referenced by: CreateGroupStmt CreateRoleStmt CreateUserStmt RenameStmt RoleSpec: NonReservedWord CURRENT_USER SESSION_USER referenced by: AlterGroupStmt AlterOwnerStmt AlterRoleSetStmt AlterRoleStmt CreateSchemaStmt OptTableSpaceOwner ReassignOwnedStmt RoleId alter_table_cmd auth_ident grantee opt_granted_by role_list role_list: RoleSpec , referenced by: AlterGroupStmt AlterOptRoleElem AlterTableStmt CreateOptRoleElem DefACLOption DropOwnedStmt DropRoleStmt GrantRoleStmt ReassignOwnedStmt RevokeRoleStmt RowSecurityDefaultToRole RowSecurityOptionalToRole ColId: IDENT unreserved_keyword col_name_keyword referenced by: CreateSchemaStmt ListenStmt NotifyStmt OptSchemaName TableFuncElement TransactionStmt TransitionRelName UnlistenStmt access_method alias_clause alter_table_cmd alter_type_cmd any_name any_operator columnDef columnElem columnOptions columnref common_func_opt_item database_name event_trigger_when_item func_alias_clause func_name function_with_argtypes index_elem index_name insert_column_item insert_target name opt_existing_window_name over_clause part_elem privilege qualified_name relation_expr_opt_alias set_target var_name window_definition xmltable_column_el type_function_name: IDENT unreserved_keyword type_func_name_keyword referenced by: GenericType func_name func_type param_name NonReservedWord: IDENT unreserved_keyword col_name_keyword type_func_name_keyword referenced by: NonReservedWord_or_Sconst RoleSpec explain_option_name ColLabel: IDENT unreserved_keyword col_name_keyword type_func_name_keyword reserved_keyword referenced by: CreateEventTrigStmt TriggerFuncArg attr_name copy_generic_opt_elem def_elem func_expr_common_subexpr generic_option_name operator_def_elem publication_name_item reloption_elem target_el xml_attribute_el xml_namespace_el unreserved_keyword: ABORT_P ABSOLUTE_P ACCESS ACTION ADD_P ADMIN AFTER AGGREGATE ALSO ALTER ALWAYS ASSERTION ASSIGNMENT AT ATTACH ATTRIBUTE BACKWARD BEFORE BEGIN_P BY CACHE CALLED CASCADE CASCADED CATALOG_P CHAIN CHARACTERISTICS CHECKPOINT CLASS CLOSE CLUSTER COLUMNS COMMENT COMMENTS COMMIT COMMITTED CONFIGURATION CONFLICT CONNECTION CONSTRAINTS CONTENT_P CONTINUE_P CONVERSION_P COPY COST CSV CUBE CURRENT_P CURSOR CYCLE DATA_P DATABASE DAY_P DEALLOCATE DECLARE DEFAULTS DEFERRED DEFINER DELETE_P DELIMITER DELIMITERS DEPENDS DETACH DICTIONARY DISABLE_P DISCARD DOCUMENT_P DOMAIN_P DOUBLE_P DROP EACH ENABLE_P ENCODING ENCRYPTED ENUM_P ESCAPE EVENT EXCLUDE EXCLUDING EXCLUSIVE EXECUTE EXPLAIN EXTENSION EXTERNAL FAMILY FILTER FIRST_P FOLLOWING FORCE FORWARD FUNCTION FUNCTIONS GENERATED GLOBAL GRANTED HANDLER HEADER_P HOLD HOUR_P IDENTITY_P IF_P IMMEDIATE IMMUTABLE IMPLICIT_P IMPORT_P INCLUDING INCREMENT INDEX INDEXES INHERIT INHERITS INLINE_P INPUT_P INSENSITIVE INSERT INSTEAD INVOKER ISOLATION KEY LABEL LANGUAGE LARGE_P LAST_P LEAKPROOF LEVEL LISTEN LOAD LOCAL LOCATION LOCK_P LOCKED LOGGED MAPPING MATCH MATERIALIZED MAXVALUE METHOD MINUTE_P MINVALUE MODE MONTH_P MOVE NAME_P NAMES NEW NEXT NO NOTHING NOTIFY NOWAIT NULLS_P OBJECT_P OF OFF OIDS OLD OPERATOR OPTION OPTIONS ORDINALITY OVER OVERRIDING OWNED OWNER PARALLEL PARSER PARTIAL PARTITION PASSING PASSWORD PLANS POLICY PRECEDING PREPARE PREPARED PRESERVE PRIOR PRIVILEGES PROCEDURAL PROCEDURE PROGRAM PUBLICATION QUOTE RANGE READ REASSIGN RECHECK RECURSIVE REF REFERENCING REFRESH REINDEX RELATIVE_P RELEASE RENAME REPEATABLE REPLACE REPLICA RESET RESTART RESTRICT RETURNS REVOKE ROLE ROLLBACK ROLLUP ROWS RULE SAVEPOINT SCHEMA SCHEMAS SCROLL SEARCH SECOND_P SECURITY SEQUENCE SEQUENCES SERIALIZABLE SERVER SESSION SET SETS SHARE SHOW SIMPLE SKIP SNAPSHOT SQL_P STABLE STANDALONE_P START STATEMENT STATISTICS STDIN STDOUT STORAGE STRICT_P STRIP_P SUBSCRIPTION SYSID SYSTEM_P TABLES TABLESPACE TEMP TEMPLATE TEMPORARY TEXT_P TRANSACTION TRANSFORM TRIGGER TRUNCATE TRUSTED TYPE_P TYPES_P UNBOUNDED UNCOMMITTED UNENCRYPTED UNKNOWN UNLISTEN UNLOGGED UNTIL UPDATE VACUUM VALID VALIDATE VALIDATOR VALUE_P VARYING VERSION_P VIEW VIEWS VOLATILE WHITESPACE_P WITHIN WITHOUT WORK WRAPPER WRITE XML_P YEAR_P YES_P ZONE referenced by: ColId ColLabel NonReservedWord part_strategy type_function_name col_name_keyword: BETWEEN BIGINT BIT BOOLEAN_P CHAR_P CHARACTER COALESCE DEC DECIMAL_P EXISTS EXTRACT FLOAT_P GREATEST GROUPING INOUT INT_P INTEGER INTERVAL LEAST NATIONAL NCHAR NONE NULLIF NUMERIC OUT_P OVERLAY POSITION PRECISION REAL ROW SETOF SMALLINT SUBSTRING TIME TIMESTAMP TREAT TRIM VALUES VARCHAR XMLATTRIBUTES XMLCONCAT XMLELEMENT XMLEXISTS XMLFOREST XMLNAMESPACES XMLPARSE XMLPI XMLROOT XMLSERIALIZE XMLTABLE referenced by: ColId ColLabel NonReservedWord type_func_name_keyword: AUTHORIZATION BINARY COLLATION CONCURRENTLY CROSS CURRENT_SCHEMA FREEZE FULL ILIKE INNER_P IS ISNULL JOIN LEFT LIKE NATURAL NOTNULL OUTER_P OVERLAPS RIGHT SIMILAR TABLESAMPLE VERBOSE referenced by: ColLabel NonReservedWord function_with_argtypes type_function_name reserved_keyword: ALL ANALYSE ANALYZE AND ANY ARRAY AS ASC ASYMMETRIC BOTH CASE CAST CHECK COLLATE COLUMN CONSTRAINT CREATE CURRENT_CATALOG CURRENT_DATE CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER DEFAULT DEFERRABLE DESC DISTINCT DO ELSE END_P EXCEPT FALSE_P FETCH FOR FOREIGN FROM GRANT GROUP_P HAVING IN_P INITIALLY INTERSECT INTO LATERAL_P LEADING LIMIT LOCALTIME LOCALTIMESTAMP NOT NULL_P OFFSET ON ONLY OR ORDER PLACING PRIMARY REFERENCES RETURNING SELECT SESSION_USER SOME SYMMETRIC TABLE THEN TO TRAILING TRUE_P UNION UNIQUE USER USING VARIADIC WHEN WHERE WINDOW WITH referenced by: ColLabel def_arg operator_def_arg ... generated by Railroad Diagram Generator R R