pglast.ast — Python classes representing PG parser nodes

The module implements a set of data classes, one for each C structure defined in several PostgreSQL headers, primarily those in the include/nodes/ directory.

The pglast.ast.Node is an abstract class that implements the common behaviour of all the concrete classes. In particular any node can be compared with another instance, is able to serialize itself and can be altered.

class pglast.ast.Node(data)

Base class for all AST nodes.

__call__(depth=None, ellipsis=…, skip_none=False)

Serialize the node as a structure made of simple Python data-types.

Parameters:
  • depth (None or int) – if not None, the maximum depth to reach
  • ellipsis – the marker value that will be used to replace cut-off branch
  • skip_none (bool) – whether None-valued attributes should be elided
  • enum_name (bool) – whether Enums will be rendered as their name only
Returns:

a dict instance

This performs a top-down recursive visit to the whole AST tree: each Node instance becomes a dictionary with a special @ key carrying the node type, lists becomes tuples and Enum instances become dictionaries with a special # key carrying the enum name.

__eq__(other)

Compare two nodes, returning True if they are considered equivalent.

This is mainly an helper method used by tests: for this reason, two nodes are considered equal when all their attributes match, ignoring positional ones such as location, stmt_len and stmt_location.

__repr__()

Build a representation of the whole node and its subtree, for debug.

__setattr__(name, value)

Validate the given value and if acceptable assign it to the name attribute.

This tries to coerce the given value accordingly with the ctype of the attribute, raising opportune exception when that is not possible.

