Help us shape the future of Go! Take the 2026 Go Developer Survey

queries

package
v1.13.3 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 15, 2026 License: Apache-2.0 Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type GetAggregatesForSchemaRow

type GetAggregatesForSchemaRow struct {
	AggregateSchema        string         `db:"aggregate_schema" json:"aggregate_schema"`
	AggregateName          string         `db:"aggregate_name" json:"aggregate_name"`
	AggregateKind          interface{}    `db:"aggregate_kind" json:"aggregate_kind"`
	AggregateSignature     sql.NullString `db:"aggregate_signature" json:"aggregate_signature"`
	AggregateIdentityArgs  sql.NullString `db:"aggregate_identity_args" json:"aggregate_identity_args"`
	AggregateReturnType    sql.NullString `db:"aggregate_return_type" json:"aggregate_return_type"`
	Parallel               interface{}    `db:"parallel" json:"parallel"`
	TransitionFunction     sql.NullString `db:"transition_function" json:"transition_function"`
	StateType              sql.NullString `db:"state_type" json:"state_type"`
	StateSpace             int32          `db:"state_space" json:"state_space"`
	InitialCondition       sql.NullString `db:"initial_condition" json:"initial_condition"`
	FinalFunction          sql.NullString `db:"final_function" json:"final_function"`
	FinalFuncExtra         bool           `db:"final_func_extra" json:"final_func_extra"`
	FinalFuncModify        interface{}    `db:"final_func_modify" json:"final_func_modify"`
	CombineFunction        sql.NullString `db:"combine_function" json:"combine_function"`
	SerialFunction         sql.NullString `db:"serial_function" json:"serial_function"`
	DeserialFunction       sql.NullString `db:"deserial_function" json:"deserial_function"`
	MtransitionFunction    sql.NullString `db:"mtransition_function" json:"mtransition_function"`
	MinvTransitionFunction sql.NullString `db:"minv_transition_function" json:"minv_transition_function"`
	MstateType             sql.NullString `db:"mstate_type" json:"mstate_type"`
	MstateSpace            int32          `db:"mstate_space" json:"mstate_space"`
	MfinalFunction         sql.NullString `db:"mfinal_function" json:"mfinal_function"`
	MfinalFuncExtra        bool           `db:"mfinal_func_extra" json:"mfinal_func_extra"`
	MfinalFuncModify       interface{}    `db:"mfinal_func_modify" json:"mfinal_func_modify"`
	MinitialCondition      sql.NullString `db:"minitial_condition" json:"minitial_condition"`
	SortOperator           sql.NullString `db:"sort_operator" json:"sort_operator"`
	AggregateComment       sql.NullString `db:"aggregate_comment" json:"aggregate_comment"`
}

type GetAggregatesRow

type GetAggregatesRow struct {
	AggregateSchema          string         `db:"aggregate_schema" json:"aggregate_schema"`
	AggregateName            string         `db:"aggregate_name" json:"aggregate_name"`
	AggregateSignature       sql.NullString `db:"aggregate_signature" json:"aggregate_signature"`
	AggregateArguments       sql.NullString `db:"aggregate_arguments" json:"aggregate_arguments"`
	AggregateReturnType      sql.NullString `db:"aggregate_return_type" json:"aggregate_return_type"`
	TransitionFunction       sql.NullString `db:"transition_function" json:"transition_function"`
	TransitionFunctionSchema sql.NullString `db:"transition_function_schema" json:"transition_function_schema"`
	StateType                sql.NullString `db:"state_type" json:"state_type"`
	InitialCondition         sql.NullString `db:"initial_condition" json:"initial_condition"`
	FinalFunction            sql.NullString `db:"final_function" json:"final_function"`
	FinalFunctionSchema      sql.NullString `db:"final_function_schema" json:"final_function_schema"`
	AggregateComment         sql.NullString `db:"aggregate_comment" json:"aggregate_comment"`
}

type GetColumnPrivilegesForSchemaRow

type GetColumnPrivilegesForSchemaRow struct {
	TableName     string         `db:"table_name" json:"table_name"`
	ColumnName    string         `db:"column_name" json:"column_name"`
	GranteeName   sql.NullString `db:"grantee_name" json:"grantee_name"`
	PrivilegeType sql.NullString `db:"privilege_type" json:"privilege_type"`
	IsGrantable   sql.NullBool   `db:"is_grantable" json:"is_grantable"`
}

type GetColumnsForSchemaRow

type GetColumnsForSchemaRow struct {
	TableSchema              interface{}    `db:"table_schema" json:"table_schema"`
	TableName                interface{}    `db:"table_name" json:"table_name"`
	ColumnName               interface{}    `db:"column_name" json:"column_name"`
	OrdinalPosition          interface{}    `db:"ordinal_position" json:"ordinal_position"`
	ColumnDefault            sql.NullString `db:"column_default" json:"column_default"`
	IsNullable               interface{}    `db:"is_nullable" json:"is_nullable"`
	DataType                 interface{}    `db:"data_type" json:"data_type"`
	CharacterMaximumLength   interface{}    `db:"character_maximum_length" json:"character_maximum_length"`
	NumericPrecision         interface{}    `db:"numeric_precision" json:"numeric_precision"`
	NumericScale             interface{}    `db:"numeric_scale" json:"numeric_scale"`
	UdtName                  interface{}    `db:"udt_name" json:"udt_name"`
	ColumnComment            sql.NullString `db:"column_comment" json:"column_comment"`
	InvalidNotNullConstraint sql.NullString `db:"invalid_not_null_constraint" json:"invalid_not_null_constraint"`
	ColumnCollation          sql.NullString `db:"column_collation" json:"column_collation"`
	ResolvedType             sql.NullString `db:"resolved_type" json:"resolved_type"`
	IsIdentity               interface{}    `db:"is_identity" json:"is_identity"`
	IdentityGeneration       interface{}    `db:"identity_generation" json:"identity_generation"`
	IdentityStart            interface{}    `db:"identity_start" json:"identity_start"`
	IdentityIncrement        interface{}    `db:"identity_increment" json:"identity_increment"`
	IdentityMaximum          interface{}    `db:"identity_maximum" json:"identity_maximum"`
	IdentityMinimum          interface{}    `db:"identity_minimum" json:"identity_minimum"`
	IdentityCycle            interface{}    `db:"identity_cycle" json:"identity_cycle"`
	Attgenerated             interface{}    `db:"attgenerated" json:"attgenerated"`
	GeneratedExpr            sql.NullString `db:"generated_expr" json:"generated_expr"`
}

