ischema

package

v1.2.0 Latest Latest Go to latest Published: Dec 9, 2018 License: MIT Imports: 8 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/TrueLevelSA/gendal

Links

Open Source Insights

Documentation ¶

Overview ¶

Package ischema contains the types for schema 'information_schema'.

Index ¶

Variables
func PgCharMaxLength(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgCharOctetLength(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgDatetimePrecision(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgExpandarray(db XODB, v0 pgtypes.Anyarray) ([]pgtypes.Record, error)
func PgIndexPosition(db XODB, v0 pgtypes.Oid, v1 int16) (int, error)
func PgIntervalType(db XODB, v0 pgtypes.Oid, v1 int) (string, error)
func PgKeysequal(db XODB, v0 []int16, v1 []int16) (bool, error)
func PgNumericPrecision(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgNumericPrecisionRadix(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgNumericScale(db XODB, v0 pgtypes.Oid, v1 int) (int, error)
func PgTruetypid(db XODB, v0 pgtypes.PgAttribute, v1 pgtypes.PgType) (pgtypes.Oid, error)
func PgTruetypmod(db XODB, v0 pgtypes.PgAttribute, v1 pgtypes.PgType) (int, error)
type AdministrableRoleAuthorization
type ApplicableRole
type Attribute
type CharacterSet
type CheckConstraint
type CheckConstraintRoutineUsage
type Collation
type CollationCharacterSetApplicability
type Column
type ColumnDomainUsage
type ColumnOption
type ColumnPrivilege
type ColumnUdtUsage
type ConstraintColumnUsage
type ConstraintTableUsage
type DataTypePrivilege
type Domain
type DomainConstraint
type DomainUdtUsage
type ElementType
type EnabledRole
type ForeignDataWrapper
type ForeignDataWrapperOption
type ForeignServer
type ForeignServerOption
type ForeignTable
type ForeignTableOption
type InformationSchemaCatalogName
type KeyColumnUsage
type Parameter
type PgForeignDataWrapper
type PgForeignServer
type PgForeignTable
type PgForeignTableColumn
type PgUserMapping
type ReferentialConstraint
type RoleColumnGrant
type RoleRoutineGrant
type RoleTableGrant
type RoleUdtGrant
type RoleUsageGrant
type Routine
type RoutinePrivilege
type SQLFeature
type SQLImplementationInfo
type SQLLanguage
type SQLPackage
type SQLPart
type SQLSizing
type SQLSizingProfile
type ScannerValuer
type Schematum
type Sequence
type Slice
type StringSlice
- func (ss *StringSlice) Scan(src interface{}) error
- func (ss StringSlice) Value() (driver.Value, error)
type Table
type TableConstraint
type TablePrivilege
type Transform
type Trigger
type TriggeredUpdateColumn
type UdtPrivilege
type UsagePrivilege
type UserDefinedType
type UserMapping
type UserMappingOption
type View
type ViewColumnUsage
type ViewRoutineUsage
type ViewTableUsage
type XODB

Constants ¶

This section is empty.

Variables ¶

View Source

var XOLog = func(string, ...interface{}) {}

XOLog provides the log func used by generated queries.

Functions ¶

func PgCharMaxLength ¶

func PgCharMaxLength(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgCharMaxLength calls the stored procedure 'information_schema._pg_char_max_length(oid, integer) integer' on db.

func PgCharOctetLength ¶

func PgCharOctetLength(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgCharOctetLength calls the stored procedure 'information_schema._pg_char_octet_length(oid, integer) integer' on db.

func PgDatetimePrecision ¶

func PgDatetimePrecision(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgDatetimePrecision calls the stored procedure 'information_schema._pg_datetime_precision(oid, integer) integer' on db.

func PgExpandarray ¶

func PgExpandarray(db XODB, v0 pgtypes.Anyarray) ([]pgtypes.Record, error)

PgExpandarray calls the stored procedure 'information_schema._pg_expandarray(anyarray) SETOF record' on db.

func PgIndexPosition ¶

func PgIndexPosition(db XODB, v0 pgtypes.Oid, v1 int16) (int, error)

PgIndexPosition calls the stored procedure 'information_schema._pg_index_position(oid, smallint) integer' on db.

func PgIntervalType ¶

func PgIntervalType(db XODB, v0 pgtypes.Oid, v1 int) (string, error)

PgIntervalType calls the stored procedure 'information_schema._pg_interval_type(oid, integer) text' on db.

func PgKeysequal ¶

func PgKeysequal(db XODB, v0 []int16, v1 []int16) (bool, error)

PgKeysequal calls the stored procedure 'information_schema._pg_keysequal(smallint[], smallint[]) boolean' on db.

func PgNumericPrecision ¶

func PgNumericPrecision(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgNumericPrecision calls the stored procedure 'information_schema._pg_numeric_precision(oid, integer) integer' on db.

func PgNumericPrecisionRadix ¶

func PgNumericPrecisionRadix(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgNumericPrecisionRadix calls the stored procedure 'information_schema._pg_numeric_precision_radix(oid, integer) integer' on db.

func PgNumericScale ¶

func PgNumericScale(db XODB, v0 pgtypes.Oid, v1 int) (int, error)

PgNumericScale calls the stored procedure 'information_schema._pg_numeric_scale(oid, integer) integer' on db.

func PgTruetypid ¶

func PgTruetypid(db XODB, v0 pgtypes.PgAttribute, v1 pgtypes.PgType) (pgtypes.Oid, error)

PgTruetypid calls the stored procedure 'information_schema._pg_truetypid(pg_attribute, pg_type) oid' on db.

func PgTruetypmod ¶

func PgTruetypmod(db XODB, v0 pgtypes.PgAttribute, v1 pgtypes.PgType) (int, error)

PgTruetypmod calls the stored procedure 'information_schema._pg_truetypmod(pg_attribute, pg_type) integer' on db.

Types ¶

type AdministrableRoleAuthorization ¶

type AdministrableRoleAuthorization struct {
	Grantee     pgtypes.SQLIdentifier `json:"grantee"`      // grantee
	RoleName    pgtypes.SQLIdentifier `json:"role_name"`    // role_name
	IsGrantable pgtypes.YesOrNo       `json:"is_grantable"` // is_grantable
}

AdministrableRoleAuthorization represents a row from 'information_schema.administrable_role_authorizations'.

type ApplicableRole ¶

type ApplicableRole struct {
	Grantee     pgtypes.SQLIdentifier `json:"grantee"`      // grantee
	RoleName    pgtypes.SQLIdentifier `json:"role_name"`    // role_name
	IsGrantable pgtypes.YesOrNo       `json:"is_grantable"` // is_grantable
}

ApplicableRole represents a row from 'information_schema.applicable_roles'.

type Attribute ¶

type Attribute struct {
	UdtCatalog                  pgtypes.SQLIdentifier  `json:"udt_catalog"`                    // udt_catalog
	UdtSchema                   pgtypes.SQLIdentifier  `json:"udt_schema"`                     // udt_schema
	UdtName                     pgtypes.SQLIdentifier  `json:"udt_name"`                       // udt_name
	AttributeName               pgtypes.SQLIdentifier  `json:"attribute_name"`                 // attribute_name
	OrdinalPosition             pgtypes.CardinalNumber `json:"ordinal_position"`               // ordinal_position
	AttributeDefault            pgtypes.CharacterData  `json:"attribute_default"`              // attribute_default
	IsNullable                  pgtypes.YesOrNo        `json:"is_nullable"`                    // is_nullable
	DataType                    pgtypes.CharacterData  `json:"data_type"`                      // data_type
	CharacterMaximumLength      pgtypes.CardinalNumber `json:"character_maximum_length"`       // character_maximum_length
	CharacterOctetLength        pgtypes.CardinalNumber `json:"character_octet_length"`         // character_octet_length
	CharacterSetCatalog         pgtypes.SQLIdentifier  `json:"character_set_catalog"`          // character_set_catalog
	CharacterSetSchema          pgtypes.SQLIdentifier  `json:"character_set_schema"`           // character_set_schema
	CharacterSetName            pgtypes.SQLIdentifier  `json:"character_set_name"`             // character_set_name
	CollationCatalog            pgtypes.SQLIdentifier  `json:"collation_catalog"`              // collation_catalog
	CollationSchema             pgtypes.SQLIdentifier  `json:"collation_schema"`               // collation_schema
	CollationName               pgtypes.SQLIdentifier  `json:"collation_name"`                 // collation_name
	NumericPrecision            pgtypes.CardinalNumber `json:"numeric_precision"`              // numeric_precision
	NumericPrecisionRadix       pgtypes.CardinalNumber `json:"numeric_precision_radix"`        // numeric_precision_radix
	NumericScale                pgtypes.CardinalNumber `json:"numeric_scale"`                  // numeric_scale
	DatetimePrecision           pgtypes.CardinalNumber `json:"datetime_precision"`             // datetime_precision
	IntervalType                pgtypes.CharacterData  `json:"interval_type"`                  // interval_type
	IntervalPrecision           pgtypes.CardinalNumber `json:"interval_precision"`             // interval_precision
	AttributeUdtCatalog         pgtypes.SQLIdentifier  `json:"attribute_udt_catalog"`          // attribute_udt_catalog
	AttributeUdtSchema          pgtypes.SQLIdentifier  `json:"attribute_udt_schema"`           // attribute_udt_schema
	AttributeUdtName            pgtypes.SQLIdentifier  `json:"attribute_udt_name"`             // attribute_udt_name
	ScopeCatalog                pgtypes.SQLIdentifier  `json:"scope_catalog"`                  // scope_catalog
	ScopeSchema                 pgtypes.SQLIdentifier  `json:"scope_schema"`                   // scope_schema
	ScopeName                   pgtypes.SQLIdentifier  `json:"scope_name"`                     // scope_name
	MaximumCardinality          pgtypes.CardinalNumber `json:"maximum_cardinality"`            // maximum_cardinality
	DtdIdentifier               pgtypes.SQLIdentifier  `json:"dtd_identifier"`                 // dtd_identifier
	IsDerivedReferenceAttribute pgtypes.YesOrNo        `json:"is_derived_reference_attribute"` // is_derived_reference_attribute
}

Attribute represents a row from 'information_schema.attributes'.

type CharacterSet ¶

type CharacterSet struct {
	CharacterSetCatalog   pgtypes.SQLIdentifier `json:"character_set_catalog"`   // character_set_catalog
	CharacterSetSchema    pgtypes.SQLIdentifier `json:"character_set_schema"`    // character_set_schema
	CharacterSetName      pgtypes.SQLIdentifier `json:"character_set_name"`      // character_set_name
	CharacterRepertoire   pgtypes.SQLIdentifier `json:"character_repertoire"`    // character_repertoire
	FormOfUse             pgtypes.SQLIdentifier `json:"form_of_use"`             // form_of_use
	DefaultCollateCatalog pgtypes.SQLIdentifier `json:"default_collate_catalog"` // default_collate_catalog
	DefaultCollateSchema  pgtypes.SQLIdentifier `json:"default_collate_schema"`  // default_collate_schema
	DefaultCollateName    pgtypes.SQLIdentifier `json:"default_collate_name"`    // default_collate_name
}

CharacterSet represents a row from 'information_schema.character_sets'.

type CheckConstraint ¶

type CheckConstraint struct {
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
	CheckClause       pgtypes.CharacterData `json:"check_clause"`       // check_clause
}

CheckConstraint represents a row from 'information_schema.check_constraints'.

type CheckConstraintRoutineUsage ¶

type CheckConstraintRoutineUsage struct {
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
	SpecificCatalog   pgtypes.SQLIdentifier `json:"specific_catalog"`   // specific_catalog
	SpecificSchema    pgtypes.SQLIdentifier `json:"specific_schema"`    // specific_schema
	SpecificName      pgtypes.SQLIdentifier `json:"specific_name"`      // specific_name
}

CheckConstraintRoutineUsage represents a row from 'information_schema.check_constraint_routine_usage'.

type Collation ¶

type Collation struct {
	CollationCatalog pgtypes.SQLIdentifier `json:"collation_catalog"` // collation_catalog
	CollationSchema  pgtypes.SQLIdentifier `json:"collation_schema"`  // collation_schema
	CollationName    pgtypes.SQLIdentifier `json:"collation_name"`    // collation_name
	PadAttribute     pgtypes.CharacterData `json:"pad_attribute"`     // pad_attribute
}

Collation represents a row from 'information_schema.collations'.

type CollationCharacterSetApplicability ¶

type CollationCharacterSetApplicability struct {
	CollationCatalog    pgtypes.SQLIdentifier `json:"collation_catalog"`     // collation_catalog
	CollationSchema     pgtypes.SQLIdentifier `json:"collation_schema"`      // collation_schema
	CollationName       pgtypes.SQLIdentifier `json:"collation_name"`        // collation_name
	CharacterSetCatalog pgtypes.SQLIdentifier `json:"character_set_catalog"` // character_set_catalog
	CharacterSetSchema  pgtypes.SQLIdentifier `json:"character_set_schema"`  // character_set_schema
	CharacterSetName    pgtypes.SQLIdentifier `json:"character_set_name"`    // character_set_name
}

CollationCharacterSetApplicability represents a row from 'information_schema.collation_character_set_applicability'.

type Column ¶

type Column struct {
	TableCatalog           pgtypes.SQLIdentifier  `json:"table_catalog"`            // table_catalog
	TableSchema            pgtypes.SQLIdentifier  `json:"table_schema"`             // table_schema
	TableName              pgtypes.SQLIdentifier  `json:"table_name"`               // table_name
	ColumnName             pgtypes.SQLIdentifier  `json:"column_name"`              // column_name
	OrdinalPosition        pgtypes.CardinalNumber `json:"ordinal_position"`         // ordinal_position
	ColumnDefault          pgtypes.CharacterData  `json:"column_default"`           // column_default
	IsNullable             pgtypes.YesOrNo        `json:"is_nullable"`              // is_nullable
	DataType               pgtypes.CharacterData  `json:"data_type"`                // data_type
	CharacterMaximumLength pgtypes.CardinalNumber `json:"character_maximum_length"` // character_maximum_length
	CharacterOctetLength   pgtypes.CardinalNumber `json:"character_octet_length"`   // character_octet_length
	NumericPrecision       pgtypes.CardinalNumber `json:"numeric_precision"`        // numeric_precision
	NumericPrecisionRadix  pgtypes.CardinalNumber `json:"numeric_precision_radix"`  // numeric_precision_radix
	NumericScale           pgtypes.CardinalNumber `json:"numeric_scale"`            // numeric_scale
	DatetimePrecision      pgtypes.CardinalNumber `json:"datetime_precision"`       // datetime_precision
	IntervalType           pgtypes.CharacterData  `json:"interval_type"`            // interval_type
	IntervalPrecision      pgtypes.CardinalNumber `json:"interval_precision"`       // interval_precision
	CharacterSetCatalog    pgtypes.SQLIdentifier  `json:"character_set_catalog"`    // character_set_catalog
	CharacterSetSchema     pgtypes.SQLIdentifier  `json:"character_set_schema"`     // character_set_schema
	CharacterSetName       pgtypes.SQLIdentifier  `json:"character_set_name"`       // character_set_name
	CollationCatalog       pgtypes.SQLIdentifier  `json:"collation_catalog"`        // collation_catalog
	CollationSchema        pgtypes.SQLIdentifier  `json:"collation_schema"`         // collation_schema
	CollationName          pgtypes.SQLIdentifier  `json:"collation_name"`           // collation_name
	DomainCatalog          pgtypes.SQLIdentifier  `json:"domain_catalog"`           // domain_catalog
	DomainSchema           pgtypes.SQLIdentifier  `json:"domain_schema"`            // domain_schema
	DomainName             pgtypes.SQLIdentifier  `json:"domain_name"`              // domain_name
	UdtCatalog             pgtypes.SQLIdentifier  `json:"udt_catalog"`              // udt_catalog
	UdtSchema              pgtypes.SQLIdentifier  `json:"udt_schema"`               // udt_schema
	UdtName                pgtypes.SQLIdentifier  `json:"udt_name"`                 // udt_name
	ScopeCatalog           pgtypes.SQLIdentifier  `json:"scope_catalog"`            // scope_catalog
	ScopeSchema            pgtypes.SQLIdentifier  `json:"scope_schema"`             // scope_schema
	ScopeName              pgtypes.SQLIdentifier  `json:"scope_name"`               // scope_name
	MaximumCardinality     pgtypes.CardinalNumber `json:"maximum_cardinality"`      // maximum_cardinality
	DtdIdentifier          pgtypes.SQLIdentifier  `json:"dtd_identifier"`           // dtd_identifier
	IsSelfReferencing      pgtypes.YesOrNo        `json:"is_self_referencing"`      // is_self_referencing
	IsIdentity             pgtypes.YesOrNo        `json:"is_identity"`              // is_identity
	IdentityGeneration     pgtypes.CharacterData  `json:"identity_generation"`      // identity_generation
	IdentityStart          pgtypes.CharacterData  `json:"identity_start"`           // identity_start
	IdentityIncrement      pgtypes.CharacterData  `json:"identity_increment"`       // identity_increment
	IdentityMaximum        pgtypes.CharacterData  `json:"identity_maximum"`         // identity_maximum
	IdentityMinimum        pgtypes.CharacterData  `json:"identity_minimum"`         // identity_minimum
	IdentityCycle          pgtypes.YesOrNo        `json:"identity_cycle"`           // identity_cycle
	IsGenerated            pgtypes.CharacterData  `json:"is_generated"`             // is_generated
	GenerationExpression   pgtypes.CharacterData  `json:"generation_expression"`    // generation_expression
	IsUpdatable            pgtypes.YesOrNo        `json:"is_updatable"`             // is_updatable
}

Column represents a row from 'information_schema.columns'.

type ColumnDomainUsage ¶

type ColumnDomainUsage struct {
	DomainCatalog pgtypes.SQLIdentifier `json:"domain_catalog"` // domain_catalog
	DomainSchema  pgtypes.SQLIdentifier `json:"domain_schema"`  // domain_schema
	DomainName    pgtypes.SQLIdentifier `json:"domain_name"`    // domain_name
	TableCatalog  pgtypes.SQLIdentifier `json:"table_catalog"`  // table_catalog
	TableSchema   pgtypes.SQLIdentifier `json:"table_schema"`   // table_schema
	TableName     pgtypes.SQLIdentifier `json:"table_name"`     // table_name
	ColumnName    pgtypes.SQLIdentifier `json:"column_name"`    // column_name
}

ColumnDomainUsage represents a row from 'information_schema.column_domain_usage'.

type ColumnOption ¶

type ColumnOption struct {
	TableCatalog pgtypes.SQLIdentifier `json:"table_catalog"` // table_catalog
	TableSchema  pgtypes.SQLIdentifier `json:"table_schema"`  // table_schema
	TableName    pgtypes.SQLIdentifier `json:"table_name"`    // table_name
	ColumnName   pgtypes.SQLIdentifier `json:"column_name"`   // column_name
	OptionName   pgtypes.SQLIdentifier `json:"option_name"`   // option_name
	OptionValue  pgtypes.CharacterData `json:"option_value"`  // option_value
}

ColumnOption represents a row from 'information_schema.column_options'.

type ColumnPrivilege ¶

type ColumnPrivilege struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	TableCatalog  pgtypes.SQLIdentifier `json:"table_catalog"`  // table_catalog
	TableSchema   pgtypes.SQLIdentifier `json:"table_schema"`   // table_schema
	TableName     pgtypes.SQLIdentifier `json:"table_name"`     // table_name
	ColumnName    pgtypes.SQLIdentifier `json:"column_name"`    // column_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

ColumnPrivilege represents a row from 'information_schema.column_privileges'.

type ColumnUdtUsage ¶

type ColumnUdtUsage struct {
	UdtCatalog   pgtypes.SQLIdentifier `json:"udt_catalog"`   // udt_catalog
	UdtSchema    pgtypes.SQLIdentifier `json:"udt_schema"`    // udt_schema
	UdtName      pgtypes.SQLIdentifier `json:"udt_name"`      // udt_name
	TableCatalog pgtypes.SQLIdentifier `json:"table_catalog"` // table_catalog
	TableSchema  pgtypes.SQLIdentifier `json:"table_schema"`  // table_schema
	TableName    pgtypes.SQLIdentifier `json:"table_name"`    // table_name
	ColumnName   pgtypes.SQLIdentifier `json:"column_name"`   // column_name
}

ColumnUdtUsage represents a row from 'information_schema.column_udt_usage'.

type ConstraintColumnUsage ¶

type ConstraintColumnUsage struct {
	TableCatalog      pgtypes.SQLIdentifier `json:"table_catalog"`      // table_catalog
	TableSchema       pgtypes.SQLIdentifier `json:"table_schema"`       // table_schema
	TableName         pgtypes.SQLIdentifier `json:"table_name"`         // table_name
	ColumnName        pgtypes.SQLIdentifier `json:"column_name"`        // column_name
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
}

ConstraintColumnUsage represents a row from 'information_schema.constraint_column_usage'.

type ConstraintTableUsage ¶

type ConstraintTableUsage struct {
	TableCatalog      pgtypes.SQLIdentifier `json:"table_catalog"`      // table_catalog
	TableSchema       pgtypes.SQLIdentifier `json:"table_schema"`       // table_schema
	TableName         pgtypes.SQLIdentifier `json:"table_name"`         // table_name
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
}

ConstraintTableUsage represents a row from 'information_schema.constraint_table_usage'.

type DataTypePrivilege ¶

type DataTypePrivilege struct {
	ObjectCatalog pgtypes.SQLIdentifier `json:"object_catalog"` // object_catalog
	ObjectSchema  pgtypes.SQLIdentifier `json:"object_schema"`  // object_schema
	ObjectName    pgtypes.SQLIdentifier `json:"object_name"`    // object_name
	ObjectType    pgtypes.CharacterData `json:"object_type"`    // object_type
	DtdIdentifier pgtypes.SQLIdentifier `json:"dtd_identifier"` // dtd_identifier
}

DataTypePrivilege represents a row from 'information_schema.data_type_privileges'.

type Domain ¶

type Domain struct {
	DomainCatalog          pgtypes.SQLIdentifier  `json:"domain_catalog"`           // domain_catalog
	DomainSchema           pgtypes.SQLIdentifier  `json:"domain_schema"`            // domain_schema
	DomainName             pgtypes.SQLIdentifier  `json:"domain_name"`              // domain_name
	DataType               pgtypes.CharacterData  `json:"data_type"`                // data_type
	CharacterMaximumLength pgtypes.CardinalNumber `json:"character_maximum_length"` // character_maximum_length
	CharacterOctetLength   pgtypes.CardinalNumber `json:"character_octet_length"`   // character_octet_length
	CharacterSetCatalog    pgtypes.SQLIdentifier  `json:"character_set_catalog"`    // character_set_catalog
	CharacterSetSchema     pgtypes.SQLIdentifier  `json:"character_set_schema"`     // character_set_schema
	CharacterSetName       pgtypes.SQLIdentifier  `json:"character_set_name"`       // character_set_name
	CollationCatalog       pgtypes.SQLIdentifier  `json:"collation_catalog"`        // collation_catalog
	CollationSchema        pgtypes.SQLIdentifier  `json:"collation_schema"`         // collation_schema
	CollationName          pgtypes.SQLIdentifier  `json:"collation_name"`           // collation_name
	NumericPrecision       pgtypes.CardinalNumber `json:"numeric_precision"`        // numeric_precision
	NumericPrecisionRadix  pgtypes.CardinalNumber `json:"numeric_precision_radix"`  // numeric_precision_radix
	NumericScale           pgtypes.CardinalNumber `json:"numeric_scale"`            // numeric_scale
	DatetimePrecision      pgtypes.CardinalNumber `json:"datetime_precision"`       // datetime_precision
	IntervalType           pgtypes.CharacterData  `json:"interval_type"`            // interval_type
	IntervalPrecision      pgtypes.CardinalNumber `json:"interval_precision"`       // interval_precision
	DomainDefault          pgtypes.CharacterData  `json:"domain_default"`           // domain_default
	UdtCatalog             pgtypes.SQLIdentifier  `json:"udt_catalog"`              // udt_catalog
	UdtSchema              pgtypes.SQLIdentifier  `json:"udt_schema"`               // udt_schema
	UdtName                pgtypes.SQLIdentifier  `json:"udt_name"`                 // udt_name
	ScopeCatalog           pgtypes.SQLIdentifier  `json:"scope_catalog"`            // scope_catalog
	ScopeSchema            pgtypes.SQLIdentifier  `json:"scope_schema"`             // scope_schema
	ScopeName              pgtypes.SQLIdentifier  `json:"scope_name"`               // scope_name
	MaximumCardinality     pgtypes.CardinalNumber `json:"maximum_cardinality"`      // maximum_cardinality
	DtdIdentifier          pgtypes.SQLIdentifier  `json:"dtd_identifier"`           // dtd_identifier
}

Domain represents a row from 'information_schema.domains'.

type DomainConstraint ¶

type DomainConstraint struct {
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
	DomainCatalog     pgtypes.SQLIdentifier `json:"domain_catalog"`     // domain_catalog
	DomainSchema      pgtypes.SQLIdentifier `json:"domain_schema"`      // domain_schema
	DomainName        pgtypes.SQLIdentifier `json:"domain_name"`        // domain_name
	IsDeferrable      pgtypes.YesOrNo       `json:"is_deferrable"`      // is_deferrable
	InitiallyDeferred pgtypes.YesOrNo       `json:"initially_deferred"` // initially_deferred
}

DomainConstraint represents a row from 'information_schema.domain_constraints'.

type DomainUdtUsage ¶

type DomainUdtUsage struct {
	UdtCatalog    pgtypes.SQLIdentifier `json:"udt_catalog"`    // udt_catalog
	UdtSchema     pgtypes.SQLIdentifier `json:"udt_schema"`     // udt_schema
	UdtName       pgtypes.SQLIdentifier `json:"udt_name"`       // udt_name
	DomainCatalog pgtypes.SQLIdentifier `json:"domain_catalog"` // domain_catalog
	DomainSchema  pgtypes.SQLIdentifier `json:"domain_schema"`  // domain_schema
	DomainName    pgtypes.SQLIdentifier `json:"domain_name"`    // domain_name
}

DomainUdtUsage represents a row from 'information_schema.domain_udt_usage'.

type ElementType ¶

type ElementType struct {
	ObjectCatalog            pgtypes.SQLIdentifier  `json:"object_catalog"`             // object_catalog
	ObjectSchema             pgtypes.SQLIdentifier  `json:"object_schema"`              // object_schema
	ObjectName               pgtypes.SQLIdentifier  `json:"object_name"`                // object_name
	ObjectType               pgtypes.CharacterData  `json:"object_type"`                // object_type
	CollectionTypeIdentifier pgtypes.SQLIdentifier  `json:"collection_type_identifier"` // collection_type_identifier
	DataType                 pgtypes.CharacterData  `json:"data_type"`                  // data_type
	CharacterMaximumLength   pgtypes.CardinalNumber `json:"character_maximum_length"`   // character_maximum_length
	CharacterOctetLength     pgtypes.CardinalNumber `json:"character_octet_length"`     // character_octet_length
	CharacterSetCatalog      pgtypes.SQLIdentifier  `json:"character_set_catalog"`      // character_set_catalog
	CharacterSetSchema       pgtypes.SQLIdentifier  `json:"character_set_schema"`       // character_set_schema
	CharacterSetName         pgtypes.SQLIdentifier  `json:"character_set_name"`         // character_set_name
	CollationCatalog         pgtypes.SQLIdentifier  `json:"collation_catalog"`          // collation_catalog
	CollationSchema          pgtypes.SQLIdentifier  `json:"collation_schema"`           // collation_schema
	CollationName            pgtypes.SQLIdentifier  `json:"collation_name"`             // collation_name
	NumericPrecision         pgtypes.CardinalNumber `json:"numeric_precision"`          // numeric_precision
	NumericPrecisionRadix    pgtypes.CardinalNumber `json:"numeric_precision_radix"`    // numeric_precision_radix
	NumericScale             pgtypes.CardinalNumber `json:"numeric_scale"`              // numeric_scale
	DatetimePrecision        pgtypes.CardinalNumber `json:"datetime_precision"`         // datetime_precision
	IntervalType             pgtypes.CharacterData  `json:"interval_type"`              // interval_type
	IntervalPrecision        pgtypes.CardinalNumber `json:"interval_precision"`         // interval_precision
	DomainDefault            pgtypes.CharacterData  `json:"domain_default"`             // domain_default
	UdtCatalog               pgtypes.SQLIdentifier  `json:"udt_catalog"`                // udt_catalog
	UdtSchema                pgtypes.SQLIdentifier  `json:"udt_schema"`                 // udt_schema
	UdtName                  pgtypes.SQLIdentifier  `json:"udt_name"`                   // udt_name
	ScopeCatalog             pgtypes.SQLIdentifier  `json:"scope_catalog"`              // scope_catalog
	ScopeSchema              pgtypes.SQLIdentifier  `json:"scope_schema"`               // scope_schema
	ScopeName                pgtypes.SQLIdentifier  `json:"scope_name"`                 // scope_name
	MaximumCardinality       pgtypes.CardinalNumber `json:"maximum_cardinality"`        // maximum_cardinality
	DtdIdentifier            pgtypes.SQLIdentifier  `json:"dtd_identifier"`             // dtd_identifier
}

ElementType represents a row from 'information_schema.element_types'.

type EnabledRole ¶

type EnabledRole struct {
	RoleName pgtypes.SQLIdentifier `json:"role_name"` // role_name
}

EnabledRole represents a row from 'information_schema.enabled_roles'.

type ForeignDataWrapper ¶

type ForeignDataWrapper struct {
	ForeignDataWrapperCatalog  pgtypes.SQLIdentifier `json:"foreign_data_wrapper_catalog"`  // foreign_data_wrapper_catalog
	ForeignDataWrapperName     pgtypes.SQLIdentifier `json:"foreign_data_wrapper_name"`     // foreign_data_wrapper_name
	AuthorizationIdentifier    pgtypes.SQLIdentifier `json:"authorization_identifier"`      // authorization_identifier
	LibraryName                pgtypes.CharacterData `json:"library_name"`                  // library_name
	ForeignDataWrapperLanguage pgtypes.CharacterData `json:"foreign_data_wrapper_language"` // foreign_data_wrapper_language
}

ForeignDataWrapper represents a row from 'information_schema.foreign_data_wrappers'.

type ForeignDataWrapperOption ¶

type ForeignDataWrapperOption struct {
	ForeignDataWrapperCatalog pgtypes.SQLIdentifier `json:"foreign_data_wrapper_catalog"` // foreign_data_wrapper_catalog
	ForeignDataWrapperName    pgtypes.SQLIdentifier `json:"foreign_data_wrapper_name"`    // foreign_data_wrapper_name
	OptionName                pgtypes.SQLIdentifier `json:"option_name"`                  // option_name
	OptionValue               pgtypes.CharacterData `json:"option_value"`                 // option_value
}

ForeignDataWrapperOption represents a row from 'information_schema.foreign_data_wrapper_options'.

type ForeignServer ¶

type ForeignServer struct {
	ForeignServerCatalog      pgtypes.SQLIdentifier `json:"foreign_server_catalog"`       // foreign_server_catalog
	ForeignServerName         pgtypes.SQLIdentifier `json:"foreign_server_name"`          // foreign_server_name
	ForeignDataWrapperCatalog pgtypes.SQLIdentifier `json:"foreign_data_wrapper_catalog"` // foreign_data_wrapper_catalog
	ForeignDataWrapperName    pgtypes.SQLIdentifier `json:"foreign_data_wrapper_name"`    // foreign_data_wrapper_name
	ForeignServerType         pgtypes.CharacterData `json:"foreign_server_type"`          // foreign_server_type
	ForeignServerVersion      pgtypes.CharacterData `json:"foreign_server_version"`       // foreign_server_version
	AuthorizationIdentifier   pgtypes.SQLIdentifier `json:"authorization_identifier"`     // authorization_identifier
}

ForeignServer represents a row from 'information_schema.foreign_servers'.

type ForeignServerOption ¶

type ForeignServerOption struct {
	ForeignServerCatalog pgtypes.SQLIdentifier `json:"foreign_server_catalog"` // foreign_server_catalog
	ForeignServerName    pgtypes.SQLIdentifier `json:"foreign_server_name"`    // foreign_server_name
	OptionName           pgtypes.SQLIdentifier `json:"option_name"`            // option_name
	OptionValue          pgtypes.CharacterData `json:"option_value"`           // option_value
}

ForeignServerOption represents a row from 'information_schema.foreign_server_options'.

type ForeignTable ¶

type ForeignTable struct {
	ForeignTableCatalog  pgtypes.SQLIdentifier `json:"foreign_table_catalog"`  // foreign_table_catalog
	ForeignTableSchema   pgtypes.SQLIdentifier `json:"foreign_table_schema"`   // foreign_table_schema
	ForeignTableName     pgtypes.SQLIdentifier `json:"foreign_table_name"`     // foreign_table_name
	ForeignServerCatalog pgtypes.SQLIdentifier `json:"foreign_server_catalog"` // foreign_server_catalog
	ForeignServerName    pgtypes.SQLIdentifier `json:"foreign_server_name"`    // foreign_server_name
}

ForeignTable represents a row from 'information_schema.foreign_tables'.

type ForeignTableOption ¶

type ForeignTableOption struct {
	ForeignTableCatalog pgtypes.SQLIdentifier `json:"foreign_table_catalog"` // foreign_table_catalog
	ForeignTableSchema  pgtypes.SQLIdentifier `json:"foreign_table_schema"`  // foreign_table_schema
	ForeignTableName    pgtypes.SQLIdentifier `json:"foreign_table_name"`    // foreign_table_name
	OptionName          pgtypes.SQLIdentifier `json:"option_name"`           // option_name
	OptionValue         pgtypes.CharacterData `json:"option_value"`          // option_value
}

ForeignTableOption represents a row from 'information_schema.foreign_table_options'.

type InformationSchemaCatalogName ¶

type InformationSchemaCatalogName struct {
	CatalogName pgtypes.SQLIdentifier `json:"catalog_name"` // catalog_name
}

InformationSchemaCatalogName represents a row from 'information_schema.information_schema_catalog_name'.

type KeyColumnUsage ¶

type KeyColumnUsage struct {
	ConstraintCatalog          pgtypes.SQLIdentifier  `json:"constraint_catalog"`            // constraint_catalog
	ConstraintSchema           pgtypes.SQLIdentifier  `json:"constraint_schema"`             // constraint_schema
	ConstraintName             pgtypes.SQLIdentifier  `json:"constraint_name"`               // constraint_name
	TableCatalog               pgtypes.SQLIdentifier  `json:"table_catalog"`                 // table_catalog
	TableSchema                pgtypes.SQLIdentifier  `json:"table_schema"`                  // table_schema
	TableName                  pgtypes.SQLIdentifier  `json:"table_name"`                    // table_name
	ColumnName                 pgtypes.SQLIdentifier  `json:"column_name"`                   // column_name
	OrdinalPosition            pgtypes.CardinalNumber `json:"ordinal_position"`              // ordinal_position
	PositionInUniqueConstraint pgtypes.CardinalNumber `json:"position_in_unique_constraint"` // position_in_unique_constraint
}

KeyColumnUsage represents a row from 'information_schema.key_column_usage'.

type Parameter ¶

type Parameter struct {
	SpecificCatalog        pgtypes.SQLIdentifier  `json:"specific_catalog"`         // specific_catalog
	SpecificSchema         pgtypes.SQLIdentifier  `json:"specific_schema"`          // specific_schema
	SpecificName           pgtypes.SQLIdentifier  `json:"specific_name"`            // specific_name
	OrdinalPosition        pgtypes.CardinalNumber `json:"ordinal_position"`         // ordinal_position
	ParameterMode          pgtypes.CharacterData  `json:"parameter_mode"`           // parameter_mode
	IsResult               pgtypes.YesOrNo        `json:"is_result"`                // is_result
	AsLocator              pgtypes.YesOrNo        `json:"as_locator"`               // as_locator
	ParameterName          pgtypes.SQLIdentifier  `json:"parameter_name"`           // parameter_name
	DataType               pgtypes.CharacterData  `json:"data_type"`                // data_type
	CharacterMaximumLength pgtypes.CardinalNumber `json:"character_maximum_length"` // character_maximum_length
	CharacterOctetLength   pgtypes.CardinalNumber `json:"character_octet_length"`   // character_octet_length
	CharacterSetCatalog    pgtypes.SQLIdentifier  `json:"character_set_catalog"`    // character_set_catalog
	CharacterSetSchema     pgtypes.SQLIdentifier  `json:"character_set_schema"`     // character_set_schema
	CharacterSetName       pgtypes.SQLIdentifier  `json:"character_set_name"`       // character_set_name
	CollationCatalog       pgtypes.SQLIdentifier  `json:"collation_catalog"`        // collation_catalog
	CollationSchema        pgtypes.SQLIdentifier  `json:"collation_schema"`         // collation_schema
	CollationName          pgtypes.SQLIdentifier  `json:"collation_name"`           // collation_name
	NumericPrecision       pgtypes.CardinalNumber `json:"numeric_precision"`        // numeric_precision
	NumericPrecisionRadix  pgtypes.CardinalNumber `json:"numeric_precision_radix"`  // numeric_precision_radix
	NumericScale           pgtypes.CardinalNumber `json:"numeric_scale"`            // numeric_scale
	DatetimePrecision      pgtypes.CardinalNumber `json:"datetime_precision"`       // datetime_precision
	IntervalType           pgtypes.CharacterData  `json:"interval_type"`            // interval_type
	IntervalPrecision      pgtypes.CardinalNumber `json:"interval_precision"`       // interval_precision
	UdtCatalog             pgtypes.SQLIdentifier  `json:"udt_catalog"`              // udt_catalog
	UdtSchema              pgtypes.SQLIdentifier  `json:"udt_schema"`               // udt_schema
	UdtName                pgtypes.SQLIdentifier  `json:"udt_name"`                 // udt_name
	ScopeCatalog           pgtypes.SQLIdentifier  `json:"scope_catalog"`            // scope_catalog
	ScopeSchema            pgtypes.SQLIdentifier  `json:"scope_schema"`             // scope_schema
	ScopeName              pgtypes.SQLIdentifier  `json:"scope_name"`               // scope_name
	MaximumCardinality     pgtypes.CardinalNumber `json:"maximum_cardinality"`      // maximum_cardinality
	DtdIdentifier          pgtypes.SQLIdentifier  `json:"dtd_identifier"`           // dtd_identifier
	ParameterDefault       pgtypes.CharacterData  `json:"parameter_default"`        // parameter_default
}

Parameter represents a row from 'information_schema.parameters'.

type PgForeignDataWrapper ¶

type PgForeignDataWrapper struct {
	Oid                        pgtypes.Oid           `json:"oid"`                           // oid
	Fdwowner                   pgtypes.Oid           `json:"fdwowner"`                      // fdwowner
	Fdwoptions                 []sql.NullString      `json:"fdwoptions"`                    // fdwoptions
	ForeignDataWrapperCatalog  pgtypes.SQLIdentifier `json:"foreign_data_wrapper_catalog"`  // foreign_data_wrapper_catalog
	ForeignDataWrapperName     pgtypes.SQLIdentifier `json:"foreign_data_wrapper_name"`     // foreign_data_wrapper_name
	AuthorizationIdentifier    pgtypes.SQLIdentifier `json:"authorization_identifier"`      // authorization_identifier
	ForeignDataWrapperLanguage pgtypes.CharacterData `json:"foreign_data_wrapper_language"` // foreign_data_wrapper_language
}

PgForeignDataWrapper represents a row from 'information_schema._pg_foreign_data_wrappers'.

type PgForeignServer ¶

type PgForeignServer struct {
	Oid                       pgtypes.Oid           `json:"oid"`                          // oid
	Srvoptions                []sql.NullString      `json:"srvoptions"`                   // srvoptions
	ForeignServerCatalog      pgtypes.SQLIdentifier `json:"foreign_server_catalog"`       // foreign_server_catalog
	ForeignServerName         pgtypes.SQLIdentifier `json:"foreign_server_name"`          // foreign_server_name
	ForeignDataWrapperCatalog pgtypes.SQLIdentifier `json:"foreign_data_wrapper_catalog"` // foreign_data_wrapper_catalog
	ForeignDataWrapperName    pgtypes.SQLIdentifier `json:"foreign_data_wrapper_name"`    // foreign_data_wrapper_name
	ForeignServerType         pgtypes.CharacterData `json:"foreign_server_type"`          // foreign_server_type
	ForeignServerVersion      pgtypes.CharacterData `json:"foreign_server_version"`       // foreign_server_version
	AuthorizationIdentifier   pgtypes.SQLIdentifier `json:"authorization_identifier"`     // authorization_identifier
}

PgForeignServer represents a row from 'information_schema._pg_foreign_servers'.

type PgForeignTable ¶

type PgForeignTable struct {
	ForeignTableCatalog     pgtypes.SQLIdentifier `json:"foreign_table_catalog"`    // foreign_table_catalog
	ForeignTableSchema      pgtypes.SQLIdentifier `json:"foreign_table_schema"`     // foreign_table_schema
	ForeignTableName        pgtypes.SQLIdentifier `json:"foreign_table_name"`       // foreign_table_name
	Ftoptions               []sql.NullString      `json:"ftoptions"`                // ftoptions
	ForeignServerCatalog    pgtypes.SQLIdentifier `json:"foreign_server_catalog"`   // foreign_server_catalog
	ForeignServerName       pgtypes.SQLIdentifier `json:"foreign_server_name"`      // foreign_server_name
	AuthorizationIdentifier pgtypes.SQLIdentifier `json:"authorization_identifier"` // authorization_identifier
}

PgForeignTable represents a row from 'information_schema._pg_foreign_tables'.

type PgForeignTableColumn ¶

type PgForeignTableColumn struct {
	Nspname       pgtypes.Name     `json:"nspname"`       // nspname
	Relname       pgtypes.Name     `json:"relname"`       // relname
	Attname       pgtypes.Name     `json:"attname"`       // attname
	Attfdwoptions []sql.NullString `json:"attfdwoptions"` // attfdwoptions
}

PgForeignTableColumn represents a row from 'information_schema._pg_foreign_table_columns'.

type PgUserMapping ¶

type PgUserMapping struct {
	Oid                     pgtypes.Oid           `json:"oid"`                      // oid
	Umoptions               []sql.NullString      `json:"umoptions"`                // umoptions
	Umuser                  pgtypes.Oid           `json:"umuser"`                   // umuser
	AuthorizationIdentifier pgtypes.SQLIdentifier `json:"authorization_identifier"` // authorization_identifier
	ForeignServerCatalog    pgtypes.SQLIdentifier `json:"foreign_server_catalog"`   // foreign_server_catalog
	ForeignServerName       pgtypes.SQLIdentifier `json:"foreign_server_name"`      // foreign_server_name
	Srvowner                pgtypes.SQLIdentifier `json:"srvowner"`                 // srvowner
}

PgUserMapping represents a row from 'information_schema._pg_user_mappings'.

type ReferentialConstraint ¶

type ReferentialConstraint struct {
	ConstraintCatalog       pgtypes.SQLIdentifier `json:"constraint_catalog"`        // constraint_catalog
	ConstraintSchema        pgtypes.SQLIdentifier `json:"constraint_schema"`         // constraint_schema
	ConstraintName          pgtypes.SQLIdentifier `json:"constraint_name"`           // constraint_name
	UniqueConstraintCatalog pgtypes.SQLIdentifier `json:"unique_constraint_catalog"` // unique_constraint_catalog
	UniqueConstraintSchema  pgtypes.SQLIdentifier `json:"unique_constraint_schema"`  // unique_constraint_schema
	UniqueConstraintName    pgtypes.SQLIdentifier `json:"unique_constraint_name"`    // unique_constraint_name
	MatchOption             pgtypes.CharacterData `json:"match_option"`              // match_option
	UpdateRule              pgtypes.CharacterData `json:"update_rule"`               // update_rule
	DeleteRule              pgtypes.CharacterData `json:"delete_rule"`               // delete_rule
}

ReferentialConstraint represents a row from 'information_schema.referential_constraints'.

type RoleColumnGrant ¶

type RoleColumnGrant struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	TableCatalog  pgtypes.SQLIdentifier `json:"table_catalog"`  // table_catalog
	TableSchema   pgtypes.SQLIdentifier `json:"table_schema"`   // table_schema
	TableName     pgtypes.SQLIdentifier `json:"table_name"`     // table_name
	ColumnName    pgtypes.SQLIdentifier `json:"column_name"`    // column_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

RoleColumnGrant represents a row from 'information_schema.role_column_grants'.

type RoleRoutineGrant ¶

type RoleRoutineGrant struct {
	Grantor         pgtypes.SQLIdentifier `json:"grantor"`          // grantor
	Grantee         pgtypes.SQLIdentifier `json:"grantee"`          // grantee
	SpecificCatalog pgtypes.SQLIdentifier `json:"specific_catalog"` // specific_catalog
	SpecificSchema  pgtypes.SQLIdentifier `json:"specific_schema"`  // specific_schema
	SpecificName    pgtypes.SQLIdentifier `json:"specific_name"`    // specific_name
	RoutineCatalog  pgtypes.SQLIdentifier `json:"routine_catalog"`  // routine_catalog
	RoutineSchema   pgtypes.SQLIdentifier `json:"routine_schema"`   // routine_schema
	RoutineName     pgtypes.SQLIdentifier `json:"routine_name"`     // routine_name
	PrivilegeType   pgtypes.CharacterData `json:"privilege_type"`   // privilege_type
	IsGrantable     pgtypes.YesOrNo       `json:"is_grantable"`     // is_grantable
}

RoleRoutineGrant represents a row from 'information_schema.role_routine_grants'.

type RoleTableGrant ¶

type RoleTableGrant struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	TableCatalog  pgtypes.SQLIdentifier `json:"table_catalog"`  // table_catalog
	TableSchema   pgtypes.SQLIdentifier `json:"table_schema"`   // table_schema
	TableName     pgtypes.SQLIdentifier `json:"table_name"`     // table_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
	WithHierarchy pgtypes.YesOrNo       `json:"with_hierarchy"` // with_hierarchy
}

RoleTableGrant represents a row from 'information_schema.role_table_grants'.

type RoleUdtGrant ¶

type RoleUdtGrant struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	UdtCatalog    pgtypes.SQLIdentifier `json:"udt_catalog"`    // udt_catalog
	UdtSchema     pgtypes.SQLIdentifier `json:"udt_schema"`     // udt_schema
	UdtName       pgtypes.SQLIdentifier `json:"udt_name"`       // udt_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

RoleUdtGrant represents a row from 'information_schema.role_udt_grants'.

type RoleUsageGrant ¶

type RoleUsageGrant struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	ObjectCatalog pgtypes.SQLIdentifier `json:"object_catalog"` // object_catalog
	ObjectSchema  pgtypes.SQLIdentifier `json:"object_schema"`  // object_schema
	ObjectName    pgtypes.SQLIdentifier `json:"object_name"`    // object_name
	ObjectType    pgtypes.CharacterData `json:"object_type"`    // object_type
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

RoleUsageGrant represents a row from 'information_schema.role_usage_grants'.

type Routine ¶

type Routine struct {
	SpecificCatalog                 pgtypes.SQLIdentifier  `json:"specific_catalog"`                    // specific_catalog
	SpecificSchema                  pgtypes.SQLIdentifier  `json:"specific_schema"`                     // specific_schema
	SpecificName                    pgtypes.SQLIdentifier  `json:"specific_name"`                       // specific_name
	RoutineCatalog                  pgtypes.SQLIdentifier  `json:"routine_catalog"`                     // routine_catalog
	RoutineSchema                   pgtypes.SQLIdentifier  `json:"routine_schema"`                      // routine_schema
	RoutineName                     pgtypes.SQLIdentifier  `json:"routine_name"`                        // routine_name
	RoutineType                     pgtypes.CharacterData  `json:"routine_type"`                        // routine_type
	ModuleCatalog                   pgtypes.SQLIdentifier  `json:"module_catalog"`                      // module_catalog
	ModuleSchema                    pgtypes.SQLIdentifier  `json:"module_schema"`                       // module_schema
	ModuleName                      pgtypes.SQLIdentifier  `json:"module_name"`                         // module_name
	UdtCatalog                      pgtypes.SQLIdentifier  `json:"udt_catalog"`                         // udt_catalog
	UdtSchema                       pgtypes.SQLIdentifier  `json:"udt_schema"`                          // udt_schema
	UdtName                         pgtypes.SQLIdentifier  `json:"udt_name"`                            // udt_name
	DataType                        pgtypes.CharacterData  `json:"data_type"`                           // data_type
	CharacterMaximumLength          pgtypes.CardinalNumber `json:"character_maximum_length"`            // character_maximum_length
	CharacterOctetLength            pgtypes.CardinalNumber `json:"character_octet_length"`              // character_octet_length
	CharacterSetCatalog             pgtypes.SQLIdentifier  `json:"character_set_catalog"`               // character_set_catalog
	CharacterSetSchema              pgtypes.SQLIdentifier  `json:"character_set_schema"`                // character_set_schema
	CharacterSetName                pgtypes.SQLIdentifier  `json:"character_set_name"`                  // character_set_name
	CollationCatalog                pgtypes.SQLIdentifier  `json:"collation_catalog"`                   // collation_catalog
	CollationSchema                 pgtypes.SQLIdentifier  `json:"collation_schema"`                    // collation_schema
	CollationName                   pgtypes.SQLIdentifier  `json:"collation_name"`                      // collation_name
	NumericPrecision                pgtypes.CardinalNumber `json:"numeric_precision"`                   // numeric_precision
	NumericPrecisionRadix           pgtypes.CardinalNumber `json:"numeric_precision_radix"`             // numeric_precision_radix
	NumericScale                    pgtypes.CardinalNumber `json:"numeric_scale"`                       // numeric_scale
	DatetimePrecision               pgtypes.CardinalNumber `json:"datetime_precision"`                  // datetime_precision
	IntervalType                    pgtypes.CharacterData  `json:"interval_type"`                       // interval_type
	IntervalPrecision               pgtypes.CardinalNumber `json:"interval_precision"`                  // interval_precision
	TypeUdtCatalog                  pgtypes.SQLIdentifier  `json:"type_udt_catalog"`                    // type_udt_catalog
	TypeUdtSchema                   pgtypes.SQLIdentifier  `json:"type_udt_schema"`                     // type_udt_schema
	TypeUdtName                     pgtypes.SQLIdentifier  `json:"type_udt_name"`                       // type_udt_name
	ScopeCatalog                    pgtypes.SQLIdentifier  `json:"scope_catalog"`                       // scope_catalog
	ScopeSchema                     pgtypes.SQLIdentifier  `json:"scope_schema"`                        // scope_schema
	ScopeName                       pgtypes.SQLIdentifier  `json:"scope_name"`                          // scope_name
	MaximumCardinality              pgtypes.CardinalNumber `json:"maximum_cardinality"`                 // maximum_cardinality
	DtdIdentifier                   pgtypes.SQLIdentifier  `json:"dtd_identifier"`                      // dtd_identifier
	RoutineBody                     pgtypes.CharacterData  `json:"routine_body"`                        // routine_body
	RoutineDefinition               pgtypes.CharacterData  `json:"routine_definition"`                  // routine_definition
	ExternalName                    pgtypes.CharacterData  `json:"external_name"`                       // external_name
	ExternalLanguage                pgtypes.CharacterData  `json:"external_language"`                   // external_language
	ParameterStyle                  pgtypes.CharacterData  `json:"parameter_style"`                     // parameter_style
	IsDeterministic                 pgtypes.YesOrNo        `json:"is_deterministic"`                    // is_deterministic
	SQLDataAccess                   pgtypes.CharacterData  `json:"sql_data_access"`                     // sql_data_access
	IsNullCall                      pgtypes.YesOrNo        `json:"is_null_call"`                        // is_null_call
	SQLPath                         pgtypes.CharacterData  `json:"sql_path"`                            // sql_path
	SchemaLevelRoutine              pgtypes.YesOrNo        `json:"schema_level_routine"`                // schema_level_routine
	MaxDynamicResultSets            pgtypes.CardinalNumber `json:"max_dynamic_result_sets"`             // max_dynamic_result_sets
	IsUserDefinedCast               pgtypes.YesOrNo        `json:"is_user_defined_cast"`                // is_user_defined_cast
	IsImplicitlyInvocable           pgtypes.YesOrNo        `json:"is_implicitly_invocable"`             // is_implicitly_invocable
	SecurityType                    pgtypes.CharacterData  `json:"security_type"`                       // security_type
	ToSQLSpecificCatalog            pgtypes.SQLIdentifier  `json:"to_sql_specific_catalog"`             // to_sql_specific_catalog
	ToSQLSpecificSchema             pgtypes.SQLIdentifier  `json:"to_sql_specific_schema"`              // to_sql_specific_schema
	ToSQLSpecificName               pgtypes.SQLIdentifier  `json:"to_sql_specific_name"`                // to_sql_specific_name
	AsLocator                       pgtypes.YesOrNo        `json:"as_locator"`                          // as_locator
	Created                         pgtypes.TimeStamp      `json:"created"`                             // created
	LastAltered                     pgtypes.TimeStamp      `json:"last_altered"`                        // last_altered
	NewSavepointLevel               pgtypes.YesOrNo        `json:"new_savepoint_level"`                 // new_savepoint_level
	IsUdtDependent                  pgtypes.YesOrNo        `json:"is_udt_dependent"`                    // is_udt_dependent
	ResultCastFromDataType          pgtypes.CharacterData  `json:"result_cast_from_data_type"`          // result_cast_from_data_type
	ResultCastAsLocator             pgtypes.YesOrNo        `json:"result_cast_as_locator"`              // result_cast_as_locator
	ResultCastCharMaxLength         pgtypes.CardinalNumber `json:"result_cast_char_max_length"`         // result_cast_char_max_length
	ResultCastCharOctetLength       pgtypes.CardinalNumber `json:"result_cast_char_octet_length"`       // result_cast_char_octet_length
	ResultCastCharSetCatalog        pgtypes.SQLIdentifier  `json:"result_cast_char_set_catalog"`        // result_cast_char_set_catalog
	ResultCastCharSetSchema         pgtypes.SQLIdentifier  `json:"result_cast_char_set_schema"`         // result_cast_char_set_schema
	ResultCastCharSetName           pgtypes.SQLIdentifier  `json:"result_cast_char_set_name"`           // result_cast_char_set_name
	ResultCastCollationCatalog      pgtypes.SQLIdentifier  `json:"result_cast_collation_catalog"`       // result_cast_collation_catalog
	ResultCastCollationSchema       pgtypes.SQLIdentifier  `json:"result_cast_collation_schema"`        // result_cast_collation_schema
	ResultCastCollationName         pgtypes.SQLIdentifier  `json:"result_cast_collation_name"`          // result_cast_collation_name
	ResultCastNumericPrecision      pgtypes.CardinalNumber `json:"result_cast_numeric_precision"`       // result_cast_numeric_precision
	ResultCastNumericPrecisionRadix pgtypes.CardinalNumber `json:"result_cast_numeric_precision_radix"` // result_cast_numeric_precision_radix
	ResultCastNumericScale          pgtypes.CardinalNumber `json:"result_cast_numeric_scale"`           // result_cast_numeric_scale
	ResultCastDatetimePrecision     pgtypes.CardinalNumber `json:"result_cast_datetime_precision"`      // result_cast_datetime_precision
	ResultCastIntervalType          pgtypes.CharacterData  `json:"result_cast_interval_type"`           // result_cast_interval_type
	ResultCastIntervalPrecision     pgtypes.CardinalNumber `json:"result_cast_interval_precision"`      // result_cast_interval_precision
	ResultCastTypeUdtCatalog        pgtypes.SQLIdentifier  `json:"result_cast_type_udt_catalog"`        // result_cast_type_udt_catalog
	ResultCastTypeUdtSchema         pgtypes.SQLIdentifier  `json:"result_cast_type_udt_schema"`         // result_cast_type_udt_schema
	ResultCastTypeUdtName           pgtypes.SQLIdentifier  `json:"result_cast_type_udt_name"`           // result_cast_type_udt_name
	ResultCastScopeCatalog          pgtypes.SQLIdentifier  `json:"result_cast_scope_catalog"`           // result_cast_scope_catalog
	ResultCastScopeSchema           pgtypes.SQLIdentifier  `json:"result_cast_scope_schema"`            // result_cast_scope_schema
	ResultCastScopeName             pgtypes.SQLIdentifier  `json:"result_cast_scope_name"`              // result_cast_scope_name
	ResultCastMaximumCardinality    pgtypes.CardinalNumber `json:"result_cast_maximum_cardinality"`     // result_cast_maximum_cardinality
	ResultCastDtdIdentifier         pgtypes.SQLIdentifier  `json:"result_cast_dtd_identifier"`          // result_cast_dtd_identifier
}

Routine represents a row from 'information_schema.routines'.

type RoutinePrivilege ¶

type RoutinePrivilege struct {
	Grantor         pgtypes.SQLIdentifier `json:"grantor"`          // grantor
	Grantee         pgtypes.SQLIdentifier `json:"grantee"`          // grantee
	SpecificCatalog pgtypes.SQLIdentifier `json:"specific_catalog"` // specific_catalog
	SpecificSchema  pgtypes.SQLIdentifier `json:"specific_schema"`  // specific_schema
	SpecificName    pgtypes.SQLIdentifier `json:"specific_name"`    // specific_name
	RoutineCatalog  pgtypes.SQLIdentifier `json:"routine_catalog"`  // routine_catalog
	RoutineSchema   pgtypes.SQLIdentifier `json:"routine_schema"`   // routine_schema
	RoutineName     pgtypes.SQLIdentifier `json:"routine_name"`     // routine_name
	PrivilegeType   pgtypes.CharacterData `json:"privilege_type"`   // privilege_type
	IsGrantable     pgtypes.YesOrNo       `json:"is_grantable"`     // is_grantable
}

RoutinePrivilege represents a row from 'information_schema.routine_privileges'.

type SQLFeature ¶

type SQLFeature struct {
	Tableoid       pgtypes.Oid           `json:"tableoid"`         // tableoid
	Cmax           pgtypes.Cid           `json:"cmax"`             // cmax
	Xmax           pgtypes.Xid           `json:"xmax"`             // xmax
	Cmin           pgtypes.Cid           `json:"cmin"`             // cmin
	Xmin           pgtypes.Xid           `json:"xmin"`             // xmin
	Ctid           pgtypes.Tid           `json:"ctid"`             // ctid
	FeatureID      pgtypes.CharacterData `json:"feature_id"`       // feature_id
	FeatureName    pgtypes.CharacterData `json:"feature_name"`     // feature_name
	SubFeatureID   pgtypes.CharacterData `json:"sub_feature_id"`   // sub_feature_id
	SubFeatureName pgtypes.CharacterData `json:"sub_feature_name"` // sub_feature_name
	IsSupported    pgtypes.YesOrNo       `json:"is_supported"`     // is_supported
	IsVerifiedBy   pgtypes.CharacterData `json:"is_verified_by"`   // is_verified_by
	Comments       pgtypes.CharacterData `json:"comments"`         // comments
}

SQLFeature represents a row from 'information_schema.sql_features'.

type SQLImplementationInfo ¶

type SQLImplementationInfo struct {
	Tableoid               pgtypes.Oid            `json:"tableoid"`                 // tableoid
	Cmax                   pgtypes.Cid            `json:"cmax"`                     // cmax
	Xmax                   pgtypes.Xid            `json:"xmax"`                     // xmax
	Cmin                   pgtypes.Cid            `json:"cmin"`                     // cmin
	Xmin                   pgtypes.Xid            `json:"xmin"`                     // xmin
	Ctid                   pgtypes.Tid            `json:"ctid"`                     // ctid
	ImplementationInfoID   pgtypes.CharacterData  `json:"implementation_info_id"`   // implementation_info_id
	ImplementationInfoName pgtypes.CharacterData  `json:"implementation_info_name"` // implementation_info_name
	IntegerValue           pgtypes.CardinalNumber `json:"integer_value"`            // integer_value
	CharacterValue         pgtypes.CharacterData  `json:"character_value"`          // character_value
	Comments               pgtypes.CharacterData  `json:"comments"`                 // comments
}

SQLImplementationInfo represents a row from 'information_schema.sql_implementation_info'.

type SQLLanguage ¶

type SQLLanguage struct {
	Tableoid                       pgtypes.Oid           `json:"tableoid"`                          // tableoid
	Cmax                           pgtypes.Cid           `json:"cmax"`                              // cmax
	Xmax                           pgtypes.Xid           `json:"xmax"`                              // xmax
	Cmin                           pgtypes.Cid           `json:"cmin"`                              // cmin
	Xmin                           pgtypes.Xid           `json:"xmin"`                              // xmin
	Ctid                           pgtypes.Tid           `json:"ctid"`                              // ctid
	SQLLanguageSource              pgtypes.CharacterData `json:"sql_language_source"`               // sql_language_source
	SQLLanguageYear                pgtypes.CharacterData `json:"sql_language_year"`                 // sql_language_year
	SQLLanguageConformance         pgtypes.CharacterData `json:"sql_language_conformance"`          // sql_language_conformance
	SQLLanguageIntegrity           pgtypes.CharacterData `json:"sql_language_integrity"`            // sql_language_integrity
	SQLLanguageImplementation      pgtypes.CharacterData `json:"sql_language_implementation"`       // sql_language_implementation
	SQLLanguageBindingStyle        pgtypes.CharacterData `json:"sql_language_binding_style"`        // sql_language_binding_style
	SQLLanguageProgrammingLanguage pgtypes.CharacterData `json:"sql_language_programming_language"` // sql_language_programming_language
}

SQLLanguage represents a row from 'information_schema.sql_languages'.

type SQLPackage ¶

type SQLPackage struct {
	Tableoid     pgtypes.Oid           `json:"tableoid"`       // tableoid
	Cmax         pgtypes.Cid           `json:"cmax"`           // cmax
	Xmax         pgtypes.Xid           `json:"xmax"`           // xmax
	Cmin         pgtypes.Cid           `json:"cmin"`           // cmin
	Xmin         pgtypes.Xid           `json:"xmin"`           // xmin
	Ctid         pgtypes.Tid           `json:"ctid"`           // ctid
	FeatureID    pgtypes.CharacterData `json:"feature_id"`     // feature_id
	FeatureName  pgtypes.CharacterData `json:"feature_name"`   // feature_name
	IsSupported  pgtypes.YesOrNo       `json:"is_supported"`   // is_supported
	IsVerifiedBy pgtypes.CharacterData `json:"is_verified_by"` // is_verified_by
	Comments     pgtypes.CharacterData `json:"comments"`       // comments
}

SQLPackage represents a row from 'information_schema.sql_packages'.

type SQLPart ¶

type SQLPart struct {
	Tableoid     pgtypes.Oid           `json:"tableoid"`       // tableoid
	Cmax         pgtypes.Cid           `json:"cmax"`           // cmax
	Xmax         pgtypes.Xid           `json:"xmax"`           // xmax
	Cmin         pgtypes.Cid           `json:"cmin"`           // cmin
	Xmin         pgtypes.Xid           `json:"xmin"`           // xmin
	Ctid         pgtypes.Tid           `json:"ctid"`           // ctid
	FeatureID    pgtypes.CharacterData `json:"feature_id"`     // feature_id
	FeatureName  pgtypes.CharacterData `json:"feature_name"`   // feature_name
	IsSupported  pgtypes.YesOrNo       `json:"is_supported"`   // is_supported
	IsVerifiedBy pgtypes.CharacterData `json:"is_verified_by"` // is_verified_by
	Comments     pgtypes.CharacterData `json:"comments"`       // comments
}

SQLPart represents a row from 'information_schema.sql_parts'.

type SQLSizing ¶

type SQLSizing struct {
	Tableoid       pgtypes.Oid            `json:"tableoid"`        // tableoid
	Cmax           pgtypes.Cid            `json:"cmax"`            // cmax
	Xmax           pgtypes.Xid            `json:"xmax"`            // xmax
	Cmin           pgtypes.Cid            `json:"cmin"`            // cmin
	Xmin           pgtypes.Xid            `json:"xmin"`            // xmin
	Ctid           pgtypes.Tid            `json:"ctid"`            // ctid
	SizingID       pgtypes.CardinalNumber `json:"sizing_id"`       // sizing_id
	SizingName     pgtypes.CharacterData  `json:"sizing_name"`     // sizing_name
	SupportedValue pgtypes.CardinalNumber `json:"supported_value"` // supported_value
	Comments       pgtypes.CharacterData  `json:"comments"`        // comments
}

SQLSizing represents a row from 'information_schema.sql_sizing'.

type SQLSizingProfile ¶

type SQLSizingProfile struct {
	Tableoid      pgtypes.Oid            `json:"tableoid"`       // tableoid
	Cmax          pgtypes.Cid            `json:"cmax"`           // cmax
	Xmax          pgtypes.Xid            `json:"xmax"`           // xmax
	Cmin          pgtypes.Cid            `json:"cmin"`           // cmin
	Xmin          pgtypes.Xid            `json:"xmin"`           // xmin
	Ctid          pgtypes.Tid            `json:"ctid"`           // ctid
	SizingID      pgtypes.CardinalNumber `json:"sizing_id"`      // sizing_id
	SizingName    pgtypes.CharacterData  `json:"sizing_name"`    // sizing_name
	ProfileID     pgtypes.CharacterData  `json:"profile_id"`     // profile_id
	RequiredValue pgtypes.CardinalNumber `json:"required_value"` // required_value
	Comments      pgtypes.CharacterData  `json:"comments"`       // comments
}

SQLSizingProfile represents a row from 'information_schema.sql_sizing_profiles'.

type ScannerValuer ¶

type ScannerValuer interface {
	sql.Scanner
	driver.Valuer
}

ScannerValuer is the common interface for types that implement both the database/sql.Scanner and sql/driver.Valuer interfaces.

type Schematum ¶

type Schematum struct {
	CatalogName                pgtypes.SQLIdentifier `json:"catalog_name"`                  // catalog_name
	SchemaName                 pgtypes.SQLIdentifier `json:"schema_name"`                   // schema_name
	SchemaOwner                pgtypes.SQLIdentifier `json:"schema_owner"`                  // schema_owner
	DefaultCharacterSetCatalog pgtypes.SQLIdentifier `json:"default_character_set_catalog"` // default_character_set_catalog
	DefaultCharacterSetSchema  pgtypes.SQLIdentifier `json:"default_character_set_schema"`  // default_character_set_schema
	DefaultCharacterSetName    pgtypes.SQLIdentifier `json:"default_character_set_name"`    // default_character_set_name
	SQLPath                    pgtypes.CharacterData `json:"sql_path"`                      // sql_path
}

Schematum represents a row from 'information_schema.schemata'.

type Sequence ¶

type Sequence struct {
	SequenceCatalog       pgtypes.SQLIdentifier  `json:"sequence_catalog"`        // sequence_catalog
	SequenceSchema        pgtypes.SQLIdentifier  `json:"sequence_schema"`         // sequence_schema
	SequenceName          pgtypes.SQLIdentifier  `json:"sequence_name"`           // sequence_name
	DataType              pgtypes.CharacterData  `json:"data_type"`               // data_type
	NumericPrecision      pgtypes.CardinalNumber `json:"numeric_precision"`       // numeric_precision
	NumericPrecisionRadix pgtypes.CardinalNumber `json:"numeric_precision_radix"` // numeric_precision_radix
	NumericScale          pgtypes.CardinalNumber `json:"numeric_scale"`           // numeric_scale
	StartValue            pgtypes.CharacterData  `json:"start_value"`             // start_value
	MinimumValue          pgtypes.CharacterData  `json:"minimum_value"`           // minimum_value
	MaximumValue          pgtypes.CharacterData  `json:"maximum_value"`           // maximum_value
	Increment             pgtypes.CharacterData  `json:"increment"`               // increment
	CycleOption           pgtypes.YesOrNo        `json:"cycle_option"`            // cycle_option
}

Sequence represents a row from 'information_schema.sequences'.

type Slice ¶

type Slice []ScannerValuer

Slice is a slice of ScannerValuers.

type StringSlice ¶

type StringSlice []string

StringSlice is a slice of strings.

func (*StringSlice) Scan ¶

func (ss *StringSlice) Scan(src interface{}) error

Scan satisfies the sql.Scanner interface for StringSlice.

func (StringSlice) Value ¶

func (ss StringSlice) Value() (driver.Value, error)

Value satisfies the driver.Valuer interface for StringSlice.

type Table ¶

type Table struct {
	TableCatalog              pgtypes.SQLIdentifier `json:"table_catalog"`                // table_catalog
	TableSchema               pgtypes.SQLIdentifier `json:"table_schema"`                 // table_schema
	TableName                 pgtypes.SQLIdentifier `json:"table_name"`                   // table_name
	TableType                 pgtypes.CharacterData `json:"table_type"`                   // table_type
	SelfReferencingColumnName pgtypes.SQLIdentifier `json:"self_referencing_column_name"` // self_referencing_column_name
	ReferenceGeneration       pgtypes.CharacterData `json:"reference_generation"`         // reference_generation
	UserDefinedTypeCatalog    pgtypes.SQLIdentifier `json:"user_defined_type_catalog"`    // user_defined_type_catalog
	UserDefinedTypeSchema     pgtypes.SQLIdentifier `json:"user_defined_type_schema"`     // user_defined_type_schema
	UserDefinedTypeName       pgtypes.SQLIdentifier `json:"user_defined_type_name"`       // user_defined_type_name
	IsInsertableInto          pgtypes.YesOrNo       `json:"is_insertable_into"`           // is_insertable_into
	IsTyped                   pgtypes.YesOrNo       `json:"is_typed"`                     // is_typed
	CommitAction              pgtypes.CharacterData `json:"commit_action"`                // commit_action
}

Table represents a row from 'information_schema.tables'.

type TableConstraint ¶

type TableConstraint struct {
	ConstraintCatalog pgtypes.SQLIdentifier `json:"constraint_catalog"` // constraint_catalog
	ConstraintSchema  pgtypes.SQLIdentifier `json:"constraint_schema"`  // constraint_schema
	ConstraintName    pgtypes.SQLIdentifier `json:"constraint_name"`    // constraint_name
	TableCatalog      pgtypes.SQLIdentifier `json:"table_catalog"`      // table_catalog
	TableSchema       pgtypes.SQLIdentifier `json:"table_schema"`       // table_schema
	TableName         pgtypes.SQLIdentifier `json:"table_name"`         // table_name
	ConstraintType    pgtypes.CharacterData `json:"constraint_type"`    // constraint_type
	IsDeferrable      pgtypes.YesOrNo       `json:"is_deferrable"`      // is_deferrable
	InitiallyDeferred pgtypes.YesOrNo       `json:"initially_deferred"` // initially_deferred
}

TableConstraint represents a row from 'information_schema.table_constraints'.

type TablePrivilege ¶

type TablePrivilege struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	TableCatalog  pgtypes.SQLIdentifier `json:"table_catalog"`  // table_catalog
	TableSchema   pgtypes.SQLIdentifier `json:"table_schema"`   // table_schema
	TableName     pgtypes.SQLIdentifier `json:"table_name"`     // table_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
	WithHierarchy pgtypes.YesOrNo       `json:"with_hierarchy"` // with_hierarchy
}

TablePrivilege represents a row from 'information_schema.table_privileges'.

type Transform ¶

type Transform struct {
	UdtCatalog      pgtypes.SQLIdentifier `json:"udt_catalog"`      // udt_catalog
	UdtSchema       pgtypes.SQLIdentifier `json:"udt_schema"`       // udt_schema
	UdtName         pgtypes.SQLIdentifier `json:"udt_name"`         // udt_name
	SpecificCatalog pgtypes.SQLIdentifier `json:"specific_catalog"` // specific_catalog
	SpecificSchema  pgtypes.SQLIdentifier `json:"specific_schema"`  // specific_schema
	SpecificName    pgtypes.SQLIdentifier `json:"specific_name"`    // specific_name
	GroupName       pgtypes.SQLIdentifier `json:"group_name"`       // group_name
	TransformType   pgtypes.CharacterData `json:"transform_type"`   // transform_type
}

Transform represents a row from 'information_schema.transforms'.

type Trigger ¶

type Trigger struct {
	TriggerCatalog          pgtypes.SQLIdentifier  `json:"trigger_catalog"`            // trigger_catalog
	TriggerSchema           pgtypes.SQLIdentifier  `json:"trigger_schema"`             // trigger_schema
	TriggerName             pgtypes.SQLIdentifier  `json:"trigger_name"`               // trigger_name
	EventManipulation       pgtypes.CharacterData  `json:"event_manipulation"`         // event_manipulation
	EventObjectCatalog      pgtypes.SQLIdentifier  `json:"event_object_catalog"`       // event_object_catalog
	EventObjectSchema       pgtypes.SQLIdentifier  `json:"event_object_schema"`        // event_object_schema
	EventObjectTable        pgtypes.SQLIdentifier  `json:"event_object_table"`         // event_object_table
	ActionOrder             pgtypes.CardinalNumber `json:"action_order"`               // action_order
	ActionCondition         pgtypes.CharacterData  `json:"action_condition"`           // action_condition
	ActionStatement         pgtypes.CharacterData  `json:"action_statement"`           // action_statement
	ActionOrientation       pgtypes.CharacterData  `json:"action_orientation"`         // action_orientation
	ActionTiming            pgtypes.CharacterData  `json:"action_timing"`              // action_timing
	ActionReferenceOldTable pgtypes.SQLIdentifier  `json:"action_reference_old_table"` // action_reference_old_table
	ActionReferenceNewTable pgtypes.SQLIdentifier  `json:"action_reference_new_table"` // action_reference_new_table
	ActionReferenceOldRow   pgtypes.SQLIdentifier  `json:"action_reference_old_row"`   // action_reference_old_row
	ActionReferenceNewRow   pgtypes.SQLIdentifier  `json:"action_reference_new_row"`   // action_reference_new_row
	Created                 pgtypes.TimeStamp      `json:"created"`                    // created
}

Trigger represents a row from 'information_schema.triggers'.

type TriggeredUpdateColumn ¶

type TriggeredUpdateColumn struct {
	TriggerCatalog     pgtypes.SQLIdentifier `json:"trigger_catalog"`      // trigger_catalog
	TriggerSchema      pgtypes.SQLIdentifier `json:"trigger_schema"`       // trigger_schema
	TriggerName        pgtypes.SQLIdentifier `json:"trigger_name"`         // trigger_name
	EventObjectCatalog pgtypes.SQLIdentifier `json:"event_object_catalog"` // event_object_catalog
	EventObjectSchema  pgtypes.SQLIdentifier `json:"event_object_schema"`  // event_object_schema
	EventObjectTable   pgtypes.SQLIdentifier `json:"event_object_table"`   // event_object_table
	EventObjectColumn  pgtypes.SQLIdentifier `json:"event_object_column"`  // event_object_column
}

TriggeredUpdateColumn represents a row from 'information_schema.triggered_update_columns'.

type UdtPrivilege ¶

type UdtPrivilege struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	UdtCatalog    pgtypes.SQLIdentifier `json:"udt_catalog"`    // udt_catalog
	UdtSchema     pgtypes.SQLIdentifier `json:"udt_schema"`     // udt_schema
	UdtName       pgtypes.SQLIdentifier `json:"udt_name"`       // udt_name
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

UdtPrivilege represents a row from 'information_schema.udt_privileges'.

type UsagePrivilege ¶

type UsagePrivilege struct {
	Grantor       pgtypes.SQLIdentifier `json:"grantor"`        // grantor
	Grantee       pgtypes.SQLIdentifier `json:"grantee"`        // grantee
	ObjectCatalog pgtypes.SQLIdentifier `json:"object_catalog"` // object_catalog
	ObjectSchema  pgtypes.SQLIdentifier `json:"object_schema"`  // object_schema
	ObjectName    pgtypes.SQLIdentifier `json:"object_name"`    // object_name
	ObjectType    pgtypes.CharacterData `json:"object_type"`    // object_type
	PrivilegeType pgtypes.CharacterData `json:"privilege_type"` // privilege_type
	IsGrantable   pgtypes.YesOrNo       `json:"is_grantable"`   // is_grantable
}

UsagePrivilege represents a row from 'information_schema.usage_privileges'.

type UserDefinedType ¶

type UserDefinedType struct {
	UserDefinedTypeCatalog  pgtypes.SQLIdentifier  `json:"user_defined_type_catalog"`  // user_defined_type_catalog
	UserDefinedTypeSchema   pgtypes.SQLIdentifier  `json:"user_defined_type_schema"`   // user_defined_type_schema
	UserDefinedTypeName     pgtypes.SQLIdentifier  `json:"user_defined_type_name"`     // user_defined_type_name
	UserDefinedTypeCategory pgtypes.CharacterData  `json:"user_defined_type_category"` // user_defined_type_category
	IsInstantiable          pgtypes.YesOrNo        `json:"is_instantiable"`            // is_instantiable
	IsFinal                 pgtypes.YesOrNo        `json:"is_final"`                   // is_final
	OrderingForm            pgtypes.CharacterData  `json:"ordering_form"`              // ordering_form
	OrderingCategory        pgtypes.CharacterData  `json:"ordering_category"`          // ordering_category
	OrderingRoutineCatalog  pgtypes.SQLIdentifier  `json:"ordering_routine_catalog"`   // ordering_routine_catalog
	OrderingRoutineSchema   pgtypes.SQLIdentifier  `json:"ordering_routine_schema"`    // ordering_routine_schema
	OrderingRoutineName     pgtypes.SQLIdentifier  `json:"ordering_routine_name"`      // ordering_routine_name
	ReferenceType           pgtypes.CharacterData  `json:"reference_type"`             // reference_type
	DataType                pgtypes.CharacterData  `json:"data_type"`                  // data_type
	CharacterMaximumLength  pgtypes.CardinalNumber `json:"character_maximum_length"`   // character_maximum_length
	CharacterOctetLength    pgtypes.CardinalNumber `json:"character_octet_length"`     // character_octet_length
	CharacterSetCatalog     pgtypes.SQLIdentifier  `json:"character_set_catalog"`      // character_set_catalog
	CharacterSetSchema      pgtypes.SQLIdentifier  `json:"character_set_schema"`       // character_set_schema
	CharacterSetName        pgtypes.SQLIdentifier  `json:"character_set_name"`         // character_set_name
	CollationCatalog        pgtypes.SQLIdentifier  `json:"collation_catalog"`          // collation_catalog
	CollationSchema         pgtypes.SQLIdentifier  `json:"collation_schema"`           // collation_schema
	CollationName           pgtypes.SQLIdentifier  `json:"collation_name"`             // collation_name
	NumericPrecision        pgtypes.CardinalNumber `json:"numeric_precision"`          // numeric_precision
	NumericPrecisionRadix   pgtypes.CardinalNumber `json:"numeric_precision_radix"`    // numeric_precision_radix
	NumericScale            pgtypes.CardinalNumber `json:"numeric_scale"`              // numeric_scale
	DatetimePrecision       pgtypes.CardinalNumber `json:"datetime_precision"`         // datetime_precision
	IntervalType            pgtypes.CharacterData  `json:"interval_type"`              // interval_type
	IntervalPrecision       pgtypes.CardinalNumber `json:"interval_precision"`         // interval_precision
	SourceDtdIdentifier     pgtypes.SQLIdentifier  `json:"source_dtd_identifier"`      // source_dtd_identifier
	RefDtdIdentifier        pgtypes.SQLIdentifier  `json:"ref_dtd_identifier"`         // ref_dtd_identifier
}

UserDefinedType represents a row from 'information_schema.user_defined_types'.

type UserMapping ¶

type UserMapping struct {
	AuthorizationIdentifier pgtypes.SQLIdentifier `json:"authorization_identifier"` // authorization_identifier
	ForeignServerCatalog    pgtypes.SQLIdentifier `json:"foreign_server_catalog"`   // foreign_server_catalog
	ForeignServerName       pgtypes.SQLIdentifier `json:"foreign_server_name"`      // foreign_server_name
}

UserMapping represents a row from 'information_schema.user_mappings'.

type UserMappingOption ¶

type UserMappingOption struct {
	AuthorizationIdentifier pgtypes.SQLIdentifier `json:"authorization_identifier"` // authorization_identifier
	ForeignServerCatalog    pgtypes.SQLIdentifier `json:"foreign_server_catalog"`   // foreign_server_catalog
	ForeignServerName       pgtypes.SQLIdentifier `json:"foreign_server_name"`      // foreign_server_name
	OptionName              pgtypes.SQLIdentifier `json:"option_name"`              // option_name
	OptionValue             pgtypes.CharacterData `json:"option_value"`             // option_value
}

UserMappingOption represents a row from 'information_schema.user_mapping_options'.

type View ¶

type View struct {
	TableCatalog            pgtypes.SQLIdentifier `json:"table_catalog"`              // table_catalog
	TableSchema             pgtypes.SQLIdentifier `json:"table_schema"`               // table_schema
	TableName               pgtypes.SQLIdentifier `json:"table_name"`                 // table_name
	ViewDefinition          pgtypes.CharacterData `json:"view_definition"`            // view_definition
	CheckOption             pgtypes.CharacterData `json:"check_option"`               // check_option
	IsUpdatable             pgtypes.YesOrNo       `json:"is_updatable"`               // is_updatable
	IsInsertableInto        pgtypes.YesOrNo       `json:"is_insertable_into"`         // is_insertable_into
	IsTriggerUpdatable      pgtypes.YesOrNo       `json:"is_trigger_updatable"`       // is_trigger_updatable
	IsTriggerDeletable      pgtypes.YesOrNo       `json:"is_trigger_deletable"`       // is_trigger_deletable
	IsTriggerInsertableInto pgtypes.YesOrNo       `json:"is_trigger_insertable_into"` // is_trigger_insertable_into
}

View represents a row from 'information_schema.views'.

type ViewColumnUsage ¶

type ViewColumnUsage struct {
	ViewCatalog  pgtypes.SQLIdentifier `json:"view_catalog"`  // view_catalog
	ViewSchema   pgtypes.SQLIdentifier `json:"view_schema"`   // view_schema
	ViewName     pgtypes.SQLIdentifier `json:"view_name"`     // view_name
	TableCatalog pgtypes.SQLIdentifier `json:"table_catalog"` // table_catalog
	TableSchema  pgtypes.SQLIdentifier `json:"table_schema"`  // table_schema
	TableName    pgtypes.SQLIdentifier `json:"table_name"`    // table_name
	ColumnName   pgtypes.SQLIdentifier `json:"column_name"`   // column_name
}

ViewColumnUsage represents a row from 'information_schema.view_column_usage'.

type ViewRoutineUsage ¶

type ViewRoutineUsage struct {
	TableCatalog    pgtypes.SQLIdentifier `json:"table_catalog"`    // table_catalog
	TableSchema     pgtypes.SQLIdentifier `json:"table_schema"`     // table_schema
	TableName       pgtypes.SQLIdentifier `json:"table_name"`       // table_name
	SpecificCatalog pgtypes.SQLIdentifier `json:"specific_catalog"` // specific_catalog
	SpecificSchema  pgtypes.SQLIdentifier `json:"specific_schema"`  // specific_schema
	SpecificName    pgtypes.SQLIdentifier `json:"specific_name"`    // specific_name
}

ViewRoutineUsage represents a row from 'information_schema.view_routine_usage'.

type ViewTableUsage ¶

type ViewTableUsage struct {
	ViewCatalog  pgtypes.SQLIdentifier `json:"view_catalog"`  // view_catalog
	ViewSchema   pgtypes.SQLIdentifier `json:"view_schema"`   // view_schema
	ViewName     pgtypes.SQLIdentifier `json:"view_name"`     // view_name
	TableCatalog pgtypes.SQLIdentifier `json:"table_catalog"` // table_catalog
	TableSchema  pgtypes.SQLIdentifier `json:"table_schema"`  // table_schema
	TableName    pgtypes.SQLIdentifier `json:"table_name"`    // table_name
}

ViewTableUsage represents a row from 'information_schema.view_table_usage'.

type XODB ¶

type XODB interface {
	Exec(string, ...interface{}) (sql.Result, error)
	Query(string, ...interface{}) (*sql.Rows, error)
	QueryRow(string, ...interface{}) *sql.Row
}

XODB is the common interface for database operations that can be used with types from schema 'information_schema'.

This should work with database/sql.DB and database/sql.Tx.

Source Files ¶

View all Source files

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