queries

package

Go to main page

Versions in this module

v1

v1.9.0

Apr 7, 2026

Changes in this version

type GetConstraintsForSchemaRow

+ NoInherit bool

type GetConstraintsRow

+ NoInherit bool

type GetIndexesForSchemaRow

+ IncludeColumns []string

+ NumKeyColumns int16

v1.8.0

Mar 26, 2026

v1.7.5

Mar 26, 2026

Changes in this version

type GetConstraintsForSchemaRow

+ IsPeriod bool

type GetConstraintsRow

+ IsPeriod bool

v1.7.4

Mar 8, 2026

Changes in this version

type GetViewsForSchemaRow

+ Reloptions []string

v1.7.3

Feb 28, 2026

v1.7.2

Feb 20, 2026

v1.7.1

Feb 16, 2026

Changes in this version

type GetConstraintsForSchemaRow

+ ExclusionDefinition sql.NullString

type GetConstraintsRow

+ ExclusionDefinition sql.NullString

v1.7.0

Feb 9, 2026

Changes in this version

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type GetAggregatesForSchemaRow struct

+ AggregateArguments sql.NullString

+ AggregateComment sql.NullString

+ AggregateName string

+ AggregateReturnType sql.NullString

+ AggregateSchema string

+ AggregateSignature sql.NullString

+ FinalFunction sql.NullString

+ FinalFunctionSchema sql.NullString

+ InitialCondition sql.NullString

+ StateType sql.NullString

+ TransitionFunction sql.NullString

+ TransitionFunctionSchema sql.NullString

+ type GetAggregatesRow struct

+ AggregateArguments sql.NullString

+ AggregateComment sql.NullString

+ AggregateName string

+ AggregateReturnType sql.NullString

+ AggregateSchema string

+ AggregateSignature sql.NullString

+ FinalFunction sql.NullString

+ FinalFunctionSchema sql.NullString

+ InitialCondition sql.NullString

+ StateType sql.NullString

+ TransitionFunction sql.NullString

+ TransitionFunctionSchema sql.NullString

+ type GetColumnPrivilegesForSchemaRow struct

+ ColumnName string

+ GranteeOid interface{}

+ IsGrantable sql.NullBool

+ PrivilegeType sql.NullString

+ TableName string

+ type GetColumnsForSchemaRow struct

+ Attgenerated interface{}

+ CharacterMaximumLength interface{}

+ ColumnComment sql.NullString

+ ColumnDefault sql.NullString

+ ColumnName interface{}

+ DataType interface{}

+ GeneratedExpr sql.NullString

+ IdentityCycle interface{}

+ IdentityGeneration interface{}

+ IdentityIncrement interface{}

+ IdentityMaximum interface{}

+ IdentityMinimum interface{}

+ IdentityStart interface{}

+ IsIdentity interface{}

+ IsNullable interface{}

+ NumericPrecision interface{}

+ NumericScale interface{}

+ OrdinalPosition interface{}

+ ResolvedType sql.NullString

+ TableName interface{}

+ TableSchema interface{}

+ UdtName interface{}

+ type GetColumnsRow struct

+ Attgenerated interface{}

+ CharacterMaximumLength interface{}

+ ColumnComment sql.NullString

+ ColumnDefault sql.NullString

+ ColumnName interface{}

+ DataType interface{}

+ GeneratedExpr sql.NullString

+ IdentityCycle interface{}

+ IdentityGeneration interface{}

+ IdentityIncrement interface{}

+ IdentityMaximum interface{}

+ IdentityMinimum interface{}

+ IdentityStart interface{}

+ IsIdentity interface{}

+ IsNullable interface{}

+ NumericPrecision interface{}

+ NumericScale interface{}

+ OrdinalPosition interface{}

+ ResolvedType sql.NullString

+ TableName interface{}

+ TableSchema interface{}

+ UdtName interface{}

+ type GetCompositeTypeColumnsForSchemaRow struct

+ ColumnName string

+ ColumnPosition int16

+ ColumnType sql.NullString

+ TypeName string

+ TypeSchema string

+ type GetCompositeTypeColumnsRow struct

+ ColumnName string

+ ColumnPosition int16

+ ColumnType sql.NullString

+ TypeName string

+ TypeSchema string

+ type GetConstraintsForSchemaRow struct

+ CheckClause sql.NullString

+ ColumnName sql.NullString

+ ConstraintName string

+ ConstraintType sql.NullString

+ Deferrable bool

+ DeleteRule sql.NullString

+ ForeignColumnName sql.NullString

+ ForeignOrdinalPosition sql.NullInt32

+ ForeignTableName sql.NullString

+ ForeignTableSchema sql.NullString

+ InitiallyDeferred bool