type GetColumnsRow

type GetColumnsRow struct {
	TableSchema              interface{}    `db:"table_schema" json:"table_schema"`
	TableName                interface{}    `db:"table_name" json:"table_name"`
	ColumnName               interface{}    `db:"column_name" json:"column_name"`
	OrdinalPosition          interface{}    `db:"ordinal_position" json:"ordinal_position"`
	ColumnDefault            sql.NullString `db:"column_default" json:"column_default"`
	IsNullable               interface{}    `db:"is_nullable" json:"is_nullable"`
	DataType                 interface{}    `db:"data_type" json:"data_type"`
	CharacterMaximumLength   interface{}    `db:"character_maximum_length" json:"character_maximum_length"`
	NumericPrecision         interface{}    `db:"numeric_precision" json:"numeric_precision"`
	NumericScale             interface{}    `db:"numeric_scale" json:"numeric_scale"`
	UdtName                  interface{}    `db:"udt_name" json:"udt_name"`
	ColumnComment            sql.NullString `db:"column_comment" json:"column_comment"`
	InvalidNotNullConstraint sql.NullString `db:"invalid_not_null_constraint" json:"invalid_not_null_constraint"`
	ColumnCollation          sql.NullString `db:"column_collation" json:"column_collation"`
	ResolvedType             sql.NullString `db:"resolved_type" json:"resolved_type"`
	IsIdentity               interface{}    `db:"is_identity" json:"is_identity"`
	IdentityGeneration       interface{}    `db:"identity_generation" json:"identity_generation"`
	IdentityStart            interface{}    `db:"identity_start" json:"identity_start"`
	IdentityIncrement        interface{}    `db:"identity_increment" json:"identity_increment"`
	IdentityMaximum          interface{}    `db:"identity_maximum" json:"identity_maximum"`
	IdentityMinimum          interface{}    `db:"identity_minimum" json:"identity_minimum"`
	IdentityCycle            interface{}    `db:"identity_cycle" json:"identity_cycle"`
	Attgenerated             interface{}    `db:"attgenerated" json:"attgenerated"`
	GeneratedExpr            sql.NullString `db:"generated_expr" json:"generated_expr"`
}

type GetCompositeTypeColumnsForSchemaRow

type GetCompositeTypeColumnsForSchemaRow struct {
	TypeSchema     string         `db:"type_schema" json:"type_schema"`
	TypeName       string         `db:"type_name" json:"type_name"`
	ColumnName     string         `db:"column_name" json:"column_name"`
	ColumnPosition int16          `db:"column_position" json:"column_position"`
	ColumnType     sql.NullString `db:"column_type" json:"column_type"`
}

type GetCompositeTypeColumnsRow

type GetCompositeTypeColumnsRow struct {
	TypeSchema     string         `db:"type_schema" json:"type_schema"`
	TypeName       string         `db:"type_name" json:"type_name"`
	ColumnName     string         `db:"column_name" json:"column_name"`
	ColumnPosition int16          `db:"column_position" json:"column_position"`
	ColumnType     sql.NullString `db:"column_type" json:"column_type"`
}

type GetConstraintsForSchemaRow

type GetConstraintsForSchemaRow struct {
	TableSchema            string         `db:"table_schema" json:"table_schema"`
	TableName              string         `db:"table_name" json:"table_name"`
	ConstraintName         string         `db:"constraint_name" json:"constraint_name"`
	ConstraintType         sql.NullString `db:"constraint_type" json:"constraint_type"`
	ColumnName             sql.NullString `db:"column_name" json:"column_name"`
	OrdinalPosition        sql.NullInt32  `db:"ordinal_position" json:"ordinal_position"`
	ConstraintPosition     sql.NullInt32  `db:"constraint_position" json:"constraint_position"`
	ForeignTableSchema     sql.NullString `db:"foreign_table_schema" json:"foreign_table_schema"`
	ForeignTableName       sql.NullString `db:"foreign_table_name" json:"foreign_table_name"`
	ForeignColumnName      sql.NullString `db:"foreign_column_name" json:"foreign_column_name"`
	ForeignOrdinalPosition sql.NullInt32  `db:"foreign_ordinal_position" json:"foreign_ordinal_position"`
	CheckClause            sql.NullString `db:"check_clause" json:"check_clause"`
	ExclusionDefinition    sql.NullString `db:"exclusion_definition" json:"exclusion_definition"`
	DeleteRule             sql.NullString `db:"delete_rule" json:"delete_rule"`
	UpdateRule             sql.NullString `db:"update_rule" json:"update_rule"`
	Deferrable             bool           `db:"deferrable" json:"deferrable"`
	InitiallyDeferred      bool           `db:"initially_deferred" json:"initially_deferred"`
	IsValid                bool           `db:"is_valid" json:"is_valid"`
	IsPeriod               sql.NullBool   `db:"is_period" json:"is_period"`
	NoInherit              bool           `db:"no_inherit" json:"no_inherit"`
	NullsNotDistinct       sql.NullBool   `db:"nulls_not_distinct" json:"nulls_not_distinct"`
	DeleteSetColumns       sql.NullString `db:"delete_set_columns" json:"delete_set_columns"`
}

type GetConstraintsRow

