queries

Jan 7, 2026

Changes in this version

+ type GetTablePrivilegesRow struct

+ Grantee string

+ IsGrantable interface{}

+ PaTableName string

+ PaTableSchemaName string

+ Privilege string

type Queries

+ func (q *Queries) GetTablePrivileges(ctx context.Context) ([]GetTablePrivilegesRow, error)

Dec 31, 2025

Changes in this version

type GetColumnsForTableRow

+ HasMissingValOptimization bool

type GetIndexesRow

+ OwningTableRelkind string

Sep 1, 2025

Changes in this version

type GetColumnsForTableRow

+ GenerationExpression string

+ IsGenerated bool

Aug 25, 2025

Changes in this version

+ type GetMaterializedViewsRow struct

+ RelOptions []string

+ SchemaName string

+ TableDependencies []string

+ TablespaceName string

+ ViewDefinition string

+ ViewName string

type Queries

+ func (q *Queries) GetMaterializedViews(ctx context.Context) ([]GetMaterializedViewsRow, error)

Aug 11, 2025

Changes in this version

+ type GetViewsRow struct

+ RelOptions []string

+ SchemaName string

+ TableDependencies []string

+ ViewDefinition string

+ ViewName string

type Queries

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

Jul 20, 2025

Changes in this version

type GetTriggersRow

+ IsConstraint bool

Feb 11, 2025

Changes in this version

+ type GetProcsRow struct

+ FuncDef string

+ FuncIdentityArguments string

+ FuncLang string

+ FuncName string

+ FuncSchemaName string

+ Oid interface{}

type Queries

+ func (q *Queries) GetProcs(ctx context.Context, prokind interface{}) ([]GetProcsRow, error)

Oct 2, 2024

Changes in this version

type GetColumnsForTableRow

+ CacheSize sql.NullInt64

+ IdentityType string

+ IncrementValue sql.NullInt64

+ IsCycle sql.NullBool

+ MaxValue sql.NullInt64

+ MinValue sql.NullInt64

+ StartValue sql.NullInt64

type GetIndexesRow

+ ColumnNames []string

May 29, 2024

Changes in this version

+ type GetEnumsRow struct

+ EnumLabels []string

+ EnumName string

+ EnumSchemaName string

+ type GetPoliciesRow struct

+ AppliesTo []string

+ CheckExpression string

+ Cmd string

+ ColumnNames []string

+ IsPermissive bool

+ OwningTableName string

+ OwningTableSchemaName string

+ PolicyName string

+ UsingExpression string

type GetTablesRow

+ RlsEnabled bool

+ RlsForced bool

type Queries

+ func (q *Queries) GetEnums(ctx context.Context) ([]GetEnumsRow, error)

+ func (q *Queries) GetPolicies(ctx context.Context) ([]GetPoliciesRow, error)

Feb 8, 2024

Changes in this version

type GetCheckConstraintsRow

+ TableSchemaName string

type GetIndexesRow

+ TableSchemaName string

type GetTablesRow

+ TableSchemaName string

type Queries

+ func (q *Queries) GetSchemas(ctx context.Context) ([]string, error)

Jan 11, 2024

Changes in this version

type GetCheckConstraintsRow

+ ColumnNames []string

Oct 25, 2023

Changes in this version

type GetIndexesRow

+ ConstraintDef string

+ ConstraintIsLocal bool

+ ConstraintType string

type GetTablesRow

+ ReplicaIdentity string

Aug 10, 2023

Changes in this version

type GetCheckConstraintsRow

+ ConstraintExpression string

+ ConstraintName string

+ type GetExtensionsRow struct

+ ExtensionName string

+ ExtensionVersion string

+ Oid interface{}

+ SchemaName string

+ type GetForeignKeyConstraintsRow struct

+ ConstraintDef string

+ ConstraintName string

+ ForeignTableName string

+ ForeignTableSchemaName string

+ IsValid bool

+ OwningTableName string

+ OwningTableSchemaName string

type GetSequencesRow

+ DataType string

+ IncrementValue int64

+ IsCycle bool

type Queries

+ func (q *Queries) GetExtensions(ctx context.Context) ([]GetExtensionsRow, error)

+ func (q *Queries) GetForeignKeyConstraints(ctx context.Context) ([]GetForeignKeyConstraintsRow, error)

Jul 7, 2023

Changes in this version

+ type GetDependsOnFunctionsParams struct

+ ObjectID interface{}

+ SystemCatalog interface{}

+ type GetSequencesRow struct

+ CacheSize int64

+ Cycle bool

+ Increment int64

+ MaxValue int64

+ MinValue int64

+ OwnerColumnName string

+ OwnerSchemaName string

+ OwnerTableName string

+ SequenceName string

+ SequenceSchemaName string

+ StartValue int64

+ Type string

type Queries

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

Jun 2, 2023

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 GetCheckConstraintsRow struct

+ Expression string

+ IsNotInheritable bool

+ IsValid bool

+ Name string

+ Oid interface{}

+ TableName string

+ type GetColumnsForTableRow struct

+ CollationName string

+ CollationSchemaName string

+ ColumnName string

+ ColumnSize int16

+ ColumnType string

+ DefaultValue string

+ IsNotNull bool

+ type GetDependsOnFunctionsRow struct

+ FuncIdentityArguments string

+ FuncName string

+ FuncSchemaName string

+ type GetFunctionsRow struct

+ FuncDef string

+ FuncIdentityArguments string

+ FuncLang string

+ FuncName string

+ FuncSchemaName string

+ Oid interface{}

+ type GetIndexesRow struct

+ ConstraintName string

+ DefStmt string

+ IndexIsPk bool

+ IndexIsUnique bool

+ IndexIsValid bool

+ IndexName string

+ Oid interface{}

+ ParentIndexName string

+ ParentIndexSchemaName string

+ TableName string

+ type GetTablesRow struct

+ Oid interface{}

+ ParentTableName string

+ ParentTableSchemaName string

+ PartitionForValues string

+ PartitionKeyDef string

+ TableName string

+ type GetTriggersRow struct

+ FuncIdentityArguments string

+ FuncName string

+ FuncSchemaName string

+ OwningTableName string

+ OwningTableSchemaName string

+ TriggerDef string

+ TriggerName string

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) GetCheckConstraints(ctx context.Context) ([]GetCheckConstraintsRow, error)

+ func (q *Queries) GetColumnsForIndex(ctx context.Context, attrelid interface{}) ([]string, error)

+ func (q *Queries) GetColumnsForTable(ctx context.Context, attrelid interface{}) ([]GetColumnsForTableRow, error)

+ func (q *Queries) GetDependsOnFunctions(ctx context.Context, objid interface{}) ([]GetDependsOnFunctionsRow, error)

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

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

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

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

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