+ IsValid bool

+ OrdinalPosition sql.NullInt32

+ TableName string

+ TableSchema string

+ UpdateRule sql.NullString

+ type GetConstraintsRow struct

+ CheckClause sql.NullString

+ ColumnName sql.NullString

+ ConstraintName string

+ ConstraintType sql.NullString

+ Deferrable bool

+ DeleteRule sql.NullString

+ ForeignColumnName sql.NullString

+ ForeignOrdinalPosition sql.NullInt32

+ ForeignTableName sql.NullString

+ ForeignTableSchema sql.NullString

+ InitiallyDeferred bool

+ IsValid bool

+ OrdinalPosition sql.NullInt32

+ TableName string

+ TableSchema string

+ UpdateRule sql.NullString

+ type GetDefaultPrivilegesForSchemaRow struct

+ Grantee sql.NullString

+ IsGrantable sql.NullBool

+ ObjectType sql.NullString

+ OwnerRole sql.NullString

+ PrivilegeType sql.NullString

+ type GetDomainConstraintsForSchemaRow struct

+ ConstraintDefinition sql.NullString

+ ConstraintName string

+ DomainName string

+ DomainSchema string

+ type GetDomainConstraintsRow struct

+ ConstraintDefinition sql.NullString

+ ConstraintName string

+ DomainName string

+ DomainSchema string

+ type GetDomainsForSchemaRow struct

+ BaseType sql.NullString

+ DefaultValue sql.NullString

+ DomainComment sql.NullString

+ DomainName string

+ DomainSchema string

+ NotNull bool

+ type GetDomainsRow struct

+ BaseType sql.NullString

+ DefaultValue sql.NullString

+ DomainComment sql.NullString

+ DomainName string

+ DomainSchema string

+ NotNull bool

+ type GetEnumValuesForSchemaRow struct

+ EnumOrder float32

+ EnumValue string

+ TypeName string

+ TypeSchema string

+ type GetEnumValuesRow struct

+ EnumOrder float32

+ EnumValue string

+ TypeName string

+ TypeSchema string

+ type GetFunctionDependenciesRow struct

+ DependentArgs sql.NullString

+ DependentName string

+ DependentSchema string

+ ReferencedArgs sql.NullString

+ ReferencedName string

+ ReferencedSchema string

+ type GetFunctionsForSchemaRow struct

+ DataType sql.NullString

+ ExternalLanguage interface{}

+ FunctionArguments sql.NullString

+ FunctionComment sql.NullString

+ FunctionSignature sql.NullString

+ IsLeakproof bool

+ IsSecurityDefiner bool

+ IsStrict bool

+ ParallelMode interface{}

+ RoutineDefinition sql.NullString

+ RoutineName interface{}

+ RoutineSchema interface{}

+ RoutineType interface{}

+ SearchPath sql.NullString

+ Volatility sql.NullString

+ type GetFunctionsRow struct

+ DataType sql.NullString

+ ExternalLanguage interface{}

+ FunctionArguments sql.NullString

+ FunctionComment sql.NullString

+ FunctionSignature sql.NullString

+ IsSecurityDefiner bool

+ IsStrict bool

+ RoutineDefinition string

+ RoutineName interface{}

+ RoutineSchema interface{}

+ RoutineType interface{}

+ Volatility sql.NullString

+ type GetIndexesForSchemaRow struct

+ ColumnDefinitions []string

+ ColumnDirections []string

+ ColumnOpclasses []string

+ HasExpressions sql.NullBool

+ IndexComment sql.NullString

+ Indexdef sql.NullString

+ Indexname string

+ IsPartial sql.NullBool

+ IsPrimary bool

+ IsUnique bool

+ Method string

+ NumColumns int16

+ PartialPredicate sql.NullString

+ Schemaname string

+ Tablename string

+ type GetIndexesRow struct

+ HasExpressions sql.NullBool

+ Indexdef sql.NullString

+ Indexname string

+ IsPartial sql.NullBool

+ IsPrimary bool

+ IsUnique bool

+ Method string

+ PartialPredicate sql.NullString

+ Schemaname string

+ Tablename string

+ type GetPartitionChildrenRow struct

+ ChildSchema string

+ ChildTable string

+ ParentSchema string

+ ParentTable string

+ PartitionBound sql.NullString

+ type GetPartitionedTablesForSchemaRow struct

+ PartitionKey sql.NullString

+ PartitionStrategy sql.NullString

+ TableName string

+ TableSchema string

+ type GetPrivilegesForSchemaRow struct

+ GranteeOid interface{}

+ IsGrantable sql.NullBool

+ ObjectName sql.NullString

+ ObjectType sql.NullString

+ Owner sql.NullString