type GetConstraintsRow struct {
	TableSchema            string         `db:"table_schema" json:"table_schema"`
	TableName              string         `db:"table_name" json:"table_name"`
	ConstraintName         string         `db:"constraint_name" json:"constraint_name"`
	ConstraintType         sql.NullString `db:"constraint_type" json:"constraint_type"`
	ColumnName             sql.NullString `db:"column_name" json:"column_name"`
	OrdinalPosition        sql.NullInt32  `db:"ordinal_position" json:"ordinal_position"`
	ForeignTableSchema     sql.NullString `db:"foreign_table_schema" json:"foreign_table_schema"`
	ForeignTableName       sql.NullString `db:"foreign_table_name" json:"foreign_table_name"`
	ForeignColumnName      sql.NullString `db:"foreign_column_name" json:"foreign_column_name"`
	ForeignOrdinalPosition sql.NullInt32  `db:"foreign_ordinal_position" json:"foreign_ordinal_position"`
	CheckClause            sql.NullString `db:"check_clause" json:"check_clause"`
	ExclusionDefinition    sql.NullString `db:"exclusion_definition" json:"exclusion_definition"`
	DeleteRule             sql.NullString `db:"delete_rule" json:"delete_rule"`
	UpdateRule             sql.NullString `db:"update_rule" json:"update_rule"`
	Deferrable             bool           `db:"deferrable" json:"deferrable"`
	InitiallyDeferred      bool           `db:"initially_deferred" json:"initially_deferred"`
	IsValid                bool           `db:"is_valid" json:"is_valid"`
	IsPeriod               sql.NullBool   `db:"is_period" json:"is_period"`
	NoInherit              bool           `db:"no_inherit" json:"no_inherit"`
	DeleteSetColumns       sql.NullString `db:"delete_set_columns" json:"delete_set_columns"`
}

type GetDefaultPrivilegesForSchemaRow

type GetDefaultPrivilegesForSchemaRow struct {
	OwnerRole     sql.NullString `db:"owner_role" json:"owner_role"`
	ObjectType    sql.NullString `db:"object_type" json:"object_type"`
	Grantee       sql.NullString `db:"grantee" json:"grantee"`
	PrivilegeType sql.NullString `db:"privilege_type" json:"privilege_type"`
	IsGrantable   sql.NullBool   `db:"is_grantable" json:"is_grantable"`
}

type GetDomainConstraintsForSchemaRow

type GetDomainConstraintsForSchemaRow struct {
	DomainSchema         string         `db:"domain_schema" json:"domain_schema"`
	DomainName           string         `db:"domain_name" json:"domain_name"`
	ConstraintName       string         `db:"constraint_name" json:"constraint_name"`
	ConstraintDefinition sql.NullString `db:"constraint_definition" json:"constraint_definition"`
}

type GetDomainConstraintsRow

type GetDomainConstraintsRow struct {
	DomainSchema         string         `db:"domain_schema" json:"domain_schema"`
	DomainName           string         `db:"domain_name" json:"domain_name"`
	ConstraintName       string         `db:"constraint_name" json:"constraint_name"`
	ConstraintDefinition sql.NullString `db:"constraint_definition" json:"constraint_definition"`
}

type GetDomainsForSchemaRow

type GetDomainsForSchemaRow struct {
	DomainSchema  string         `db:"domain_schema" json:"domain_schema"`
	DomainName    string         `db:"domain_name" json:"domain_name"`
	BaseType      sql.NullString `db:"base_type" json:"base_type"`
	NotNull       bool           `db:"not_null" json:"not_null"`
	DefaultValue  sql.NullString `db:"default_value" json:"default_value"`
	DomainComment sql.NullString `db:"domain_comment" json:"domain_comment"`
}

type GetDomainsRow

type GetDomainsRow struct {
	DomainSchema  string         `db:"domain_schema" json:"domain_schema"`
	DomainName    string         `db:"domain_name" json:"domain_name"`
	BaseType      sql.NullString `db:"base_type" json:"base_type"`
	NotNull       bool           `db:"not_null" json:"not_null"`
	DefaultValue  sql.NullString `db:"default_value" json:"default_value"`
	DomainComment sql.NullString `db:"domain_comment" json:"domain_comment"`
}

type GetEnumValuesForSchemaRow

type GetEnumValuesForSchemaRow struct {
	TypeSchema string  `db:"type_schema" json:"type_schema"`
	TypeName   string  `db:"type_name" json:"type_name"`
	EnumValue  string  `db:"enum_value" json:"enum_value"`
	EnumOrder  float32 `db:"enum_order" json:"enum_order"`
}

type GetEnumValuesRow

type GetEnumValuesRow struct {
	TypeSchema string  `db:"type_schema" json:"type_schema"`
	TypeName   string  `db:"type_name" json:"type_name"`
	EnumValue  string  `db:"enum_value" json:"enum_value"`
	EnumOrder  float32 `db:"enum_order" json:"enum_order"`
}

type GetFunctionDependenciesRow

type GetFunctionDependenciesRow struct {
	DependentSchema  string         `db:"dependent_schema" json:"dependent_schema"`
	DependentName    string         `db:"dependent_name" json:"dependent_name"`
	DependentArgs    sql.NullString `db:"dependent_args" json:"dependent_args"`
	ReferencedSchema string         `db:"referenced_schema" json:"referenced_schema"`
	ReferencedName   string         `db:"referenced_name" json:"referenced_name"`
	ReferencedArgs   sql.NullString `db:"referenced_args" json:"referenced_args"`
}

type GetFunctionsForSchemaRow

