Syntax diagrams for PostgreSQL
Created August 30, 2017, from gram.y,
using Grammar Conversion and Railroad Diagram Generator.
stmtblock:
no referencesstmt:
referenced by:
stmtblock
CreateRoleStmt:
referenced by:
stmt
opt_with:
referenced by:
AlterRoleStmt
CopyStmt
CreateExtensionStmt
CreateGroupStmt
CreateRoleStmt
CreateUserStmt
CreatedbStmt
SeqOptElem
alter_identity_column_option
OptRoleList:
referenced by:
CreateGroupStmt
CreateRoleStmt
CreateUserStmt
AlterOptRoleList:
referenced by:
AlterRoleStmt
AlterOptRoleElem:
referenced by:
AlterOptRoleList
CreateOptRoleElem
CreateOptRoleElem:
referenced by:
OptRoleList
CreateUserStmt:
referenced by:
stmt
AlterRoleStmt:
referenced by:
stmt
opt_in_database:
referenced by:
AlterRoleSetStmt
AlterRoleSetStmt:
referenced by:
stmt
DropRoleStmt:
referenced by:
stmt
CreateGroupStmt:
referenced by:
stmt
AlterGroupStmt:
referenced by:
stmt
add_drop:
referenced by:
AlterExtensionContentsStmt
AlterGroupStmt
CreateSchemaStmt:
referenced by:
stmt
OptSchemaName:
referenced by:
CreateSchemaStmt
OptSchemaEltList:
referenced by:
CreateSchemaStmt
schema_stmt:
referenced by:
OptSchemaEltList
VariableSetStmt:
referenced by:
stmt
set_rest:
referenced by:
SetResetClause
VariableSetStmt
generic_set:
referenced by:
AlterSystemStmt
set_rest_more
set_rest_more:
referenced by:
FunctionSetResetClause
set_rest
var_name:
referenced by:
VariableShowStmt
generic_reset
generic_set
set_rest_more
var_list:
referenced by:
generic_set
var_value:
referenced by:
var_list
iso_level:
referenced by:
transaction_mode_item
opt_boolean_or_string:
referenced by:
copy_generic_opt_arg
copy_generic_opt_arg_list_item
createdb_opt_item
explain_option_arg
var_value
zone_value:
referenced by:
set_rest_more
opt_encoding:
referenced by:
set_rest_more
NonReservedWord_or_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:
referenced by:
FunctionSetResetClause
SetResetClause
stmt
reset_rest:
referenced by:
VariableResetStmt
generic_reset:
referenced by:
AlterSystemStmt
reset_rest
SetResetClause:
referenced by:
AlterDatabaseSetStmt
AlterRoleSetStmt
FunctionSetResetClause:
referenced by:
common_func_opt_item
VariableShowStmt:
referenced by:
stmt
ConstraintsSetStmt:
referenced by:
stmt
constraints_set_list:
referenced by:
ConstraintsSetStmt
constraints_set_mode:
referenced by:
ConstraintsSetStmt
CheckPointStmt:
referenced by:
stmt
DiscardStmt:
referenced by:
stmt
AlterTableStmt:
referenced by:
stmt
alter_table_cmds:
referenced by:
AlterForeignTableStmt
AlterTableStmt
partition_cmd:
referenced by:
AlterTableStmt
alter_table_cmd:
referenced by:
alter_table_cmds
alter_column_default:
referenced by:
AlterDomainStmt
alter_table_cmd
opt_drop_behavior:
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:
referenced by:
TableFuncElement
alter_table_cmd
alter_type_cmd
alter_using:
referenced by:
alter_table_cmd
replica_identity:
referenced by:
alter_table_cmd
reloptions:
referenced by:
AlterTblSpcStmt
OptWith
alter_table_cmd
opt_reloptions
opt_reloptions:
referenced by:
CreateTableSpaceStmt
IndexStmt
ViewStmt
create_mv_target
reloption_elem:
referenced by:
reloptions
alter_identity_column_option:
referenced by:
alter_table_cmd
ForValues:
referenced by:
CreateForeignTableStmt
CreateStmt
partition_cmd
partbound_datum:
referenced by:
ForValues
PartitionRangeDatum
range_datum_list:
referenced by:
ForValues
PartitionRangeDatum:
referenced by:
range_datum_list
AlterCompositeTypeStmt:
referenced by:
stmt
alter_type_cmd:
referenced by:
AlterCompositeTypeStmt
ClosePortalStmt:
referenced by:
stmt
CopyStmt:
referenced by:
stmt
copy_from:
referenced by:
CopyStmt
opt_program:
referenced by:
CopyStmt
copy_file_name:
referenced by:
CopyStmt
copy_options:
referenced by:
CopyStmt
copy_opt_item:
referenced by:
copy_options
opt_binary:
referenced by:
CopyStmt
opt_oids:
referenced by:
CopyStmt
copy_delimiter:
referenced by:
CopyStmt
opt_using:
referenced by:
copy_delimiter
copy_generic_opt_elem:
referenced by:
copy_options
copy_generic_opt_arg:
referenced by:
copy_generic_opt_elem
copy_generic_opt_arg_list_item:
referenced by:
copy_generic_opt_arg
CreateStmt:
referenced by:
schema_stmt
stmt
OptTemp:
referenced by:
CreateAsStmt
CreateSeqStmt
CreateStmt
ExecuteStmt
ViewStmt
OptTableElementList:
referenced by:
CreateForeignTableStmt
CreateStmt
OptTypedTableElementList:
referenced by:
CreateForeignTableStmt
CreateStmt
TableElement:
referenced by:
OptTableElementList
TypedTableElement:
referenced by:
OptTypedTableElementList
columnDef:
referenced by:
TableElement
alter_table_cmd
columnOptions:
referenced by:
TypedTableElement
ColQualList:
referenced by:
CreateDomainStmt
columnDef
columnOptions
ColConstraint:
referenced by:
ColQualList
ColConstraintElem:
referenced by:
ColConstraint
generated_when:
referenced by:
ColConstraintElem
alter_identity_column_option
alter_table_cmd
ConstraintAttr:
referenced by:
ColConstraint
TableLikeClause:
referenced by:
TableElement
TableLikeOption:
referenced by:
TableLikeClause
TableConstraint:
referenced by:
AlterDomainStmt
TableElement
TypedTableElement
alter_table_cmd
ConstraintElem:
referenced by:
TableConstraint
opt_no_inherit:
referenced by:
ColConstraintElem
opt_column_list:
referenced by:
ColConstraintElem
ConstraintElem
CopyStmt
ViewStmt
create_as_target
create_mv_target
privilege
columnList:
referenced by:
ConstraintElem
TriggerOneEvent
ViewStmt
copy_opt_item
opt_column_list
privileges
columnElem:
referenced by:
columnList
key_match:
referenced by:
ColConstraintElem
ConstraintElem
ExclusionConstraintElem:
referenced by:
ConstraintElem
ExclusionWhereClause:
referenced by:
ConstraintElem
key_actions:
referenced by:
ColConstraintElem
ConstraintElem
key_update:
referenced by:
key_actions
key_delete:
referenced by:
key_actions
key_action:
referenced by:
key_delete
key_update
OptInherit:
referenced by:
CreateForeignTableStmt
CreateStmt
OptPartitionSpec:
referenced by:
CreateStmt
PartitionSpec:
referenced by:
OptPartitionSpec
part_strategy:
referenced by:
PartitionSpec
part_elem:
referenced by:
PartitionSpec
OptWith:
referenced by:
CreateStmt
create_as_target
OnCommitOption:
referenced by:
CreateStmt
create_as_target
OptTableSpace:
referenced by:
CreateStmt
IndexStmt
create_as_target
create_mv_target
OptConsTableSpace:
referenced by:
ColConstraintElem
ConstraintElem
ExistingIndex:
referenced by:
ConstraintElem
CreateStatsStmt:
referenced by:
stmt
CreateAsStmt:
referenced by:
ExplainableStmt
stmt
create_as_target:
referenced by:
CreateAsStmt
ExecuteStmt
opt_with_data:
referenced by:
CreateAsStmt
CreateMatViewStmt
ExecuteStmt
RefreshMatViewStmt
CreateMatViewStmt:
referenced by:
ExplainableStmt
stmt
create_mv_target:
referenced by:
CreateMatViewStmt
OptNoLog:
referenced by:
CreateMatViewStmt
RefreshMatViewStmt:
referenced by:
ExplainableStmt
stmt
CreateSeqStmt:
referenced by:
schema_stmt
stmt
AlterSeqStmt:
referenced by:
stmt
OptSeqOptList:
referenced by:
CreateSeqStmt
OptParenthesizedSeqOptList:
referenced by:
ColConstraintElem
alter_table_cmd
SeqOptList:
referenced by:
AlterSeqStmt
OptParenthesizedSeqOptList
OptSeqOptList
SeqOptElem:
referenced by:
SeqOptList
alter_identity_column_option
opt_by:
referenced by:
SeqOptElem
NumericOnly:
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:
referenced by:
stmt
opt_trusted:
referenced by:
CreatePLangStmt
handler_name:
referenced by:
CreateAmStmt
CreatePLangStmt
fdw_option
opt_inline_handler
validator_clause
opt_inline_handler:
referenced by:
CreatePLangStmt
validator_clause:
referenced by:
opt_validator
opt_validator:
referenced by:
CreatePLangStmt
DropPLangStmt:
referenced by:
stmt
opt_procedural:
referenced by:
AlterExtensionContentsStmt
AlterOwnerStmt
CreatePLangStmt
DropPLangStmt
RenameStmt
comment_type_name
security_label_type_name
CreateTableSpaceStmt:
referenced by:
stmt
OptTableSpaceOwner:
referenced by:
CreateTableSpaceStmt
DropTableSpaceStmt:
referenced by:
stmt
CreateExtensionStmt:
referenced by:
stmt
create_extension_opt_list:
referenced by:
CreateExtensionStmt
create_extension_opt_item:
referenced by:
create_extension_opt_list
AlterExtensionStmt:
referenced by:
stmt
alter_extension_opt_item:
referenced by:
AlterExtensionStmt
AlterExtensionContentsStmt:
referenced by:
stmt
CreateFdwStmt:
referenced by:
stmt
fdw_option:
referenced by:
fdw_options
fdw_options:
referenced by:
AlterFdwStmt
opt_fdw_options
opt_fdw_options:
referenced by:
AlterFdwStmt
CreateFdwStmt
AlterFdwStmt:
referenced by:
stmt
create_generic_options:
referenced by:
CreateFdwStmt
CreateForeignServerStmt
CreateForeignTableStmt
CreateUserMappingStmt
ImportForeignSchemaStmt
columnDef
alter_generic_options:
referenced by:
AlterFdwStmt
AlterForeignServerStmt
AlterUserMappingStmt
alter_table_cmd
alter_generic_option_elem:
referenced by:
alter_generic_options
generic_option_elem:
referenced by:
alter_generic_option_elem
create_generic_options
generic_option_name:
referenced by:
alter_generic_option_elem
generic_option_elem
generic_option_arg:
referenced by:
generic_option_elem
CreateForeignServerStmt:
referenced by:
stmt
opt_type:
referenced by:
CreateForeignServerStmt
foreign_server_version:
referenced by:
AlterForeignServerStmt
opt_foreign_server_version
opt_foreign_server_version:
referenced by:
CreateForeignServerStmt
AlterForeignServerStmt:
referenced by:
stmt
CreateForeignTableStmt:
referenced by:
stmt
AlterForeignTableStmt:
referenced by:
stmt
ImportForeignSchemaStmt:
referenced by:
stmt
import_qualification_type:
referenced by:
import_qualification
import_qualification:
referenced by:
ImportForeignSchemaStmt
CreateUserMappingStmt:
referenced by:
stmt
auth_ident:
referenced by:
AlterUserMappingStmt
CreateUserMappingStmt
DropUserMappingStmt
DropUserMappingStmt:
referenced by:
stmt
AlterUserMappingStmt:
referenced by:
stmt
CreatePolicyStmt:
referenced by:
stmt
AlterPolicyStmt:
referenced by:
stmt
RowSecurityOptionalExpr:
referenced by:
AlterPolicyStmt
CreatePolicyStmt
RowSecurityOptionalWithCheck:
referenced by:
AlterPolicyStmt
CreatePolicyStmt
RowSecurityDefaultToRole:
referenced by:
CreatePolicyStmt
RowSecurityOptionalToRole:
referenced by:
AlterPolicyStmt
RowSecurityDefaultPermissive:
referenced by:
CreatePolicyStmt
RowSecurityDefaultForCmd:
referenced by:
CreatePolicyStmt
row_security_cmd:
referenced by:
RowSecurityDefaultForCmd
CreateAmStmt:
referenced by:
stmt
CreateTrigStmt:
referenced by:
schema_stmt
stmt
TriggerActionTime:
referenced by:
CreateTrigStmt
TriggerEvents:
referenced by:
CreateTrigStmt
TriggerOneEvent:
referenced by:
TriggerEvents
TriggerReferencing:
referenced by:
CreateTrigStmt
TriggerTransition:
referenced by:
TriggerReferencing
TransitionOldOrNew:
referenced by:
TriggerTransition
TransitionRowOrTable:
referenced by:
TriggerTransition
TransitionRelName:
referenced by:
TriggerTransition
TriggerForSpec:
referenced by:
CreateTrigStmt
TriggerForOptEach:
referenced by:
TriggerForSpec
TriggerForType:
referenced by:
TriggerForSpec
TriggerWhen:
referenced by:
CreateTrigStmt
TriggerFuncArgs:
referenced by:
CreateTrigStmt
TriggerFuncArg:
referenced by:
TriggerFuncArgs
OptConstrFromTable:
referenced by:
CreateTrigStmt
ConstraintAttributeSpec:
referenced by:
ConstraintElem
CreateAssertStmt
CreateTrigStmt
alter_table_cmd
ConstraintAttributeElem:
referenced by:
ConstraintAttributeSpec
CreateEventTrigStmt:
referenced by:
stmt
event_trigger_when_item:
referenced by:
CreateEventTrigStmt
AlterEventTrigStmt:
referenced by:
stmt
enable_trigger:
referenced by:
AlterEventTrigStmt
CreateAssertStmt:
referenced by:
stmt
DropAssertStmt:
referenced by:
stmt
DefineStmt:
referenced by:
stmt
definition: