Documentation
¶
Index ¶
- type DBTX
- type GetAggregatesForSchemaRow
- type GetAggregatesRow
- type GetColumnPrivilegesForSchemaRow
- type GetColumnsForSchemaRow
- type GetColumnsRow
- type GetCompositeTypeColumnsForSchemaRow
- type GetCompositeTypeColumnsRow
- type GetConstraintsForSchemaRow
- type GetConstraintsRow
- type GetDefaultPrivilegesForSchemaRow
- type GetDomainConstraintsForSchemaRow
- type GetDomainConstraintsRow
- type GetDomainsForSchemaRow
- type GetDomainsRow
- type GetEnumValuesForSchemaRow
- type GetEnumValuesRow
- type GetFunctionDependenciesRow
- type GetFunctionsForSchemaRow
- type GetFunctionsRow
- type GetIndexesForSchemaRow
- type GetIndexesRow
- type GetInheritedPartitionConstraintsForSchemaRow
- type GetPartitionChildrenRow
- type GetPartitionParentColumnsForSchemaRow
- type GetPartitionedTablesForSchemaRow
- type GetPrivilegesForSchemaRow
- type GetProceduresForSchemaRow
- type GetProceduresRow
- type GetRLSPoliciesForSchemaRow
- type GetRLSPoliciesRow
- type GetRLSTablesForSchemaRow
- type GetRLSTablesRow
- type GetRevokedDefaultPrivilegesForSchemaRow
- type GetSequencesForSchemaRow
- type GetSequencesRow
- type GetTablesForSchemaRow
- type GetTablesRow
- type GetTriggersForSchemaRow
- type GetTriggersRow
- type GetTypesForSchemaRow
- type GetTypesRow
- type GetViewDependenciesRow
- type GetViewsForSchemaRow
- type GetViewsRow
- type Queries
- func (q *Queries) GetAggregates(ctx context.Context) ([]GetAggregatesRow, error)
- func (q *Queries) GetAggregatesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetAggregatesForSchemaRow, error)
- func (q *Queries) GetColumnPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetColumnPrivilegesForSchemaRow, error)
- func (q *Queries) GetColumns(ctx context.Context) ([]GetColumnsRow, error)
- func (q *Queries) GetColumnsForSchema(ctx context.Context, tableSchema sql.NullString) ([]GetColumnsForSchemaRow, error)
- func (q *Queries) GetCompositeTypeColumns(ctx context.Context) ([]GetCompositeTypeColumnsRow, error)
- func (q *Queries) GetCompositeTypeColumnsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetCompositeTypeColumnsForSchemaRow, error)
- func (q *Queries) GetConstraints(ctx context.Context) ([]GetConstraintsRow, error)
- func (q *Queries) GetConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetConstraintsForSchemaRow, error)
- func (q *Queries) GetDefaultPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDefaultPrivilegesForSchemaRow, error)
- func (q *Queries) GetDomainConstraints(ctx context.Context) ([]GetDomainConstraintsRow, error)
- func (q *Queries) GetDomainConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDomainConstraintsForSchemaRow, error)
- func (q *Queries) GetDomains(ctx context.Context) ([]GetDomainsRow, error)
- func (q *Queries) GetDomainsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetDomainsForSchemaRow, error)
- func (q *Queries) GetEnumValues(ctx context.Context) ([]GetEnumValuesRow, error)
- func (q *Queries) GetEnumValuesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetEnumValuesForSchemaRow, error)
- func (q *Queries) GetFunctionDependencies(ctx context.Context, dollar_1 sql.NullString) ([]GetFunctionDependenciesRow, error)
- func (q *Queries) GetFunctions(ctx context.Context) ([]GetFunctionsRow, error)
- func (q *Queries) GetFunctionsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetFunctionsForSchemaRow, error)
- func (q *Queries) GetIndexes(ctx context.Context) ([]GetIndexesRow, error)
- func (q *Queries) GetIndexesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetIndexesForSchemaRow, error)
- func (q *Queries) GetInheritedPartitionConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetInheritedPartitionConstraintsForSchemaRow, error)
- func (q *Queries) GetPartitionChildren(ctx context.Context) ([]GetPartitionChildrenRow, error)
- func (q *Queries) GetPartitionParentColumnsForSchema(ctx context.Context, nspname string) ([]GetPartitionParentColumnsForSchemaRow, error)
- func (q *Queries) GetPartitionedTablesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetPartitionedTablesForSchemaRow, error)
- func (q *Queries) GetPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetPrivilegesForSchemaRow, error)
- func (q *Queries) GetProcedures(ctx context.Context) ([]GetProceduresRow, error)
- func (q *Queries) GetProceduresForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetProceduresForSchemaRow, error)
- func (q *Queries) GetRLSPolicies(ctx context.Context) ([]GetRLSPoliciesRow, error)
- func (q *Queries) GetRLSPoliciesForSchema(ctx context.Context, nspname string) ([]GetRLSPoliciesForSchemaRow, error)
- func (q *Queries) GetRLSTables(ctx context.Context) ([]GetRLSTablesRow, error)
- func (q *Queries) GetRLSTablesForSchema(ctx context.Context, nspname string) ([]GetRLSTablesForSchemaRow, error)
- func (q *Queries) GetRevokedDefaultPrivilegesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetRevokedDefaultPrivilegesForSchemaRow, error)
- func (q *Queries) GetSchema(ctx context.Context, schemaName sql.NullString) (interface{}, error)
- func (q *Queries) GetSchemas(ctx context.Context) ([]interface{}, error)
- func (q *Queries) GetSequences(ctx context.Context) ([]GetSequencesRow, error)
- func (q *Queries) GetSequencesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetSequencesForSchemaRow, error)
- func (q *Queries) GetTables(ctx context.Context) ([]GetTablesRow, error)
- func (q *Queries) GetTablesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTablesForSchemaRow, error)
- func (q *Queries) GetTriggers(ctx context.Context) ([]GetTriggersRow, error)
- func (q *Queries) GetTriggersForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTriggersForSchemaRow, error)
- func (q *Queries) GetTypes(ctx context.Context) ([]GetTypesRow, error)
- func (q *Queries) GetTypesForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetTypesForSchemaRow, error)
- func (q *Queries) GetViewDependencies(ctx context.Context) ([]GetViewDependenciesRow, error)
- func (q *Queries) GetViews(ctx context.Context) ([]GetViewsRow, error)
- func (q *Queries) GetViewsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetViewsForSchemaRow, error)
- func (q *Queries) WithTx(tx *sql.Tx) *Queries
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
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"`
MatchFull sql.NullBool `db:"match_full" json:"match_full"`
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"`
MatchFull sql.NullBool `db:"match_full" json:"match_full"`
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 GetEnumValuesRow ¶
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 GetInheritedPartitionConstraintsForSchemaRow ¶ added in v1.13.4
type GetInheritedPartitionConstraintsForSchemaRow 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"`
ParentSchema string `db:"parent_schema" json:"parent_schema"`
ParentTable string `db:"parent_table" json:"parent_table"`
ParentConstraintName string `db:"parent_constraint_name" json:"parent_constraint_name"`
}
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 GetRLSTablesRow ¶
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 (*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) GetInheritedPartitionConstraintsForSchema ¶ added in v1.13.4
func (q *Queries) GetInheritedPartitionConstraintsForSchema(ctx context.Context, dollar_1 sql.NullString) ([]GetInheritedPartitionConstraintsForSchemaRow, error)
GetInheritedPartitionConstraintsForSchema lists the PRIMARY KEY and UNIQUE constraints PostgreSQL copied onto partitions from their parent's constraints (conparentid != 0), with the parent constraint each one derives from. GetConstraintsForSchema skips these copies because PARTITION OF recreates them, but their catalog names are needed to recreate them explicitly when a generated name would otherwise take a standalone index's name (issue #653).
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:
- set_config sets search_path to only the table's own schema
- 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) GetSchemas ¶
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):
- set_config sets search_path to only the trigger's own schema
- 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