class pglast.ast.A_ArrayExpr(elements=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.A_Const(isnull=None, val=None)

Wrapper for the homonymous parser node.

class pglast.ast.A_Expr(kind=None, name=None, lexpr=None, rexpr=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.A_Indices(is_slice=None, lidx=None, uidx=None)

Wrapper for the homonymous parser node.

class pglast.ast.A_Indirection(arg=None, indirection=None)

Wrapper for the homonymous parser node.

class pglast.ast.A_Star

Wrapper for the homonymous parser node.

class pglast.ast.AccessPriv(priv_name=None, cols=None)

Wrapper for the homonymous parser node.

class pglast.ast.Aggref(aggargtypes=None, aggdirectargs=None, args=None, aggorder=None, aggdistinct=None, aggfilter=None, aggstar=None, aggvariadic=None, aggkind=None, agglevelsup=None, aggsplit=None, aggno=None, aggtransno=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.Alias(aliasname=None, colnames=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterCollationStmt(collname=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterDatabaseRefreshCollStmt(dbname=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterDatabaseSetStmt(dbname=None, setstmt=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterDatabaseStmt(dbname=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterDefaultPrivilegesStmt(options=None, action=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterDomainStmt(subtype=None, typeName=None, name=None, def_=None, behavior=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterEnumStmt(typeName=None, oldVal=None, newVal=None, newValNeighbor=None, newValIsAfter=None, skipIfNewValExists=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterEventTrigStmt(trigname=None, tgenabled=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterExtensionContentsStmt(extname=None, action=None, objtype=None, object=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterExtensionStmt(extname=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterFdwStmt(fdwname=None, func_options=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterForeignServerStmt(servername=None, version=None, options=None, has_version=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterFunctionStmt(objtype=None, func=None, actions=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterObjectDependsStmt(objectType=None, relation=None, object=None, extname=None, remove=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterObjectSchemaStmt(objectType=None, relation=None, object=None, newschema=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterOpFamilyStmt(opfamilyname=None, amname=None, isDrop=None, items=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterOperatorStmt(opername=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterOwnerStmt(objectType=None, relation=None, object=None, newowner=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterPolicyStmt(policy_name=None, table=None, roles=None, qual=None, with_check=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterPublicationStmt(pubname=None, options=None, pubobjects=None, for_all_tables=None, action=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterRoleSetStmt(role=None, database=None, setstmt=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterRoleStmt(role=None, options=None, action=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterSeqStmt(sequence=None, options=None, for_identity=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterStatsStmt(defnames=None, stxstattarget=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterSubscriptionStmt(kind=None, subname=None, conninfo=None, publication=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterSystemStmt(setstmt=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTSConfigurationStmt(kind=None, cfgname=None, tokentype=None, dicts=None, override=None, replace=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTSDictionaryStmt(dictname=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTableCmd(subtype=None, name=None, num=None, newowner=None, def_=None, behavior=None, missing_ok=None, recurse=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTableMoveAllStmt(orig_tablespacename=None, objtype=None, roles=None, new_tablespacename=None, nowait=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTableSpaceOptionsStmt(tablespacename=None, options=None, isReset=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTableStmt(relation=None, cmds=None, objtype=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterTypeStmt(typeName=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlterUserMappingStmt(user=None, servername=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.AlternativeSubPlan(subplans=None)

Wrapper for the homonymous parser node.

class pglast.ast.ArrayCoerceExpr(arg=None, elemexpr=None, resulttypmod=None, coerceformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ArrayExpr(elements=None, multidims=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.BitString(bsval=None)

Wrapper for the homonymous parser node.

class pglast.ast.BoolExpr(boolop=None, args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.Boolean(boolval=None)

Wrapper for the homonymous parser node.

class pglast.ast.BooleanTest(arg=None, booltesttype=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CTECycleClause(cycle_col_list=None, cycle_mark_column=None, cycle_mark_value=None, cycle_mark_default=None, cycle_path_column=None, location=None, cycle_mark_typmod=None)

Wrapper for the homonymous parser node.

class pglast.ast.CTESearchClause(search_col_list=None, search_breadth_first=None, search_seq_column=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CallContext(atomic=None)

Wrapper for the homonymous parser node.

class pglast.ast.CallStmt(funccall=None, funcexpr=None, outargs=None)

Wrapper for the homonymous parser node.

class pglast.ast.CaseExpr(arg=None, args=None, defresult=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CaseTestExpr(typeMod=None)

Wrapper for the homonymous parser node.

class pglast.ast.CaseWhen(expr=None, result=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CheckPointStmt

Wrapper for the homonymous parser node.

class pglast.ast.ClosePortalStmt(portalname=None)

Wrapper for the homonymous parser node.

class pglast.ast.ClusterStmt(relation=None, indexname=None, params=None)

Wrapper for the homonymous parser node.

class pglast.ast.CoalesceExpr(args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CoerceToDomain(arg=None, resulttypmod=None, coercionformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CoerceToDomainValue(typeMod=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CoerceViaIO(arg=None, coerceformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CollateClause(arg=None, collname=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CollateExpr(arg=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ColumnDef(colname=None, typeName=None, compression=None, inhcount=None, is_local=None, is_not_null=None, is_from_type=None, storage=None, raw_default=None, cooked_default=None, identity=None, identitySequence=None, generated=None, collClause=None, constraints=None, fdwoptions=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ColumnRef(fields=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CommentStmt(objtype=None, object=None, comment=None)

Wrapper for the homonymous parser node.

class pglast.ast.CommonTableExpr(ctename=None, aliascolnames=None, ctematerialized=None, ctequery=None, search_clause=None, cycle_clause=None, location=None, cterecursive=None, cterefcount=None, ctecolnames=None, ctecoltypes=None, ctecoltypmods=None, ctecolcollations=None)

Wrapper for the homonymous parser node.

class pglast.ast.CompositeTypeStmt(typevar=None, coldeflist=None)

Wrapper for the homonymous parser node.

class pglast.ast.Constraint(contype=None, conname=None, deferrable=None, initdeferred=None, location=None, is_no_inherit=None, raw_expr=None, cooked_expr=None, generated_when=None, nulls_not_distinct=None, keys=None, including=None, exclusions=None, options=None, indexname=None, indexspace=None, reset_default_tblspc=None, access_method=None, where_clause=None, pktable=None, fk_attrs=None, pk_attrs=None, fk_matchtype=None, fk_upd_action=None, fk_del_action=None, fk_del_set_cols=None, old_conpfeqop=None, skip_validation=None, initially_valid=None)

Wrapper for the homonymous parser node.

class pglast.ast.ConstraintsSetStmt(constraints=None, deferred=None)

Wrapper for the homonymous parser node.

class pglast.ast.ConvertRowtypeExpr(arg=None, convertformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.CopyStmt(relation=None, query=None, attlist=None, is_from=None, is_program=None, filename=None, options=None, whereClause=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateAmStmt(amname=None, handler_name=None, amtype=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateCastStmt(sourcetype=None, targettype=None, func=None, context=None, inout=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateConversionStmt(conversion_name=None, for_encoding_name=None, to_encoding_name=None, func_name=None, def_=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateDomainStmt(domainname=None, typeName=None, collClause=None, constraints=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateEnumStmt(typeName=None, vals=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateEventTrigStmt(trigname=None, eventname=None, whenclause=None, funcname=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateExtensionStmt(extname=None, if_not_exists=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateFdwStmt(fdwname=None, func_options=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateForeignServerStmt(servername=None, servertype=None, version=None, fdwname=None, if_not_exists=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateForeignTableStmt(base=None, servername=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateFunctionStmt(is_procedure=None, replace=None, funcname=None, parameters=None, returnType=None, options=None, sql_body=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateOpClassItem(itemtype=None, name=None, number=None, order_family=None, class_args=None, storedtype=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateOpClassStmt(opclassname=None, opfamilyname=None, amname=None, datatype=None, items=None, isDefault=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateOpFamilyStmt(opfamilyname=None, amname=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreatePLangStmt(replace=None, plname=None, plhandler=None, plinline=None, plvalidator=None, pltrusted=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreatePolicyStmt(policy_name=None, table=None, cmd_name=None, permissive=None, roles=None, qual=None, with_check=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreatePublicationStmt(pubname=None, options=None, pubobjects=None, for_all_tables=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateRangeStmt(typeName=None, params=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateRoleStmt(stmt_type=None, role=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateSchemaStmt(schemaname=None, authrole=None, schemaElts=None, if_not_exists=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateSeqStmt(sequence=None, options=None, for_identity=None, if_not_exists=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateStatsStmt(defnames=None, stat_types=None, exprs=None, relations=None, stxcomment=None, transformed=None, if_not_exists=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateStmt(relation=None, tableElts=None, inhRelations=None, partbound=None, partspec=None, ofTypename=None, constraints=None, options=None, oncommit=None, tablespacename=None, accessMethod=None, if_not_exists=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateSubscriptionStmt(subname=None, conninfo=None, publication=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateTableAsStmt(query=None, into=None, objtype=None, is_select_into=None, if_not_exists=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateTableSpaceStmt(tablespacename=None, owner=None, location=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateTransformStmt(replace=None, type_name=None, lang=None, fromsql=None, tosql=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateTrigStmt(replace=None, isconstraint=None, trigname=None, relation=None, funcname=None, args=None, row=None, timing=None, events=None, columns=None, whenClause=None, transitionRels=None, deferrable=None, initdeferred=None, constrrel=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreateUserMappingStmt(user=None, servername=None, if_not_exists=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CreatedbStmt(dbname=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.CurrentOfExpr(cvarno=None, cursor_name=None, cursor_param=None)

Wrapper for the homonymous parser node.

class pglast.ast.DeallocateStmt(name=None)

Wrapper for the homonymous parser node.

class pglast.ast.DeclareCursorStmt(portalname=None, options=None, query=None)

Wrapper for the homonymous parser node.

class pglast.ast.DefElem(defnamespace=None, defname=None, arg=None, defaction=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.DefineStmt(kind=None, oldstyle=None, defnames=None, args=None, definition=None, if_not_exists=None, replace=None)

Wrapper for the homonymous parser node.

class pglast.ast.DeleteStmt(relation=None, usingClause=None, whereClause=None, returningList=None, withClause=None)

Wrapper for the homonymous parser node.

class pglast.ast.DiscardStmt(target=None)

Wrapper for the homonymous parser node.

class pglast.ast.DoStmt(args=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropOwnedStmt(roles=None, behavior=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropRoleStmt(roles=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropStmt(objects=None, removeType=None, behavior=None, missing_ok=None, concurrent=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropSubscriptionStmt(subname=None, missing_ok=None, behavior=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropTableSpaceStmt(tablespacename=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropUserMappingStmt(user=None, servername=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.DropdbStmt(dbname=None, missing_ok=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.ExecuteStmt(name=None, params=None)

Wrapper for the homonymous parser node.

class pglast.ast.ExplainStmt(query=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.FetchStmt(direction=None, howMany=None, portalname=None, ismove=None)

Wrapper for the homonymous parser node.

class pglast.ast.FieldSelect(arg=None, fieldnum=None, resulttypmod=None)

Wrapper for the homonymous parser node.

class pglast.ast.FieldStore(arg=None, newvals=None, fieldnums=None)

Wrapper for the homonymous parser node.

class pglast.ast.Float(fval=None)

Wrapper for the homonymous parser node.

class pglast.ast.FromExpr(fromlist=None, quals=None)

Wrapper for the homonymous parser node.

class pglast.ast.FuncCall(funcname=None, args=None, agg_order=None, agg_filter=None, over=None, agg_within_group=None, agg_star=None, agg_distinct=None, func_variadic=None, funcformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.FuncExpr(funcretset=None, funcvariadic=None, funcformat=None, args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.FunctionParameter(name=None, argType=None, mode=None, defexpr=None)

Wrapper for the homonymous parser node.

class pglast.ast.GrantRoleStmt(granted_roles=None, grantee_roles=None, is_grant=None, admin_opt=None, grantor=None, behavior=None)

Wrapper for the homonymous parser node.

class pglast.ast.GrantStmt(is_grant=None, targtype=None, objtype=None, objects=None, privileges=None, grantees=None, grant_option=None, grantor=None, behavior=None)

Wrapper for the homonymous parser node.

class pglast.ast.GroupingFunc(args=None, refs=None, cols=None, agglevelsup=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.GroupingSet(kind=None, content=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ImportForeignSchemaStmt(server_name=None, remote_schema=None, local_schema=None, list_type=None, table_list=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.IndexElem(name=None, expr=None, indexcolname=None, collation=None, opclass=None, opclassopts=None, ordering=None, nulls_ordering=None)

Wrapper for the homonymous parser node.

class pglast.ast.IndexStmt(idxname=None, relation=None, accessMethod=None, tableSpace=None, indexParams=None, indexIncludingParams=None, options=None, whereClause=None, excludeOpNames=None, idxcomment=None, oldCreateSubid=None, oldFirstRelfilenodeSubid=None, unique=None, nulls_not_distinct=None, primary=None, isconstraint=None, deferrable=None, initdeferred=None, transformed=None, concurrent=None, if_not_exists=None, reset_default_tblspc=None)

Wrapper for the homonymous parser node.

class pglast.ast.InferClause(indexElems=None, whereClause=None, conname=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.InferenceElem(expr=None)

Wrapper for the homonymous parser node.

class pglast.ast.InlineCodeBlock(source_text=None, langIsTrusted=None, atomic=None)

Wrapper for the homonymous parser node.

class pglast.ast.InsertStmt(relation=None, cols=None, selectStmt=None, onConflictClause=None, returningList=None, withClause=None, override=None)

Wrapper for the homonymous parser node.

class pglast.ast.Integer(ival=None)

Wrapper for the homonymous parser node.

class pglast.ast.IntoClause(rel=None, colNames=None, accessMethod=None, options=None, onCommit=None, tableSpaceName=None, viewQuery=None, skipData=None)

Wrapper for the homonymous parser node.

class pglast.ast.JoinExpr(jointype=None, isNatural=None, larg=None, rarg=None, usingClause=None, join_using_alias=None, quals=None, alias=None, rtindex=None)

Wrapper for the homonymous parser node.

class pglast.ast.ListenStmt(conditionname=None)

Wrapper for the homonymous parser node.

class pglast.ast.LoadStmt(filename=None)

Wrapper for the homonymous parser node.

class pglast.ast.LockStmt(relations=None, mode=None, nowait=None)

Wrapper for the homonymous parser node.

class pglast.ast.LockingClause(lockedRels=None, strength=None, waitPolicy=None)

Wrapper for the homonymous parser node.

class pglast.ast.MergeAction(matched=None, commandType=None, override=None, qual=None, targetList=None, updateColnos=None)

Wrapper for the homonymous parser node.

class pglast.ast.MergeStmt(relation=None, sourceRelation=None, joinCondition=None, mergeWhenClauses=None, withClause=None)

Wrapper for the homonymous parser node.

class pglast.ast.MergeWhenClause(matched=None, commandType=None, override=None, condition=None, targetList=None, values=None)

Wrapper for the homonymous parser node.

class pglast.ast.MinMaxExpr(op=None, args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.MultiAssignRef(source=None, colno=None, ncolumns=None)

Wrapper for the homonymous parser node.

class pglast.ast.NamedArgExpr(arg=None, name=None, argnumber=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.NotifyStmt(conditionname=None, payload=None)

Wrapper for the homonymous parser node.

class pglast.ast.NullTest(arg=None, nulltesttype=None, argisrow=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ObjectWithArgs(objname=None, objargs=None, objfuncargs=None, args_unspecified=None)

Wrapper for the homonymous parser node.

class pglast.ast.OnConflictClause(action=None, infer=None, targetList=None, whereClause=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.OnConflictExpr(action=None, arbiterElems=None, arbiterWhere=None, onConflictSet=None, onConflictWhere=None, exclRelIndex=None, exclRelTlist=None)

Wrapper for the homonymous parser node.

class pglast.ast.OpExpr(opretset=None, args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PLAssignStmt(name=None, indirection=None, nnames=None, val=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.Param(paramkind=None, paramid=None, paramtypmod=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ParamRef(number=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PartitionBoundSpec(strategy=None, is_default=None, modulus=None, remainder=None, listdatums=None, lowerdatums=None, upperdatums=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PartitionCmd(name=None, bound=None, concurrent=None)

Wrapper for the homonymous parser node.

class pglast.ast.PartitionElem(name=None, expr=None, collation=None, opclass=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PartitionRangeDatum(kind=None, value=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PartitionSpec(strategy=None, partParams=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PrepareStmt(name=None, argtypes=None, query=None)

Wrapper for the homonymous parser node.

class pglast.ast.PublicationObjSpec(pubobjtype=None, name=None, pubtable=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.PublicationTable(relation=None, whereClause=None, columns=None)

Wrapper for the homonymous parser node.

class pglast.ast.Query(commandType=None, querySource=None, queryId=None, canSetTag=None, utilityStmt=None, resultRelation=None, hasAggs=None, hasWindowFuncs=None, hasTargetSRFs=None, hasSubLinks=None, hasDistinctOn=None, hasRecursive=None, hasModifyingCTE=None, hasForUpdate=None, hasRowSecurity=None, isReturn=None, cteList=None, rtable=None, jointree=None, mergeActionList=None, mergeUseOuterJoin=None, targetList=None, override=None, onConflict=None, returningList=None, groupClause=None, groupDistinct=None, groupingSets=None, havingQual=None, windowClause=None, distinctClause=None, sortClause=None, limitOffset=None, limitCount=None, limitOption=None, rowMarks=None, setOperations=None, constraintDeps=None, withCheckOptions=None, stmt_location=None, stmt_len=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeFunction(lateral=None, ordinality=None, is_rowsfrom=None, functions=None, alias=None, coldeflist=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeSubselect(lateral=None, subquery=None, alias=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTableFunc(lateral=None, docexpr=None, rowexpr=None, namespaces=None, columns=None, alias=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTableFuncCol(colname=None, typeName=None, for_ordinality=None, is_not_null=None, colexpr=None, coldefexpr=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTableSample(relation=None, method=None, args=None, repeatable=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTblEntry(rtekind=None, relkind=None, rellockmode=None, tablesample=None, subquery=None, security_barrier=None, jointype=None, joinmergedcols=None, joinaliasvars=None, joinleftcols=None, joinrightcols=None, join_using_alias=None, functions=None, funcordinality=None, tablefunc=None, values_lists=None, ctename=None, ctelevelsup=None, self_reference=None, coltypes=None, coltypmods=None, colcollations=None, enrname=None, enrtuples=None, alias=None, eref=None, lateral=None, inh=None, inFromCl=None, requiredPerms=None, selectedCols=None, insertedCols=None, updatedCols=None, extraUpdatedCols=None, securityQuals=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTblFunction(funcexpr=None, funccolcount=None, funccolnames=None, funccoltypes=None, funccoltypmods=None, funccolcollations=None, funcparams=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeTblRef(rtindex=None)

Wrapper for the homonymous parser node.

class pglast.ast.RangeVar(catalogname=None, schemaname=None, relname=None, inh=None, relpersistence=None, alias=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RawStmt(stmt=None, stmt_location=None, stmt_len=None)

Wrapper for the homonymous parser node.

class pglast.ast.ReassignOwnedStmt(roles=None, newrole=None)

Wrapper for the homonymous parser node.

class pglast.ast.RefreshMatViewStmt(concurrent=None, skipData=None, relation=None)

Wrapper for the homonymous parser node.

class pglast.ast.ReindexStmt(kind=None, relation=None, name=None, params=None)

Wrapper for the homonymous parser node.

class pglast.ast.RelabelType(arg=None, resulttypmod=None, relabelformat=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RenameStmt(renameType=None, relationType=None, relation=None, object=None, subname=None, newname=None, behavior=None, missing_ok=None)

Wrapper for the homonymous parser node.

class pglast.ast.ReplicaIdentityStmt(identity_type=None, name=None)

Wrapper for the homonymous parser node.

class pglast.ast.ResTarget(name=None, indirection=None, val=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ReturnStmt(returnval=None)

Wrapper for the homonymous parser node.

class pglast.ast.RoleSpec(roletype=None, rolename=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RowCompareExpr(rctype=None, opnos=None, opfamilies=None, inputcollids=None, largs=None, rargs=None)

Wrapper for the homonymous parser node.

class pglast.ast.RowExpr(args=None, row_format=None, colnames=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.RowMarkClause(rti=None, strength=None, waitPolicy=None, pushedDown=None)

Wrapper for the homonymous parser node.

class pglast.ast.RuleStmt(relation=None, rulename=None, whereClause=None, event=None, instead=None, actions=None, replace=None)

Wrapper for the homonymous parser node.

class pglast.ast.SQLValueFunction(op=None, typmod=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.ScalarArrayOpExpr(useOr=None, args=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.SecLabelStmt(objtype=None, object=None, provider=None, label=None)

Wrapper for the homonymous parser node.

class pglast.ast.SelectStmt(distinctClause=None, intoClause=None, targetList=None, fromClause=None, whereClause=None, groupClause=None, groupDistinct=None, havingClause=None, windowClause=None, valuesLists=None, sortClause=None, limitOffset=None, limitCount=None, limitOption=None, lockingClause=None, withClause=None, op=None, all=None, larg=None, rarg=None)

Wrapper for the homonymous parser node.

class pglast.ast.SetOperationStmt(op=None, all=None, larg=None, rarg=None, colTypes=None, colTypmods=None, colCollations=None, groupClauses=None)

Wrapper for the homonymous parser node.

class pglast.ast.SetToDefault(typeMod=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.SortBy(node=None, sortby_dir=None, sortby_nulls=None, useOp=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.SortGroupClause(tleSortGroupRef=None, nulls_first=None, hashable=None)

Wrapper for the homonymous parser node.

class pglast.ast.StatsElem(name=None, expr=None)

Wrapper for the homonymous parser node.

class pglast.ast.String(sval=None)

Wrapper for the homonymous parser node.

Wrapper for the homonymous parser node.

class pglast.ast.SubPlan(subLinkType=None, testexpr=None, paramIds=None, plan_id=None, plan_name=None, firstColTypmod=None, useHashTable=None, unknownEqFalse=None, parallel_safe=None, setParam=None, parParam=None, args=None, startup_cost=None, per_call_cost=None)

Wrapper for the homonymous parser node.

class pglast.ast.SubscriptingRef(reftypmod=None, refupperindexpr=None, reflowerindexpr=None, refexpr=None, refassgnexpr=None)

Wrapper for the homonymous parser node.

class pglast.ast.TableFunc(ns_uris=None, ns_names=None, docexpr=None, rowexpr=None, colnames=None, coltypes=None, coltypmods=None, colcollations=None, colexprs=None, coldefexprs=None, notnulls=None, ordinalitycol=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.TableLikeClause(relation=None, options=None)

Wrapper for the homonymous parser node.

class pglast.ast.TableSampleClause(args=None, repeatable=None)

Wrapper for the homonymous parser node.

class pglast.ast.TargetEntry(expr=None, resno=None, resname=None, ressortgroupref=None, resorigcol=None, resjunk=None)

Wrapper for the homonymous parser node.

class pglast.ast.TransactionStmt(kind=None, options=None, savepoint_name=None, gid=None, chain=None)

Wrapper for the homonymous parser node.

class pglast.ast.TriggerTransition(name=None, isNew=None, isTable=None)

Wrapper for the homonymous parser node.

class pglast.ast.TruncateStmt(relations=None, restart_seqs=None, behavior=None)

Wrapper for the homonymous parser node.

class pglast.ast.TypeCast(arg=None, typeName=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.TypeName(names=None, setof=None, pct_type=None, typmods=None, typemod=None, arrayBounds=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.UnlistenStmt(conditionname=None)

Wrapper for the homonymous parser node.

class pglast.ast.UpdateStmt(relation=None, targetList=None, whereClause=None, fromClause=None, returningList=None, withClause=None)

Wrapper for the homonymous parser node.

class pglast.ast.VacuumRelation(relation=None, va_cols=None)

Wrapper for the homonymous parser node.

class pglast.ast.VacuumStmt(options=None, rels=None, is_vacuumcmd=None)

Wrapper for the homonymous parser node.

class pglast.ast.Var(varno=None, varattno=None, vartypmod=None, varlevelsup=None, varnosyn=None, varattnosyn=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.VariableSetStmt(kind=None, name=None, args=None, is_local=None)

Wrapper for the homonymous parser node.

class pglast.ast.VariableShowStmt(name=None)

Wrapper for the homonymous parser node.

class pglast.ast.ViewStmt(view=None, aliases=None, query=None, replace=None, options=None, withCheckOption=None)

Wrapper for the homonymous parser node.

class pglast.ast.WindowClause(name=None, refname=None, partitionClause=None, orderClause=None, frameOptions=None, startOffset=None, endOffset=None, runCondition=None, inRangeAsc=None, inRangeNullsFirst=None, winref=None, copiedOrder=None)

Wrapper for the homonymous parser node.

class pglast.ast.WindowDef(name=None, refname=None, partitionClause=None, orderClause=None, frameOptions=None, startOffset=None, endOffset=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.WindowFunc(args=None, aggfilter=None, winref=None, winstar=None, winagg=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.WithCheckOption(kind=None, relname=None, polname=None, qual=None, cascaded=None)

Wrapper for the homonymous parser node.

class pglast.ast.WithClause(ctes=None, recursive=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.XmlExpr(op=None, name=None, named_args=None, arg_names=None, args=None, xmloption=None, typmod=None, location=None)

Wrapper for the homonymous parser node.

class pglast.ast.XmlSerialize(xmloption=None, expr=None, typeName=None, location=None)

Wrapper for the homonymous parser node.