+ PrivilegeType sql.NullString

+ SchemaName sql.NullString

+ type GetProceduresForSchemaRow struct

+ ExternalLanguage interface{}

+ ProcedureArguments sql.NullString

+ ProcedureComment sql.NullString

+ ProcedureSignature sql.NullString

+ RoutineDefinition sql.NullString

+ RoutineName interface{}

+ RoutineSchema interface{}

+ RoutineType interface{}

+ type GetProceduresRow struct

+ ExternalLanguage interface{}

+ ProcedureArguments sql.NullString

+ ProcedureComment sql.NullString

+ ProcedureSignature sql.NullString

+ RoutineDefinition string

+ RoutineName interface{}

+ RoutineSchema interface{}

+ RoutineType interface{}

+ type GetRLSPoliciesForSchemaRow struct

+ Cmd sql.NullString

+ Permissive sql.NullString

+ Policyname sql.NullString

+ Qual sql.NullString

+ Roles []string

+ Schemaname sql.NullString

+ Tablename sql.NullString

+ WithCheck sql.NullString

+ type GetRLSPoliciesRow struct

+ Cmd sql.NullString

+ Permissive sql.NullString

+ Policyname sql.NullString

+ Qual sql.NullString

+ Roles []string

+ Schemaname sql.NullString

+ Tablename sql.NullString

+ WithCheck sql.NullString

+ type GetRLSTablesForSchemaRow struct

+ Rowforced bool

+ Rowsecurity bool

+ Schemaname string

+ Tablename string

+ type GetRLSTablesRow struct

+ Rowforced bool

+ Rowsecurity bool

+ Schemaname string

+ Tablename string

+ type GetRevokedDefaultPrivilegesForSchemaRow struct

+ ObjectName sql.NullString

+ ObjectType sql.NullString

+ type GetSequencesForSchemaRow struct

+ CacheSize sql.NullInt64

+ CycleOption sql.NullBool

+ DataType interface{}

+ Increment sql.NullInt64

+ MaximumValue sql.NullInt64

+ MinimumValue sql.NullInt64

+ OwnedByColumn sql.NullString

+ OwnedByTable sql.NullString

+ SequenceName sql.NullString

+ SequenceSchema sql.NullString

+ StartValue sql.NullInt64

+ type GetSequencesRow struct

+ CycleOption interface{}

+ DataType interface{}

+ Increment interface{}

+ MaximumValue interface{}

+ MinimumValue interface{}

+ SequenceName interface{}

+ SequenceSchema interface{}

+ StartValue interface{}

+ type GetTablesForSchemaRow struct

+ TableComment sql.NullString

+ TableName interface{}

+ TableSchema interface{}

+ TableType interface{}

+ type GetTablesRow struct

+ TableComment sql.NullString

+ TableName interface{}

+ TableSchema interface{}

+ TableType interface{}

+ type GetTriggersForSchemaRow struct

+ EventObjectTable string

+ FunctionName string

+ FunctionSchema string

+ NewTable sql.NullString

+ OldTable sql.NullString

+ TriggerComment sql.NullString

+ TriggerConstraintOid interface{}

+ TriggerDeferrable bool

+ TriggerDefinition sql.NullString

+ TriggerEnabled interface{}

+ TriggerInitdeferred bool

+ TriggerName string

+ TriggerSchema string

+ TriggerType int16

+ type GetTriggersRow struct

+ ActionCondition interface{}

+ ActionOrientation interface{}

+ ActionStatement interface{}

+ ActionTiming interface{}

+ EventManipulation interface{}

+ EventObjectTable interface{}

+ TriggerName interface{}

+ TriggerSchema interface{}

+ type GetTypesForSchemaRow struct

+ TypeComment sql.NullString

+ TypeKind sql.NullString

+ TypeName string

+ TypeSchema string

+ type GetTypesRow struct

+ TypeComment sql.NullString

+ TypeKind sql.NullString

+ TypeName string

+ TypeSchema string

+ type GetViewDependenciesRow struct

+ DependentName interface{}

+ DependentSchema interface{}

+ SourceName interface{}

+ SourceSchema interface{}

+ type GetViewsForSchemaRow struct

+ IsMaterialized sql.NullBool

+ TableName string

+ TableSchema string

+ ViewComment sql.NullString

+ ViewDefinition sql.NullString

+ type GetViewsRow struct

+ IsMaterialized sql.NullBool

+ TableName string

+ TableSchema string

+ ViewComment sql.NullString

+ ViewDefinition sql.NullString

+ type Queries struct

+ func New(db DBTX) *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) GetPartitionChildren(ctx context.Context) ([]GetPartitionChildrenRow, 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, dollar_1 sql.NullString) ([]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

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