type GetFunctionsForSchemaRow struct {
	RoutineSchema     interface{}    `db:"routine_schema" json:"routine_schema"`
	RoutineName       interface{}    `db:"routine_name" json:"routine_name"`
	RoutineDefinition sql.NullString `db:"routine_definition" json:"routine_definition"`
	RoutineType       interface{}    `db:"routine_type" json:"routine_type"`
	DataType          sql.NullString `db:"data_type" json:"data_type"`
	ExternalLanguage  interface{}    `db:"external_language" json:"external_language"`
	FunctionComment   sql.NullString `db:"function_comment" json:"function_comment"`
	FunctionArguments sql.NullString `db:"function_arguments" json:"function_arguments"`
	FunctionSignature sql.NullString `db:"function_signature" json:"function_signature"`
	Volatility        sql.NullString `db:"volatility" json:"volatility"`
	IsStrict          bool           `db:"is_strict" json:"is_strict"`
	IsSecurityDefiner bool           `db:"is_security_definer" json:"is_security_definer"`
	IsLeakproof       bool           `db:"is_leakproof" json:"is_leakproof"`
	ParallelMode      interface{}    `db:"parallel_mode" json:"parallel_mode"`
	SetConfig         []string       `db:"set_config" json:"set_config"`
}

type GetFunctionsRow

type GetFunctionsRow struct {
	RoutineSchema     interface{}    `db:"routine_schema" json:"routine_schema"`
	RoutineName       interface{}    `db:"routine_name" json:"routine_name"`
	RoutineDefinition string         `db:"routine_definition" json:"routine_definition"`
	RoutineType       interface{}    `db:"routine_type" json:"routine_type"`
	DataType          sql.NullString `db:"data_type" json:"data_type"`
	ExternalLanguage  interface{}    `db:"external_language" json:"external_language"`
	FunctionComment   sql.NullString `db:"function_comment" json:"function_comment"`
	FunctionArguments sql.NullString `db:"function_arguments" json:"function_arguments"`
	FunctionSignature sql.NullString `db:"function_signature" json:"function_signature"`
	Volatility        sql.NullString `db:"volatility" json:"volatility"`
	IsStrict          bool           `db:"is_strict" json:"is_strict"`
	IsSecurityDefiner bool           `db:"is_security_definer" json:"is_security_definer"`
}

type GetIndexesForSchemaRow

type GetIndexesForSchemaRow struct {
	Schemaname          string         `db:"schemaname" json:"schemaname"`
	Tablename           string         `db:"tablename" json:"tablename"`
	Indexname           string         `db:"indexname" json:"indexname"`
	ParentIndex         sql.NullString `db:"parent_index" json:"parent_index"`
	ParentIndexSchema   sql.NullString `db:"parent_index_schema" json:"parent_index_schema"`
	IsUnique            bool           `db:"is_unique" json:"is_unique"`
	IsPrimary           bool           `db:"is_primary" json:"is_primary"`
	IsPartial           sql.NullBool   `db:"is_partial" json:"is_partial"`
	Method              string         `db:"method" json:"method"`
	Indexdef            sql.NullString `db:"indexdef" json:"indexdef"`
	PartialPredicate    sql.NullString `db:"partial_predicate" json:"partial_predicate"`
	HasExpressions      sql.NullBool   `db:"has_expressions" json:"has_expressions"`
	IndexComment        sql.NullString `db:"index_comment" json:"index_comment"`
	Reloptions          []string       `db:"reloptions" json:"reloptions"`
	NumKeyColumns       int16          `db:"num_key_columns" json:"num_key_columns"`
	NumColumns          int16          `db:"num_columns" json:"num_columns"`
	ColumnDefinitions   []string       `db:"column_definitions" json:"column_definitions"`
	ColumnDirections    []string       `db:"column_directions" json:"column_directions"`
	ColumnNullOrderings []string       `db:"column_null_orderings" json:"column_null_orderings"`
	ColumnOpclasses     []string       `db:"column_opclasses" json:"column_opclasses"`
	IncludeColumns      []string       `db:"include_columns" json:"include_columns"`
}

type GetIndexesRow

type GetIndexesRow struct {
	Schemaname       string         `db:"schemaname" json:"schemaname"`
	Tablename        string         `db:"tablename" json:"tablename"`
	Indexname        string         `db:"indexname" json:"indexname"`
	IsUnique         bool           `db:"is_unique" json:"is_unique"`
	IsPrimary        bool           `db:"is_primary" json:"is_primary"`
	IsPartial        sql.NullBool   `db:"is_partial" json:"is_partial"`
	Method           string         `db:"method" json:"method"`
	Indexdef         sql.NullString `db:"indexdef" json:"indexdef"`
	PartialPredicate sql.NullString `db:"partial_predicate" json:"partial_predicate"`
	HasExpressions   sql.NullBool   `db:"has_expressions" json:"has_expressions"`
}

type GetPartitionChildrenRow

type GetPartitionChildrenRow struct {
	ParentSchema   string         `db:"parent_schema" json:"parent_schema"`
	ParentTable    string         `db:"parent_table" json:"parent_table"`
	ChildSchema    string         `db:"child_schema" json:"child_schema"`
	ChildTable     string         `db:"child_table" json:"child_table"`
	PartitionBound sql.NullString `db:"partition_bound" json:"partition_bound"`
}

type GetPartitionParentColumnsForSchemaRow added in v1.13.1

type GetPartitionParentColumnsForSchemaRow struct {
	ChildTable    string         `db:"child_table" json:"child_table"`
	ColumnName    string         `db:"column_name" json:"column_name"`
	IsNullable    sql.NullBool   `db:"is_nullable" json:"is_nullable"`
	ColumnDefault sql.NullString `db:"column_default" json:"column_default"`
}

type GetPartitionedTablesForSchemaRow

type GetPartitionedTablesForSchemaRow struct {
	TableSchema       string         `db:"table_schema" json:"table_schema"`
	TableName         string         `db:"table_name" json:"table_name"`
	PartitionStrategy sql.NullString `db:"partition_strategy" json:"partition_strategy"`
	PartitionKey      sql.NullString `db:"partition_key" json:"partition_key"`
}

