queries

package
v0.0.0-...-d56b225 Latest Latest
Warning

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

 Go to latest Published: Oct 25, 2025 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"`
	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 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 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"`
	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"`
	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"`
	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"`
	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"`
}

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"`
	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"`
}

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 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"`
	Proargmodes       []string       `db:"proargmodes" json:"proargmodes"`
	Proargnames       []string       `db:"proargnames" json:"proargnames"`
	Proallargtypes    []string       `db:"proallargtypes" json:"proallargtypes"`
}

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"`
	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"`
	NumColumns        int16          `db:"num_columns" json:"num_columns"`
	ColumnDefinitions []string       `db:"column_definitions" json:"column_definitions"`
	ColumnDirections  []string       `db:"column_directions" json:"column_directions"`
}

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 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 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 sql.NullString `db:"schemaname" json:"schemaname"`
	Tablename  sql.NullString `db:"tablename" json:"tablename"`
	Policyname sql.NullString `db:"policyname" json:"policyname"`
	Permissive sql.NullString `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 sql.NullString `db:"schemaname" json:"schemaname"`
	Tablename  sql.NullString `db:"tablename" json:"tablename"`
	Policyname sql.NullString `db:"policyname" json:"policyname"`
	Permissive sql.NullString `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 sql.NullString `db:"schemaname" json:"schemaname"`
	Tablename  sql.NullString `db:"tablename" json:"tablename"`
}

type GetRLSTablesRow 

type GetRLSTablesRow struct {
	Schemaname sql.NullString `db:"schemaname" json:"schemaname"`
	Tablename  sql.NullString `db:"tablename" json:"tablename"`
}

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"`
}

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"`
}

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"`
}

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"`
}

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

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, dollar_1 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) 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) 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

func (*Queries) GetIndexesForSchema 

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

GetIndexesForSchema retrieves all indexes for a specific schema

func (*Queries) GetPartitionChildren 

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

GetPartitionChildren retrieves partition child tables and their attachment information

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) 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

func (*Queries) GetRLSPoliciesForSchema 

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

GetRLSPoliciesForSchema retrieves all row level security policies for a specific schema

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, dollar_1 sql.NullString) ([]GetRLSTablesForSchemaRow, error)

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

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)

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 Method 1: Try to find dependency relationship (for proper SERIAL columns) Method 2: Find sequences used in column defaults (for nextval() patterns)

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

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

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.