type GetPrivilegesForSchemaRow

type GetPrivilegesForSchemaRow struct {
	SchemaName    sql.NullString `db:"schema_name" json:"schema_name"`
	ObjectName    sql.NullString `db:"object_name" json:"object_name"`
	ObjectType    sql.NullString `db:"object_type" json:"object_type"`
	GranteeName   sql.NullString `db:"grantee_name" json:"grantee_name"`
	PrivilegeType sql.NullString `db:"privilege_type" json:"privilege_type"`
	IsGrantable   sql.NullBool   `db:"is_grantable" json:"is_grantable"`
	Owner         sql.NullString `db:"owner" json:"owner"`
}

type GetProceduresForSchemaRow

type GetProceduresForSchemaRow struct {
	RoutineSchema      interface{}    `db:"routine_schema" json:"routine_schema"`
	RoutineName        interface{}    `db:"routine_name" json:"routine_name"`
	RoutineDefinition  sql.NullString `db:"routine_definition" json:"routine_definition"`
	RoutineType        interface{}    `db:"routine_type" json:"routine_type"`
	ExternalLanguage   interface{}    `db:"external_language" json:"external_language"`
	ProcedureComment   sql.NullString `db:"procedure_comment" json:"procedure_comment"`
	ProcedureArguments sql.NullString `db:"procedure_arguments" json:"procedure_arguments"`
	ProcedureSignature sql.NullString `db:"procedure_signature" json:"procedure_signature"`
}

type GetProceduresRow

type GetProceduresRow struct {
	RoutineSchema      interface{}    `db:"routine_schema" json:"routine_schema"`
	RoutineName        interface{}    `db:"routine_name" json:"routine_name"`
	RoutineDefinition  string         `db:"routine_definition" json:"routine_definition"`
	RoutineType        interface{}    `db:"routine_type" json:"routine_type"`
	ExternalLanguage   interface{}    `db:"external_language" json:"external_language"`
	ProcedureComment   sql.NullString `db:"procedure_comment" json:"procedure_comment"`
	ProcedureArguments sql.NullString `db:"procedure_arguments" json:"procedure_arguments"`
	ProcedureSignature sql.NullString `db:"procedure_signature" json:"procedure_signature"`
}

type GetRLSPoliciesForSchemaRow

type GetRLSPoliciesForSchemaRow struct {
	Schemaname string         `db:"schemaname" json:"schemaname"`
	Tablename  string         `db:"tablename" json:"tablename"`
	Policyname string         `db:"policyname" json:"policyname"`
	Permissive string         `db:"permissive" json:"permissive"`
	Roles      []string       `db:"roles" json:"roles"`
	Cmd        sql.NullString `db:"cmd" json:"cmd"`
	Qual       sql.NullString `db:"qual" json:"qual"`
	WithCheck  sql.NullString `db:"with_check" json:"with_check"`
}

type GetRLSPoliciesRow

type GetRLSPoliciesRow struct {
	Schemaname string         `db:"schemaname" json:"schemaname"`
	Tablename  string         `db:"tablename" json:"tablename"`
	Policyname string         `db:"policyname" json:"policyname"`
	Permissive string         `db:"permissive" json:"permissive"`
	Roles      []string       `db:"roles" json:"roles"`
	Cmd        sql.NullString `db:"cmd" json:"cmd"`
	Qual       sql.NullString `db:"qual" json:"qual"`
	WithCheck  sql.NullString `db:"with_check" json:"with_check"`
}

type GetRLSTablesForSchemaRow

type GetRLSTablesForSchemaRow struct {
	Schemaname  string `db:"schemaname" json:"schemaname"`
	Tablename   string `db:"tablename" json:"tablename"`
	Rowsecurity bool   `db:"rowsecurity" json:"rowsecurity"`
	Rowforced   bool   `db:"rowforced" json:"rowforced"`
}

type GetRLSTablesRow

type GetRLSTablesRow struct {
	Schemaname  string `db:"schemaname" json:"schemaname"`
	Tablename   string `db:"tablename" json:"tablename"`
	Rowsecurity bool   `db:"rowsecurity" json:"rowsecurity"`
	Rowforced   bool   `db:"rowforced" json:"rowforced"`
}

type GetRevokedDefaultPrivilegesForSchemaRow

type GetRevokedDefaultPrivilegesForSchemaRow struct {
	ObjectName sql.NullString `db:"object_name" json:"object_name"`
	ObjectType sql.NullString `db:"object_type" json:"object_type"`
}

type GetSequencesForSchemaRow

type GetSequencesForSchemaRow struct {
	SequenceSchema  sql.NullString `db:"sequence_schema" json:"sequence_schema"`
	SequenceName    sql.NullString `db:"sequence_name" json:"sequence_name"`
	DataType        interface{}    `db:"data_type" json:"data_type"`
	StartValue      sql.NullInt64  `db:"start_value" json:"start_value"`
	MinimumValue    sql.NullInt64  `db:"minimum_value" json:"minimum_value"`
	MaximumValue    sql.NullInt64  `db:"maximum_value" json:"maximum_value"`
	Increment       sql.NullInt64  `db:"increment" json:"increment"`
	CycleOption     sql.NullBool   `db:"cycle_option" json:"cycle_option"`
	CacheSize       sql.NullInt64  `db:"cache_size" json:"cache_size"`
	OwnedByTable    sql.NullString `db:"owned_by_table" json:"owned_by_table"`
	OwnedByColumn   sql.NullString `db:"owned_by_column" json:"owned_by_column"`
	OwnedByIdentity sql.NullBool   `db:"owned_by_identity" json:"owned_by_identity"`
	SequenceComment sql.NullString `db:"sequence_comment" json:"sequence_comment"`
}

type GetSequencesRow

type GetSequencesRow struct {
	SequenceSchema interface{} `db:"sequence_schema" json:"sequence_schema"`
	SequenceName   interface{} `db:"sequence_name" json:"sequence_name"`
	DataType       interface{} `db:"data_type" json:"data_type"`
	StartValue     interface{} `db:"start_value" json:"start_value"`
	MinimumValue   interface{} `db:"minimum_value" json:"minimum_value"`
	MaximumValue   interface{} `db:"maximum_value" json:"maximum_value"`
	Increment      interface{} `db:"increment" json:"increment"`
	CycleOption    interface{} `db:"cycle_option" json:"cycle_option"`
}

type GetTablesForSchemaRow

type GetTablesForSchemaRow struct {
	TableSchema    interface{}    `db:"table_schema" json:"table_schema"`
	TableName      interface{}    `db:"table_name" json:"table_name"`
	TableType      interface{}    `db:"table_type" json:"table_type"`
	TableComment   sql.NullString `db:"table_comment" json:"table_comment"`
	Relpersistence sql.NullString `db:"relpersistence" json:"relpersistence"`
}

type GetTablesRow

type GetTablesRow struct {
	TableSchema    interface{}    `db:"table_schema" json:"table_schema"`
	TableName      interface{}    `db:"table_name" json:"table_name"`
	TableType      interface{}    `db:"table_type" json:"table_type"`
	TableComment   sql.NullString `db:"table_comment" json:"table_comment"`
	Relpersistence sql.NullString `db:"relpersistence" json:"relpersistence"`
}

type GetTriggersForSchemaRow

type GetTriggersForSchemaRow struct {
	TriggerSchema        string         `db:"trigger_schema" json:"trigger_schema"`
	EventObjectTable     string         `db:"event_object_table" json:"event_object_table"`
	TriggerName          string         `db:"trigger_name" json:"trigger_name"`
	TriggerType          int16          `db:"trigger_type" json:"trigger_type"`
	TriggerEnabled       interface{}    `db:"trigger_enabled" json:"trigger_enabled"`
	TriggerDeferrable    bool           `db:"trigger_deferrable" json:"trigger_deferrable"`
	TriggerInitdeferred  bool           `db:"trigger_initdeferred" json:"trigger_initdeferred"`
	TriggerConstraintOid interface{}    `db:"trigger_constraint_oid" json:"trigger_constraint_oid"`
	TriggerDefinition    sql.NullString `db:"trigger_definition" json:"trigger_definition"`
	OldTable             sql.NullString `db:"old_table" json:"old_table"`
	NewTable             sql.NullString `db:"new_table" json:"new_table"`
	FunctionName         string         `db:"function_name" json:"function_name"`
	FunctionSchema       string         `db:"function_schema" json:"function_schema"`
	TriggerComment       sql.NullString `db:"trigger_comment" json:"trigger_comment"`
}

type GetTriggersRow

type GetTriggersRow struct {
	TriggerSchema     interface{} `db:"trigger_schema" json:"trigger_schema"`
	TriggerName       interface{} `db:"trigger_name" json:"trigger_name"`
	EventObjectTable  interface{} `db:"event_object_table" json:"event_object_table"`
	ActionTiming      interface{} `db:"action_timing" json:"action_timing"`
	EventManipulation interface{} `db:"event_manipulation" json:"event_manipulation"`
	ActionStatement   interface{} `db:"action_statement" json:"action_statement"`
	ActionCondition   interface{} `db:"action_condition" json:"action_condition"`
	ActionOrientation interface{} `db:"action_orientation" json:"action_orientation"`
}

type GetTypesForSchemaRow

type GetTypesForSchemaRow struct {
	TypeSchema  string         `db:"type_schema" json:"type_schema"`
	TypeName    string         `db:"type_name" json:"type_name"`
	TypeKind    sql.NullString `db:"type_kind" json:"type_kind"`
	TypeComment sql.NullString `db:"type_comment" json:"type_comment"`
}

type GetTypesRow

type GetTypesRow struct {
	TypeSchema  string         `db:"type_schema" json:"type_schema"`
	TypeName    string         `db:"type_name" json:"type_name"`
	TypeKind    sql.NullString `db:"type_kind" json:"type_kind"`
	TypeComment sql.NullString `db:"type_comment" json:"type_comment"`
}

type GetViewDependenciesRow

type GetViewDependenciesRow struct {
	DependentSchema interface{} `db:"dependent_schema" json:"dependent_schema"`
	DependentName   interface{} `db:"dependent_name" json:"dependent_name"`
	SourceSchema    interface{} `db:"source_schema" json:"source_schema"`
	SourceName      interface{} `db:"source_name" json:"source_name"`
}

type GetViewsForSchemaRow

type GetViewsForSchemaRow struct {
	TableSchema    string         `db:"table_schema" json:"table_schema"`
	TableName      string         `db:"table_name" json:"table_name"`
	ViewDefinition sql.NullString `db:"view_definition" json:"view_definition"`
	ViewComment    sql.NullString `db:"view_comment" json:"view_comment"`
	IsMaterialized sql.NullBool   `db:"is_materialized" json:"is_materialized"`
	Reloptions     []string       `db:"reloptions" json:"reloptions"`
	ColumnNames    []string       `db:"column_names" json:"column_names"`
}

type GetViewsRow

type GetViewsRow struct {
	TableSchema    string         `db:"table_schema" json:"table_schema"`
	TableName      string         `db:"table_name" json:"table_name"`
	ViewDefinition sql.NullString `db:"view_definition" json:"view_definition"`
	ViewComment    sql.NullString `db:"view_comment" json:"view_comment"`
	IsMaterialized sql.NullBool   `db:"is_materialized" json:"is_materialized"`
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) GetAggregates

func (q *Queries) GetAggregates(ctx context.Context) ([]GetAggregatesRow, error)

GetAggregates retrieves all user-defined aggregates

func (*Queries) GetAggregatesForSchema

func (q *Queries) GetAggregatesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetAggregatesForSchemaRow, error)

GetAggregatesForSchema retrieves all user-defined aggregates for a specific schema. Support-function references (SFUNC, FINALFUNC, COMBINEFUNC, ...) are pre-quoted and schema-qualified only when they live in a different schema than the aggregate, so the desired/current IR keys line up and the plan normalizer never has to rewrite them.

func (*Queries) GetColumnPrivilegesForSchema

func (q *Queries) GetColumnPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetColumnPrivilegesForSchemaRow, error)

GetColumnPrivilegesForSchema retrieves column-level privilege grants Column privileges are stored in pg_attribute.attacl and allow fine-grained access

func (*Queries) GetColumns

func (q *Queries) GetColumns(ctx context.Context) ([]GetColumnsRow, error)

GetColumns retrieves all columns for all tables

func (*Queries) GetColumnsForSchema

func (q *Queries) GetColumnsForSchema(ctx context.Context, tableSchema sql.NullString) ([]GetColumnsForSchemaRow, error)

GetColumnsForSchema retrieves all columns for tables in a specific schema

func (*Queries) GetCompositeTypeColumns

func (q *Queries) GetCompositeTypeColumns(ctx context.Context) ([]GetCompositeTypeColumnsRow, error)

GetCompositeTypeColumns retrieves columns for composite types

func (*Queries) GetCompositeTypeColumnsForSchema

func (q *Queries) GetCompositeTypeColumnsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetCompositeTypeColumnsForSchemaRow, error)

GetCompositeTypeColumnsForSchema retrieves columns for composite types in a specific schema

func (*Queries) GetConstraints

func (q *Queries) GetConstraints(ctx context.Context) ([]GetConstraintsRow, error)

GetConstraints retrieves all table constraints

func (*Queries) GetConstraintsForSchema

func (q *Queries) GetConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetConstraintsForSchemaRow, error)

GetConstraintsForSchema retrieves all table constraints for a specific schema

func (*Queries) GetDefaultPrivilegesForSchema

func (q *Queries) GetDefaultPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDefaultPrivilegesForSchemaRow, error)

GetDefaultPrivilegesForSchema retrieves default privileges for a specific schema

func (*Queries) GetDomainConstraints

func (q *Queries) GetDomainConstraints(ctx context.Context) ([]GetDomainConstraintsRow, error)

GetDomainConstraints retrieves constraints for domains

func (*Queries) GetDomainConstraintsForSchema

func (q *Queries) GetDomainConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDomainConstraintsForSchemaRow, error)

GetDomainConstraintsForSchema retrieves constraints for domains in a specific schema

func (*Queries) GetDomains

func (q *Queries) GetDomains(ctx context.Context) ([]GetDomainsRow, error)

GetDomains retrieves all user-defined domains

func (*Queries) GetDomainsForSchema

func (q *Queries) GetDomainsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDomainsForSchemaRow, error)

GetDomainsForSchema retrieves all user-defined domains for a specific schema

func (*Queries) GetEnumValues

func (q *Queries) GetEnumValues(ctx context.Context) ([]GetEnumValuesRow, error)

GetEnumValues retrieves enum values for ENUM types

func (*Queries) GetEnumValuesForSchema

func (q *Queries) GetEnumValuesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetEnumValuesForSchemaRow, error)

GetEnumValuesForSchema retrieves enum values for ENUM types in a specific schema

func (*Queries) GetFunctionDependencies

func (q *Queries) GetFunctionDependencies(ctx context.Context, dollar_1 sql.NullString) ([]GetFunctionDependenciesRow, error)

GetFunctionDependencies retrieves function-to-function dependencies for topological sorting

func (*Queries) GetFunctions

func (q *Queries) GetFunctions(ctx context.Context) ([]GetFunctionsRow, error)

GetFunctions retrieves all user-defined functions (excluding extension members)

func (*Queries) GetFunctionsForSchema

func (q *Queries) GetFunctionsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetFunctionsForSchemaRow, error)

GetFunctionsForSchema retrieves all user-defined functions for a specific schema

func (*Queries) GetIndexes

func (q *Queries) GetIndexes(ctx context.Context) ([]GetIndexesRow, error)

GetIndexes retrieves all indexes including regular and unique indexes created with CREATE INDEX IMPORTANT: Uses LATERAL join with set_config to temporarily set search_path to empty This ensures pg_get_expr() includes schema qualifiers for types in partial index predicates, matching pg_dump's behavior and preventing false positives when comparing schemas

func (*Queries) GetIndexesForSchema

func (q *Queries) GetIndexesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetIndexesForSchemaRow, error)

GetIndexesForSchema retrieves all indexes for a specific schema IMPORTANT: Uses LATERAL join with set_config to temporarily set search_path to empty This ensures pg_get_expr() includes schema qualifiers for types in partial index predicates, matching pg_dump's behavior and preventing false positives when comparing schemas

func (*Queries) GetPartitionChildren

func (q *Queries) GetPartitionChildren(ctx context.Context) ([]GetPartitionChildrenRow, error)

GetPartitionChildren retrieves partition child tables and their attachment information

func (*Queries) GetPartitionParentColumnsForSchema added in v1.13.1

func (q *Queries) GetPartitionParentColumnsForSchema(ctx context.Context, nspname string) ([]GetPartitionParentColumnsForSchemaRow, error)

Parent columns are comparison metadata for managed partitions whose parent is not in the managed IR (for example, an extension member). Do not apply extension-member filters here: these rows never become managed tables.

func (*Queries) GetPartitionedTablesForSchema

func (q *Queries) GetPartitionedTablesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetPartitionedTablesForSchemaRow, error)

GetPartitionedTablesForSchema retrieves partition information for partitioned tables in a specific schema

func (*Queries) GetPrivilegesForSchema

func (q *Queries) GetPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetPrivilegesForSchemaRow, error)

GetPrivilegesForSchema retrieves explicit privilege grants for objects in a specific schema

func (*Queries) GetProcedures

func (q *Queries) GetProcedures(ctx context.Context) ([]GetProceduresRow, error)

GetProcedures retrieves all user-defined procedures (excluding extension members)

func (*Queries) GetProceduresForSchema

func (q *Queries) GetProceduresForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetProceduresForSchemaRow, error)

GetProceduresForSchema retrieves all user-defined procedures for a specific schema

func (*Queries) GetRLSPolicies

func (q *Queries) GetRLSPolicies(ctx context.Context) ([]GetRLSPoliciesRow, error)

GetRLSPolicies retrieves all row level security policies This replicates the pg_policies system view but computes the qual/with_check expressions with a forced search_path so qualification is deterministic:

  1. set_config sets search_path to only the table's own schema
  2. pg_get_expr then renders same-schema references unqualified while cross-schema references (e.g. Supabase's auth.uid(), issue #427) stay qualified. Without this, rendering depends on the session search_path and the current/desired states compare differently (issue #449).

func (*Queries) GetRLSPoliciesForSchema

func (q *Queries) GetRLSPoliciesForSchema(ctx context.Context, nspname string) ([]GetRLSPoliciesForSchemaRow, error)

GetRLSPoliciesForSchema retrieves all row level security policies for a specific schema See GetRLSPolicies for why qual/with_check are computed under a forced pg_catalog search_path (Issue #427).

func (*Queries) GetRLSTables

func (q *Queries) GetRLSTables(ctx context.Context) ([]GetRLSTablesRow, error)

GetRLSTables retrieves tables with row level security enabled

func (*Queries) GetRLSTablesForSchema

func (q *Queries) GetRLSTablesForSchema(ctx context.Context, nspname string) ([]GetRLSTablesForSchemaRow, error)

GetRLSTablesForSchema retrieves tables with row level security enabled for a specific schema

func (*Queries) GetRevokedDefaultPrivilegesForSchema

func (q *Queries) GetRevokedDefaultPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetRevokedDefaultPrivilegesForSchemaRow, error)

GetRevokedDefaultPrivilegesForSchema finds objects where default PUBLIC grants have been explicitly revoked

func (*Queries) GetSchema

func (q *Queries) GetSchema(ctx context.Context, schemaName sql.NullString) (interface{}, error)

GetSchema retrieves a specific schema by name

func (*Queries) GetSchemas

func (q *Queries) GetSchemas(ctx context.Context) ([]interface{}, error)

Extension members are identified by their full pg_depend catalog identity. Only deptype 'e' denotes membership; ordinary dependencies (including 'x', AUTO_EXTENSION) must stay managed. Definitions and member ACLs are excluded consistently for dump and both sides of planning. Schemas themselves remain inspectable because an extension schema can also contain application objects. GetSchemas retrieves all user-defined schemas

func (*Queries) GetSequences

func (q *Queries) GetSequences(ctx context.Context) ([]GetSequencesRow, error)

GetSequences retrieves all sequences

func (*Queries) GetSequencesForSchema

func (q *Queries) GetSequencesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetSequencesForSchemaRow, error)

GetSequencesForSchema retrieves all sequences for a specific schema Ownership comes only from pg_depend (SERIAL / OWNED BY / identity). A sequence merely referenced by a column DEFAULT nextval() is not owned by that column and must be dumped and created explicitly (issue #573).

func (*Queries) GetTables

func (q *Queries) GetTables(ctx context.Context) ([]GetTablesRow, error)

GetTables retrieves all tables in the database with metadata

func (*Queries) GetTablesForSchema

func (q *Queries) GetTablesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTablesForSchemaRow, error)

GetTablesForSchema retrieves all tables in a specific schema with metadata

func (*Queries) GetTriggers

func (q *Queries) GetTriggers(ctx context.Context) ([]GetTriggersRow, error)

GetTriggers retrieves all triggers

func (*Queries) GetTriggersForSchema

func (q *Queries) GetTriggersForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTriggersForSchemaRow, error)

GetTriggersForSchema retrieves all triggers for a specific schema Uses pg_trigger catalog to include all trigger types (including TRUNCATE) which are not visible in information_schema.triggers

The trigger definition is rendered with a forced search_path so qualification is deterministic (mirrors GetRLSPoliciesForSchema):

  1. set_config sets search_path to only the trigger's own schema
  2. pg_get_triggerdef then renders same-schema type casts and function references in the WHEN clause unqualified (e.g. 'VIDEO'::media_type), while cross-schema references stay qualified. Without this, qualification depends on the session search_path: in a non-public schema the current state comes back qualified ('VIDEO'::content.media_type) while the desired state is unqualified, so a repeat plan keeps recreating the trigger (issue #481).

func (*Queries) GetTypes

func (q *Queries) GetTypes(ctx context.Context) ([]GetTypesRow, error)

GetTypes retrieves all user-defined types (ENUM and composite types)

func (*Queries) GetTypesForSchema

func (q *Queries) GetTypesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTypesForSchemaRow, error)

GetTypesForSchema retrieves all user-defined types for a specific schema

func (*Queries) GetViewDependencies

func (q *Queries) GetViewDependencies(ctx context.Context) ([]GetViewDependenciesRow, error)

GetViewDependencies retrieves view dependencies on tables and other views

func (*Queries) GetViews

func (q *Queries) GetViews(ctx context.Context) ([]GetViewsRow, error)

GetViews retrieves all views and materialized views

func (*Queries) GetViewsForSchema

func (q *Queries) GetViewsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetViewsForSchemaRow, error)

GetViewsForSchema retrieves all views and materialized views for a specific schema IMPORTANT: Uses LATERAL join with set_config to temporarily set search_path to only the view's schema This ensures pg_get_viewdef() includes schema qualifiers for cross-schema references The LATERAL join guarantees set_config executes before pg_get_viewdef in the same row context

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL