/_examples/pgcatalog/pgcatalog/pgcatalog.xo.go
Go | 12072 lines | 8683 code | 860 blank | 2529 comment | 1475 complexity | e0ce5dccc891ed58e1e979f4aca9e850 MD5 | raw file
- // Package pgcatalog contains generated code for schema 'pg_catalog'.
- package pgcatalog
- // Code generated by xo. DO NOT EDIT.
- import (
- "context"
- "database/sql"
- "database/sql/driver"
- "encoding/csv"
- "fmt"
- "io"
- "regexp"
- "strings"
- "time"
- "github.com/xo/xo/_examples/pgcatalog/pgtypes"
- "github.com/google/uuid"
- )
- var (
- // logf is used by generated code to log SQL queries.
- logf = func(string, ...interface{}) {}
- // errf is used by generated code to log SQL errors.
- errf = func(string, ...interface{}) {}
- )
- // logerror logs the error and returns it.
- func logerror(err error) error {
- errf("ERROR: %v", err)
- return err
- }
- // Logf logs a message using the package logger.
- func Logf(s string, v ...interface{}) {
- logf(s, v...)
- }
- // SetLogger sets the package logger. Valid logger types:
- //
- // io.Writer
- // func(string, ...interface{}) (int, error) // fmt.Printf
- // func(string, ...interface{}) // log.Printf
- //
- func SetLogger(logger interface{}) {
- logf = convLogger(logger)
- }
- // Errorf logs an error message using the package error logger.
- func Errorf(s string, v ...interface{}) {
- errf(s, v...)
- }
- // SetErrorLogger sets the package error logger. Valid logger types:
- //
- // io.Writer
- // func(string, ...interface{}) (int, error) // fmt.Printf
- // func(string, ...interface{}) // log.Printf
- //
- func SetErrorLogger(logger interface{}) {
- errf = convLogger(logger)
- }
- // convLogger converts logger to the standard logger interface.
- func convLogger(logger interface{}) func(string, ...interface{}) {
- switch z := logger.(type) {
- case io.Writer:
- return func(s string, v ...interface{}) {
- fmt.Fprintf(z, s, v...)
- }
- case func(string, ...interface{}) (int, error): // fmt.Printf
- return func(s string, v ...interface{}) {
- _, _ = z(s, v...)
- }
- case func(string, ...interface{}): // log.Printf
- return z
- }
- panic(fmt.Sprintf("unsupported logger type %T", logger))
- }
- // DB is the common interface for database operations that can be used with
- // types from schema 'pg_catalog'.
- //
- // This works with both database/sql.DB and database/sql.Tx.
- type DB interface {
- ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
- QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
- QueryRowContext(context.Context, string, ...interface{}) *sql.Row
- }
- // Error is an error.
- type Error string
- // Error satisfies the error interface.
- func (err Error) Error() string {
- return string(err)
- }
- // Error values.
- const (
- // ErrAlreadyExists is the already exists error.
- ErrAlreadyExists Error = "already exists"
- // ErrDoesNotExist is the does not exist error.
- ErrDoesNotExist Error = "does not exist"
- // ErrMarkedForDeletion is the marked for deletion error.
- ErrMarkedForDeletion Error = "marked for deletion"
- )
- // ErrInsertFailed is the insert failed error.
- type ErrInsertFailed struct {
- Err error
- }
- // Error satisfies the error interface.
- func (err *ErrInsertFailed) Error() string {
- return fmt.Sprintf("insert failed: %v", err.Err)
- }
- // Unwrap satisfies the unwrap interface.
- func (err *ErrInsertFailed) Unwrap() error {
- return err.Err
- }
- // ErrUpdateFailed is the update failed error.
- type ErrUpdateFailed struct {
- Err error
- }
- // Error satisfies the error interface.
- func (err *ErrUpdateFailed) Error() string {
- return fmt.Sprintf("update failed: %v", err.Err)
- }
- // Unwrap satisfies the unwrap interface.
- func (err *ErrUpdateFailed) Unwrap() error {
- return err.Err
- }
- // ErrUpsertFailed is the upsert failed error.
- type ErrUpsertFailed struct {
- Err error
- }
- // Error satisfies the error interface.
- func (err *ErrUpsertFailed) Error() string {
- return fmt.Sprintf("upsert failed: %v", err.Err)
- }
- // Unwrap satisfies the unwrap interface.
- func (err *ErrUpsertFailed) Unwrap() error {
- return err.Err
- }
- // ErrDecodeFailed is the decode failed error.
- type ErrDecodeFailed struct {
- Err error
- }
- // Error satisfies the error interface.
- func (err *ErrDecodeFailed) Error() string {
- return fmt.Sprintf("unable to decode: %v", err.Err)
- }
- // Unwrap satisfies the unwrap interface.
- func (err *ErrDecodeFailed) Unwrap() error {
- return err.Err
- }
- // ErrInvalidStringSlice is the invalid StringSlice error.
- const ErrInvalidStringSlice Error = "invalid StringSlice"
- // StringSlice is a slice of strings.
- type StringSlice []string
- // Scan satisfies the sql.Scanner interface for StringSlice.
- func (ss *StringSlice) Scan(v interface{}) error {
- buf, ok := v.([]byte)
- if !ok {
- return logerror(ErrInvalidStringSlice)
- }
- // change quote escapes for csv parser
- str := strings.Replace(quoteEscRE.ReplaceAllString(string(buf), `$1""`), `\\`, `\`, -1)
- str = str[1 : len(str)-1]
- // bail if only one
- if len(str) == 0 {
- return nil
- }
- // parse with csv reader
- r := csv.NewReader(strings.NewReader(str))
- line, err := r.Read()
- if err != nil {
- return logerror(&ErrDecodeFailed{err})
- }
- *ss = StringSlice(line)
- return nil
- }
- // quoteEscRE matches escaped characters in a string.
- var quoteEscRE = regexp.MustCompile(`([^\\]([\\]{2})*)\\"`)
- // Value satisfies the sql/driver.Valuer interface.
- func (ss StringSlice) Value() (driver.Value, error) {
- v := make([]string, len(ss))
- for i, s := range ss {
- v[i] = `"` + strings.Replace(strings.Replace(s, `\`, `\\\`, -1), `"`, `\"`, -1) + `"`
- }
- return "{" + strings.Join(v, ",") + "}", nil
- }
- // PgAggregate represents a row from 'pg_catalog.pg_aggregate'.
- type PgAggregate 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
- Aggfnoid pgtypes.Regproc `json:"aggfnoid"` // aggfnoid
- Aggkind pgtypes.Char `json:"aggkind"` // aggkind
- Aggnumdirectargs int16 `json:"aggnumdirectargs"` // aggnumdirectargs
- Aggtransfn pgtypes.Regproc `json:"aggtransfn"` // aggtransfn
- Aggfinalfn pgtypes.Regproc `json:"aggfinalfn"` // aggfinalfn
- Aggcombinefn pgtypes.Regproc `json:"aggcombinefn"` // aggcombinefn
- Aggserialfn pgtypes.Regproc `json:"aggserialfn"` // aggserialfn
- Aggdeserialfn pgtypes.Regproc `json:"aggdeserialfn"` // aggdeserialfn
- Aggmtransfn pgtypes.Regproc `json:"aggmtransfn"` // aggmtransfn
- Aggminvtransfn pgtypes.Regproc `json:"aggminvtransfn"` // aggminvtransfn
- Aggmfinalfn pgtypes.Regproc `json:"aggmfinalfn"` // aggmfinalfn
- Aggfinalextra bool `json:"aggfinalextra"` // aggfinalextra
- Aggmfinalextra bool `json:"aggmfinalextra"` // aggmfinalextra
- Aggfinalmodify pgtypes.Char `json:"aggfinalmodify"` // aggfinalmodify
- Aggmfinalmodify pgtypes.Char `json:"aggmfinalmodify"` // aggmfinalmodify
- Aggsortop pgtypes.Oid `json:"aggsortop"` // aggsortop
- Aggtranstype pgtypes.Oid `json:"aggtranstype"` // aggtranstype
- Aggtransspace int `json:"aggtransspace"` // aggtransspace
- Aggmtranstype pgtypes.Oid `json:"aggmtranstype"` // aggmtranstype
- Aggmtransspace int `json:"aggmtransspace"` // aggmtransspace
- Agginitval sql.NullString `json:"agginitval"` // agginitval
- Aggminitval sql.NullString `json:"aggminitval"` // aggminitval
- }
- // PgAm represents a row from 'pg_catalog.pg_am'.
- type PgAm 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Amname string `json:"amname"` // amname
- Amhandler pgtypes.Regproc `json:"amhandler"` // amhandler
- Amtype pgtypes.Char `json:"amtype"` // amtype
- }
- // PgAmop represents a row from 'pg_catalog.pg_amop'.
- type PgAmop 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Amopfamily pgtypes.Oid `json:"amopfamily"` // amopfamily
- Amoplefttype pgtypes.Oid `json:"amoplefttype"` // amoplefttype
- Amoprighttype pgtypes.Oid `json:"amoprighttype"` // amoprighttype
- Amopstrategy int16 `json:"amopstrategy"` // amopstrategy
- Amoppurpose pgtypes.Char `json:"amoppurpose"` // amoppurpose
- Amopopr pgtypes.Oid `json:"amopopr"` // amopopr
- Amopmethod pgtypes.Oid `json:"amopmethod"` // amopmethod
- Amopsortfamily pgtypes.Oid `json:"amopsortfamily"` // amopsortfamily
- }
- // PgAmproc represents a row from 'pg_catalog.pg_amproc'.
- type PgAmproc 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Amprocfamily pgtypes.Oid `json:"amprocfamily"` // amprocfamily
- Amproclefttype pgtypes.Oid `json:"amproclefttype"` // amproclefttype
- Amprocrighttype pgtypes.Oid `json:"amprocrighttype"` // amprocrighttype
- Amprocnum int16 `json:"amprocnum"` // amprocnum
- Amproc pgtypes.Regproc `json:"amproc"` // amproc
- }
- // PgAttrdef represents a row from 'pg_catalog.pg_attrdef'.
- type PgAttrdef 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Adrelid pgtypes.Oid `json:"adrelid"` // adrelid
- Adnum int16 `json:"adnum"` // adnum
- Adbin pgtypes.PgNodeTree `json:"adbin"` // adbin
- }
- // PgAttribute represents a row from 'pg_catalog.pg_attribute'.
- type PgAttribute 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
- Attrelid pgtypes.Oid `json:"attrelid"` // attrelid
- Attname string `json:"attname"` // attname
- Atttypid pgtypes.Oid `json:"atttypid"` // atttypid
- Attstattarget int `json:"attstattarget"` // attstattarget
- Attlen int16 `json:"attlen"` // attlen
- Attnum int16 `json:"attnum"` // attnum
- Attndims int `json:"attndims"` // attndims
- Attcacheoff int `json:"attcacheoff"` // attcacheoff
- Atttypmod int `json:"atttypmod"` // atttypmod
- Attbyval bool `json:"attbyval"` // attbyval
- Attstorage pgtypes.Char `json:"attstorage"` // attstorage
- Attalign pgtypes.Char `json:"attalign"` // attalign
- Attnotnull bool `json:"attnotnull"` // attnotnull
- Atthasdef bool `json:"atthasdef"` // atthasdef
- Atthasmissing bool `json:"atthasmissing"` // atthasmissing
- Attidentity pgtypes.Char `json:"attidentity"` // attidentity
- Attgenerated pgtypes.Char `json:"attgenerated"` // attgenerated
- Attisdropped bool `json:"attisdropped"` // attisdropped
- Attislocal bool `json:"attislocal"` // attislocal
- Attinhcount int `json:"attinhcount"` // attinhcount
- Attcollation pgtypes.Oid `json:"attcollation"` // attcollation
- Attacl []pgtypes.NullAclitem `json:"attacl"` // attacl
- Attoptions []sql.NullString `json:"attoptions"` // attoptions
- Attfdwoptions []sql.NullString `json:"attfdwoptions"` // attfdwoptions
- Attmissingval pgtypes.NullAnyarray `json:"attmissingval"` // attmissingval
- }
- // PgAuthMember represents a row from 'pg_catalog.pg_auth_members'.
- type PgAuthMember 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
- Roleid pgtypes.Oid `json:"roleid"` // roleid
- Member pgtypes.Oid `json:"member"` // member
- Grantor pgtypes.Oid `json:"grantor"` // grantor
- AdminOption bool `json:"admin_option"` // admin_option
- }
- // PgAuthid represents a row from 'pg_catalog.pg_authid'.
- type PgAuthid 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Rolname string `json:"rolname"` // rolname
- Rolsuper bool `json:"rolsuper"` // rolsuper
- Rolinherit bool `json:"rolinherit"` // rolinherit
- Rolcreaterole bool `json:"rolcreaterole"` // rolcreaterole
- Rolcreatedb bool `json:"rolcreatedb"` // rolcreatedb
- Rolcanlogin bool `json:"rolcanlogin"` // rolcanlogin
- Rolreplication bool `json:"rolreplication"` // rolreplication
- Rolbypassrls bool `json:"rolbypassrls"` // rolbypassrls
- Rolconnlimit int `json:"rolconnlimit"` // rolconnlimit
- Rolpassword sql.NullString `json:"rolpassword"` // rolpassword
- Rolvaliduntil sql.NullTime `json:"rolvaliduntil"` // rolvaliduntil
- }
- // PgAvailableExtension represents a row from 'pg_catalog.pg_available_extensions'.
- type PgAvailableExtension struct {
- Name sql.NullString `json:"name"` // name
- DefaultVersion sql.NullString `json:"default_version"` // default_version
- InstalledVersion sql.NullString `json:"installed_version"` // installed_version
- Comment sql.NullString `json:"comment"` // comment
- }
- // PgAvailableExtensionVersion represents a row from 'pg_catalog.pg_available_extension_versions'.
- type PgAvailableExtensionVersion struct {
- Name sql.NullString `json:"name"` // name
- Version sql.NullString `json:"version"` // version
- Installed sql.NullBool `json:"installed"` // installed
- Superuser sql.NullBool `json:"superuser"` // superuser
- Trusted sql.NullBool `json:"trusted"` // trusted
- Relocatable sql.NullBool `json:"relocatable"` // relocatable
- Schema sql.NullString `json:"schema"` // schema
- Requires []sql.NullString `json:"requires"` // requires
- Comment sql.NullString `json:"comment"` // comment
- }
- // PgCast represents a row from 'pg_catalog.pg_cast'.
- type PgCast 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Castsource pgtypes.Oid `json:"castsource"` // castsource
- Casttarget pgtypes.Oid `json:"casttarget"` // casttarget
- Castfunc pgtypes.Oid `json:"castfunc"` // castfunc
- Castcontext pgtypes.Char `json:"castcontext"` // castcontext
- Castmethod pgtypes.Char `json:"castmethod"` // castmethod
- }
- // PgClass represents a row from 'pg_catalog.pg_class'.
- type PgClass 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Relname string `json:"relname"` // relname
- Relnamespace pgtypes.Oid `json:"relnamespace"` // relnamespace
- Reltype pgtypes.Oid `json:"reltype"` // reltype
- Reloftype pgtypes.Oid `json:"reloftype"` // reloftype
- Relowner pgtypes.Oid `json:"relowner"` // relowner
- Relam pgtypes.Oid `json:"relam"` // relam
- Relfilenode pgtypes.Oid `json:"relfilenode"` // relfilenode
- Reltablespace pgtypes.Oid `json:"reltablespace"` // reltablespace
- Relpages int `json:"relpages"` // relpages
- Reltuples float32 `json:"reltuples"` // reltuples
- Relallvisible int `json:"relallvisible"` // relallvisible
- Reltoastrelid pgtypes.Oid `json:"reltoastrelid"` // reltoastrelid
- Relhasindex bool `json:"relhasindex"` // relhasindex
- Relisshared bool `json:"relisshared"` // relisshared
- Relpersistence pgtypes.Char `json:"relpersistence"` // relpersistence
- Relkind pgtypes.Char `json:"relkind"` // relkind
- Relnatts int16 `json:"relnatts"` // relnatts
- Relchecks int16 `json:"relchecks"` // relchecks
- Relhasrules bool `json:"relhasrules"` // relhasrules
- Relhastriggers bool `json:"relhastriggers"` // relhastriggers
- Relhassubclass bool `json:"relhassubclass"` // relhassubclass
- Relrowsecurity bool `json:"relrowsecurity"` // relrowsecurity
- Relforcerowsecurity bool `json:"relforcerowsecurity"` // relforcerowsecurity
- Relispopulated bool `json:"relispopulated"` // relispopulated
- Relreplident pgtypes.Char `json:"relreplident"` // relreplident
- Relispartition bool `json:"relispartition"` // relispartition
- Relrewrite pgtypes.Oid `json:"relrewrite"` // relrewrite
- Relfrozenxid pgtypes.Xid `json:"relfrozenxid"` // relfrozenxid
- Relminmxid pgtypes.Xid `json:"relminmxid"` // relminmxid
- Relacl []pgtypes.NullAclitem `json:"relacl"` // relacl
- Reloptions []sql.NullString `json:"reloptions"` // reloptions
- Relpartbound pgtypes.NullPgNodeTree `json:"relpartbound"` // relpartbound
- }
- // PgCollation represents a row from 'pg_catalog.pg_collation'.
- type PgCollation 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Collname string `json:"collname"` // collname
- Collnamespace pgtypes.Oid `json:"collnamespace"` // collnamespace
- Collowner pgtypes.Oid `json:"collowner"` // collowner
- Collprovider pgtypes.Char `json:"collprovider"` // collprovider
- Collisdeterministic bool `json:"collisdeterministic"` // collisdeterministic
- Collencoding int `json:"collencoding"` // collencoding
- Collcollate string `json:"collcollate"` // collcollate
- Collctype string `json:"collctype"` // collctype
- Collversion sql.NullString `json:"collversion"` // collversion
- }
- // PgConfig represents a row from 'pg_catalog.pg_config'.
- type PgConfig struct {
- Name sql.NullString `json:"name"` // name
- Setting sql.NullString `json:"setting"` // setting
- }
- // PgConstraint represents a row from 'pg_catalog.pg_constraint'.
- type PgConstraint 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Conname string `json:"conname"` // conname
- Connamespace pgtypes.Oid `json:"connamespace"` // connamespace
- Contype pgtypes.Char `json:"contype"` // contype
- Condeferrable bool `json:"condeferrable"` // condeferrable
- Condeferred bool `json:"condeferred"` // condeferred
- Convalidated bool `json:"convalidated"` // convalidated
- Conrelid pgtypes.Oid `json:"conrelid"` // conrelid
- Contypid pgtypes.Oid `json:"contypid"` // contypid
- Conindid pgtypes.Oid `json:"conindid"` // conindid
- Conparentid pgtypes.Oid `json:"conparentid"` // conparentid
- Confrelid pgtypes.Oid `json:"confrelid"` // confrelid
- Confupdtype pgtypes.Char `json:"confupdtype"` // confupdtype
- Confdeltype pgtypes.Char `json:"confdeltype"` // confdeltype
- Confmatchtype pgtypes.Char `json:"confmatchtype"` // confmatchtype
- Conislocal bool `json:"conislocal"` // conislocal
- Coninhcount int `json:"coninhcount"` // coninhcount
- Connoinherit bool `json:"connoinherit"` // connoinherit
- Conkey []sql.NullInt64 `json:"conkey"` // conkey
- Confkey []sql.NullInt64 `json:"confkey"` // confkey
- Conpfeqop []pgtypes.NullOid `json:"conpfeqop"` // conpfeqop
- Conppeqop []pgtypes.NullOid `json:"conppeqop"` // conppeqop
- Conffeqop []pgtypes.NullOid `json:"conffeqop"` // conffeqop
- Conexclop []pgtypes.NullOid `json:"conexclop"` // conexclop
- Conbin pgtypes.NullPgNodeTree `json:"conbin"` // conbin
- }
- // PgConversion represents a row from 'pg_catalog.pg_conversion'.
- type PgConversion 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Conname string `json:"conname"` // conname
- Connamespace pgtypes.Oid `json:"connamespace"` // connamespace
- Conowner pgtypes.Oid `json:"conowner"` // conowner
- Conforencoding int `json:"conforencoding"` // conforencoding
- Contoencoding int `json:"contoencoding"` // contoencoding
- Conproc pgtypes.Regproc `json:"conproc"` // conproc
- Condefault bool `json:"condefault"` // condefault
- }
- // PgCursor represents a row from 'pg_catalog.pg_cursors'.
- type PgCursor struct {
- Name sql.NullString `json:"name"` // name
- Statement sql.NullString `json:"statement"` // statement
- IsHoldable sql.NullBool `json:"is_holdable"` // is_holdable
- IsBinary sql.NullBool `json:"is_binary"` // is_binary
- IsScrollable sql.NullBool `json:"is_scrollable"` // is_scrollable
- CreationTime sql.NullTime `json:"creation_time"` // creation_time
- }
- // PgDatabase represents a row from 'pg_catalog.pg_database'.
- type PgDatabase 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Datname string `json:"datname"` // datname
- Datdba pgtypes.Oid `json:"datdba"` // datdba
- Encoding int `json:"encoding"` // encoding
- Datcollate string `json:"datcollate"` // datcollate
- Datctype string `json:"datctype"` // datctype
- Datistemplate bool `json:"datistemplate"` // datistemplate
- Datallowconn bool `json:"datallowconn"` // datallowconn
- Datconnlimit int `json:"datconnlimit"` // datconnlimit
- Datlastsysoid pgtypes.Oid `json:"datlastsysoid"` // datlastsysoid
- Datfrozenxid pgtypes.Xid `json:"datfrozenxid"` // datfrozenxid
- Datminmxid pgtypes.Xid `json:"datminmxid"` // datminmxid
- Dattablespace pgtypes.Oid `json:"dattablespace"` // dattablespace
- Datacl []pgtypes.NullAclitem `json:"datacl"` // datacl
- }
- // PgDbRoleSetting represents a row from 'pg_catalog.pg_db_role_setting'.
- type PgDbRoleSetting 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
- Setdatabase pgtypes.Oid `json:"setdatabase"` // setdatabase
- Setrole pgtypes.Oid `json:"setrole"` // setrole
- Setconfig []sql.NullString `json:"setconfig"` // setconfig
- }
- // PgDefaultACL represents a row from 'pg_catalog.pg_default_acl'.
- type PgDefaultACL 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Defaclrole pgtypes.Oid `json:"defaclrole"` // defaclrole
- Defaclnamespace pgtypes.Oid `json:"defaclnamespace"` // defaclnamespace
- Defaclobjtype pgtypes.Char `json:"defaclobjtype"` // defaclobjtype
- Defaclacl []pgtypes.Aclitem `json:"defaclacl"` // defaclacl
- }
- // PgDepend represents a row from 'pg_catalog.pg_depend'.
- type PgDepend 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
- Classid pgtypes.Oid `json:"classid"` // classid
- Objid pgtypes.Oid `json:"objid"` // objid
- Objsubid int `json:"objsubid"` // objsubid
- Refclassid pgtypes.Oid `json:"refclassid"` // refclassid
- Refobjid pgtypes.Oid `json:"refobjid"` // refobjid
- Refobjsubid int `json:"refobjsubid"` // refobjsubid
- Deptype pgtypes.Char `json:"deptype"` // deptype
- }
- // PgDescription represents a row from 'pg_catalog.pg_description'.
- type PgDescription 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
- Objoid pgtypes.Oid `json:"objoid"` // objoid
- Classoid pgtypes.Oid `json:"classoid"` // classoid
- Objsubid int `json:"objsubid"` // objsubid
- Description string `json:"description"` // description
- }
- // PgEnum represents a row from 'pg_catalog.pg_enum'.
- type PgEnum 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Enumtypid pgtypes.Oid `json:"enumtypid"` // enumtypid
- Enumsortorder float32 `json:"enumsortorder"` // enumsortorder
- Enumlabel string `json:"enumlabel"` // enumlabel
- }
- // PgEventTrigger represents a row from 'pg_catalog.pg_event_trigger'.
- type PgEventTrigger 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Evtname string `json:"evtname"` // evtname
- Evtevent string `json:"evtevent"` // evtevent
- Evtowner pgtypes.Oid `json:"evtowner"` // evtowner
- Evtfoid pgtypes.Oid `json:"evtfoid"` // evtfoid
- Evtenabled pgtypes.Char `json:"evtenabled"` // evtenabled
- Evttags []sql.NullString `json:"evttags"` // evttags
- }
- // PgExtension represents a row from 'pg_catalog.pg_extension'.
- type PgExtension 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Extname string `json:"extname"` // extname
- Extowner pgtypes.Oid `json:"extowner"` // extowner
- Extnamespace pgtypes.Oid `json:"extnamespace"` // extnamespace
- Extrelocatable bool `json:"extrelocatable"` // extrelocatable
- Extversion string `json:"extversion"` // extversion
- Extconfig []pgtypes.NullOid `json:"extconfig"` // extconfig
- Extcondition []sql.NullString `json:"extcondition"` // extcondition
- }
- // PgFileSetting represents a row from 'pg_catalog.pg_file_settings'.
- type PgFileSetting struct {
- Sourcefile sql.NullString `json:"sourcefile"` // sourcefile
- Sourceline sql.NullInt64 `json:"sourceline"` // sourceline
- Seqno sql.NullInt64 `json:"seqno"` // seqno
- Name sql.NullString `json:"name"` // name
- Setting sql.NullString `json:"setting"` // setting
- Applied sql.NullBool `json:"applied"` // applied
- Error sql.NullString `json:"error"` // error
- }
- // PgForeignDataWrapper represents a row from 'pg_catalog.pg_foreign_data_wrapper'.
- type PgForeignDataWrapper 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Fdwname string `json:"fdwname"` // fdwname
- Fdwowner pgtypes.Oid `json:"fdwowner"` // fdwowner
- Fdwhandler pgtypes.Oid `json:"fdwhandler"` // fdwhandler
- Fdwvalidator pgtypes.Oid `json:"fdwvalidator"` // fdwvalidator
- Fdwacl []pgtypes.NullAclitem `json:"fdwacl"` // fdwacl
- Fdwoptions []sql.NullString `json:"fdwoptions"` // fdwoptions
- }
- // PgForeignServer represents a row from 'pg_catalog.pg_foreign_server'.
- type PgForeignServer 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Srvname string `json:"srvname"` // srvname
- Srvowner pgtypes.Oid `json:"srvowner"` // srvowner
- Srvfdw pgtypes.Oid `json:"srvfdw"` // srvfdw
- Srvtype sql.NullString `json:"srvtype"` // srvtype
- Srvversion sql.NullString `json:"srvversion"` // srvversion
- Srvacl []pgtypes.NullAclitem `json:"srvacl"` // srvacl
- Srvoptions []sql.NullString `json:"srvoptions"` // srvoptions
- }
- // PgForeignTable represents a row from 'pg_catalog.pg_foreign_table'.
- type PgForeignTable 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
- Ftrelid pgtypes.Oid `json:"ftrelid"` // ftrelid
- Ftserver pgtypes.Oid `json:"ftserver"` // ftserver
- Ftoptions []sql.NullString `json:"ftoptions"` // ftoptions
- }
- // PgGroup represents a row from 'pg_catalog.pg_group'.
- type PgGroup struct {
- Groname sql.NullString `json:"groname"` // groname
- Grosysid pgtypes.NullOid `json:"grosysid"` // grosysid
- Grolist []pgtypes.NullOid `json:"grolist"` // grolist
- }
- // PgHbaFileRule represents a row from 'pg_catalog.pg_hba_file_rules'.
- type PgHbaFileRule struct {
- LineNumber sql.NullInt64 `json:"line_number"` // line_number
- Type sql.NullString `json:"type"` // type
- Database []sql.NullString `json:"database"` // database
- UserName []sql.NullString `json:"user_name"` // user_name
- Address sql.NullString `json:"address"` // address
- Netmask sql.NullString `json:"netmask"` // netmask
- AuthMethod sql.NullString `json:"auth_method"` // auth_method
- Options []sql.NullString `json:"options"` // options
- Error sql.NullString `json:"error"` // error
- }
- // PgIndex represents a row from 'pg_catalog.pg_indexes'.
- type PgIndex struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- Indexname sql.NullString `json:"indexname"` // indexname
- Tablespace sql.NullString `json:"tablespace"` // tablespace
- Indexdef sql.NullString `json:"indexdef"` // indexdef
- }
- // PgIndex represents a row from 'pg_catalog.pg_index'.
- type PgIndex 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
- Indexrelid pgtypes.Oid `json:"indexrelid"` // indexrelid
- Indrelid pgtypes.Oid `json:"indrelid"` // indrelid
- Indnatts int16 `json:"indnatts"` // indnatts
- Indnkeyatts int16 `json:"indnkeyatts"` // indnkeyatts
- Indisunique bool `json:"indisunique"` // indisunique
- Indisprimary bool `json:"indisprimary"` // indisprimary
- Indisexclusion bool `json:"indisexclusion"` // indisexclusion
- Indimmediate bool `json:"indimmediate"` // indimmediate
- Indisclustered bool `json:"indisclustered"` // indisclustered
- Indisvalid bool `json:"indisvalid"` // indisvalid
- Indcheckxmin bool `json:"indcheckxmin"` // indcheckxmin
- Indisready bool `json:"indisready"` // indisready
- Indislive bool `json:"indislive"` // indislive
- Indisreplident bool `json:"indisreplident"` // indisreplident
- Indkey pgtypes.Int2vector `json:"indkey"` // indkey
- Indcollation pgtypes.Oidvector `json:"indcollation"` // indcollation
- Indclass pgtypes.Oidvector `json:"indclass"` // indclass
- Indoption pgtypes.Int2vector `json:"indoption"` // indoption
- Indexprs pgtypes.NullPgNodeTree `json:"indexprs"` // indexprs
- Indpred pgtypes.NullPgNodeTree `json:"indpred"` // indpred
- }
- // PgInherit represents a row from 'pg_catalog.pg_inherits'.
- type PgInherit 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
- Inhrelid pgtypes.Oid `json:"inhrelid"` // inhrelid
- Inhparent pgtypes.Oid `json:"inhparent"` // inhparent
- Inhseqno int `json:"inhseqno"` // inhseqno
- }
- // PgInitPriv represents a row from 'pg_catalog.pg_init_privs'.
- type PgInitPriv 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
- Objoid pgtypes.Oid `json:"objoid"` // objoid
- Classoid pgtypes.Oid `json:"classoid"` // classoid
- Objsubid int `json:"objsubid"` // objsubid
- Privtype pgtypes.Char `json:"privtype"` // privtype
- Initprivs []pgtypes.Aclitem `json:"initprivs"` // initprivs
- }
- // PgLanguage represents a row from 'pg_catalog.pg_language'.
- type PgLanguage 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Lanname string `json:"lanname"` // lanname
- Lanowner pgtypes.Oid `json:"lanowner"` // lanowner
- Lanispl bool `json:"lanispl"` // lanispl
- Lanpltrusted bool `json:"lanpltrusted"` // lanpltrusted
- Lanplcallfoid pgtypes.Oid `json:"lanplcallfoid"` // lanplcallfoid
- Laninline pgtypes.Oid `json:"laninline"` // laninline
- Lanvalidator pgtypes.Oid `json:"lanvalidator"` // lanvalidator
- Lanacl []pgtypes.NullAclitem `json:"lanacl"` // lanacl
- }
- // PgLargeobject represents a row from 'pg_catalog.pg_largeobject'.
- type PgLargeobject 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
- Loid pgtypes.Oid `json:"loid"` // loid
- Pageno int `json:"pageno"` // pageno
- Data []byte `json:"data"` // data
- }
- // PgLargeobjectMetadatum represents a row from 'pg_catalog.pg_largeobject_metadata'.
- type PgLargeobjectMetadatum 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Lomowner pgtypes.Oid `json:"lomowner"` // lomowner
- Lomacl []pgtypes.NullAclitem `json:"lomacl"` // lomacl
- }
- // PgLock represents a row from 'pg_catalog.pg_locks'.
- type PgLock struct {
- Locktype sql.NullString `json:"locktype"` // locktype
- Database pgtypes.NullOid `json:"database"` // database
- Relation pgtypes.NullOid `json:"relation"` // relation
- Page sql.NullInt64 `json:"page"` // page
- Tuple sql.NullInt64 `json:"tuple"` // tuple
- Virtualxid sql.NullString `json:"virtualxid"` // virtualxid
- Transactionid pgtypes.NullXid `json:"transactionid"` // transactionid
- Classid pgtypes.NullOid `json:"classid"` // classid
- Objid pgtypes.NullOid `json:"objid"` // objid
- Objsubid sql.NullInt64 `json:"objsubid"` // objsubid
- Virtualtransaction sql.NullString `json:"virtualtransaction"` // virtualtransaction
- Pid sql.NullInt64 `json:"pid"` // pid
- Mode sql.NullString `json:"mode"` // mode
- Granted sql.NullBool `json:"granted"` // granted
- Fastpath sql.NullBool `json:"fastpath"` // fastpath
- }
- // PgMatview represents a row from 'pg_catalog.pg_matviews'.
- type PgMatview struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Matviewname sql.NullString `json:"matviewname"` // matviewname
- Matviewowner sql.NullString `json:"matviewowner"` // matviewowner
- Tablespace sql.NullString `json:"tablespace"` // tablespace
- Hasindexes sql.NullBool `json:"hasindexes"` // hasindexes
- Ispopulated sql.NullBool `json:"ispopulated"` // ispopulated
- Definition sql.NullString `json:"definition"` // definition
- }
- // PgNamespace represents a row from 'pg_catalog.pg_namespace'.
- type PgNamespace 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Nspname string `json:"nspname"` // nspname
- Nspowner pgtypes.Oid `json:"nspowner"` // nspowner
- Nspacl []pgtypes.NullAclitem `json:"nspacl"` // nspacl
- }
- // PgOpclass represents a row from 'pg_catalog.pg_opclass'.
- type PgOpclass 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Opcmethod pgtypes.Oid `json:"opcmethod"` // opcmethod
- Opcname string `json:"opcname"` // opcname
- Opcnamespace pgtypes.Oid `json:"opcnamespace"` // opcnamespace
- Opcowner pgtypes.Oid `json:"opcowner"` // opcowner
- Opcfamily pgtypes.Oid `json:"opcfamily"` // opcfamily
- Opcintype pgtypes.Oid `json:"opcintype"` // opcintype
- Opcdefault bool `json:"opcdefault"` // opcdefault
- Opckeytype pgtypes.Oid `json:"opckeytype"` // opckeytype
- }
- // PgOperator represents a row from 'pg_catalog.pg_operator'.
- type PgOperator 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Oprname string `json:"oprname"` // oprname
- Oprnamespace pgtypes.Oid `json:"oprnamespace"` // oprnamespace
- Oprowner pgtypes.Oid `json:"oprowner"` // oprowner
- Oprkind pgtypes.Char `json:"oprkind"` // oprkind
- Oprcanmerge bool `json:"oprcanmerge"` // oprcanmerge
- Oprcanhash bool `json:"oprcanhash"` // oprcanhash
- Oprleft pgtypes.Oid `json:"oprleft"` // oprleft
- Oprright pgtypes.Oid `json:"oprright"` // oprright
- Oprresult pgtypes.Oid `json:"oprresult"` // oprresult
- Oprcom pgtypes.Oid `json:"oprcom"` // oprcom
- Oprnegate pgtypes.Oid `json:"oprnegate"` // oprnegate
- Oprcode pgtypes.Regproc `json:"oprcode"` // oprcode
- Oprrest pgtypes.Regproc `json:"oprrest"` // oprrest
- Oprjoin pgtypes.Regproc `json:"oprjoin"` // oprjoin
- }
- // PgOpfamily represents a row from 'pg_catalog.pg_opfamily'.
- type PgOpfamily 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Opfmethod pgtypes.Oid `json:"opfmethod"` // opfmethod
- Opfname string `json:"opfname"` // opfname
- Opfnamespace pgtypes.Oid `json:"opfnamespace"` // opfnamespace
- Opfowner pgtypes.Oid `json:"opfowner"` // opfowner
- }
- // PgPartitionedTable represents a row from 'pg_catalog.pg_partitioned_table'.
- type PgPartitionedTable 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
- Partrelid pgtypes.Oid `json:"partrelid"` // partrelid
- Partstrat pgtypes.Char `json:"partstrat"` // partstrat
- Partnatts int16 `json:"partnatts"` // partnatts
- Partdefid pgtypes.Oid `json:"partdefid"` // partdefid
- Partattrs pgtypes.Int2vector `json:"partattrs"` // partattrs
- Partclass pgtypes.Oidvector `json:"partclass"` // partclass
- Partcollation pgtypes.Oidvector `json:"partcollation"` // partcollation
- Partexprs pgtypes.NullPgNodeTree `json:"partexprs"` // partexprs
- }
- // PgPolicy represents a row from 'pg_catalog.pg_policies'.
- type PgPolicy struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- Policyname sql.NullString `json:"policyname"` // policyname
- Permissive sql.NullString `json:"permissive"` // permissive
- Roles []sql.NullString `json:"roles"` // roles
- Cmd sql.NullString `json:"cmd"` // cmd
- Qual sql.NullString `json:"qual"` // qual
- WithCheck sql.NullString `json:"with_check"` // with_check
- }
- // PgPolicy represents a row from 'pg_catalog.pg_policy'.
- type PgPolicy 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Polname string `json:"polname"` // polname
- Polrelid pgtypes.Oid `json:"polrelid"` // polrelid
- Polcmd pgtypes.Char `json:"polcmd"` // polcmd
- Polpermissive bool `json:"polpermissive"` // polpermissive
- Polroles []pgtypes.Oid `json:"polroles"` // polroles
- Polqual pgtypes.NullPgNodeTree `json:"polqual"` // polqual
- Polwithcheck pgtypes.NullPgNodeTree `json:"polwithcheck"` // polwithcheck
- }
- // PgPreparedStatement represents a row from 'pg_catalog.pg_prepared_statements'.
- type PgPreparedStatement struct {
- Name sql.NullString `json:"name"` // name
- Statement sql.NullString `json:"statement"` // statement
- PrepareTime sql.NullTime `json:"prepare_time"` // prepare_time
- ParameterTypes []pgtypes.NullRegtype `json:"parameter_types"` // parameter_types
- FromSQL sql.NullBool `json:"from_sql"` // from_sql
- }
- // PgPreparedXact represents a row from 'pg_catalog.pg_prepared_xacts'.
- type PgPreparedXact struct {
- Transaction pgtypes.NullXid `json:"transaction"` // transaction
- Gid sql.NullString `json:"gid"` // gid
- Prepared sql.NullTime `json:"prepared"` // prepared
- Owner sql.NullString `json:"owner"` // owner
- Database sql.NullString `json:"database"` // database
- }
- // PgProc represents a row from 'pg_catalog.pg_proc'.
- type PgProc 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Proname string `json:"proname"` // proname
- Pronamespace pgtypes.Oid `json:"pronamespace"` // pronamespace
- Proowner pgtypes.Oid `json:"proowner"` // proowner
- Prolang pgtypes.Oid `json:"prolang"` // prolang
- Procost float32 `json:"procost"` // procost
- Prorows float32 `json:"prorows"` // prorows
- Provariadic pgtypes.Oid `json:"provariadic"` // provariadic
- Prosupport pgtypes.Regproc `json:"prosupport"` // prosupport
- Prokind pgtypes.Char `json:"prokind"` // prokind
- Prosecdef bool `json:"prosecdef"` // prosecdef
- Proleakproof bool `json:"proleakproof"` // proleakproof
- Proisstrict bool `json:"proisstrict"` // proisstrict
- Proretset bool `json:"proretset"` // proretset
- Provolatile pgtypes.Char `json:"provolatile"` // provolatile
- Proparallel pgtypes.Char `json:"proparallel"` // proparallel
- Pronargs int16 `json:"pronargs"` // pronargs
- Pronargdefaults int16 `json:"pronargdefaults"` // pronargdefaults
- Prorettype pgtypes.Oid `json:"prorettype"` // prorettype
- Proargtypes pgtypes.Oidvector `json:"proargtypes"` // proargtypes
- Proallargtypes []pgtypes.NullOid `json:"proallargtypes"` // proallargtypes
- Proargmodes []pgtypes.NullChar `json:"proargmodes"` // proargmodes
- Proargnames []sql.NullString `json:"proargnames"` // proargnames
- Proargdefaults pgtypes.NullPgNodeTree `json:"proargdefaults"` // proargdefaults
- Protrftypes []pgtypes.NullOid `json:"protrftypes"` // protrftypes
- Prosrc string `json:"prosrc"` // prosrc
- Probin sql.NullString `json:"probin"` // probin
- Proconfig []sql.NullString `json:"proconfig"` // proconfig
- Proacl []pgtypes.NullAclitem `json:"proacl"` // proacl
- }
- // PgPublication represents a row from 'pg_catalog.pg_publication'.
- type PgPublication 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Pubname string `json:"pubname"` // pubname
- Pubowner pgtypes.Oid `json:"pubowner"` // pubowner
- Puballtables bool `json:"puballtables"` // puballtables
- Pubinsert bool `json:"pubinsert"` // pubinsert
- Pubupdate bool `json:"pubupdate"` // pubupdate
- Pubdelete bool `json:"pubdelete"` // pubdelete
- Pubtruncate bool `json:"pubtruncate"` // pubtruncate
- Pubviaroot bool `json:"pubviaroot"` // pubviaroot
- }
- // PgPublicationRel represents a row from 'pg_catalog.pg_publication_rel'.
- type PgPublicationRel 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Prpubid pgtypes.Oid `json:"prpubid"` // prpubid
- Prrelid pgtypes.Oid `json:"prrelid"` // prrelid
- }
- // PgPublicationTable represents a row from 'pg_catalog.pg_publication_tables'.
- type PgPublicationTable struct {
- Pubname sql.NullString `json:"pubname"` // pubname
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- }
- // PgRange represents a row from 'pg_catalog.pg_range'.
- type PgRange 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
- Rngtypid pgtypes.Oid `json:"rngtypid"` // rngtypid
- Rngsubtype pgtypes.Oid `json:"rngsubtype"` // rngsubtype
- Rngcollation pgtypes.Oid `json:"rngcollation"` // rngcollation
- Rngsubopc pgtypes.Oid `json:"rngsubopc"` // rngsubopc
- Rngcanonical pgtypes.Regproc `json:"rngcanonical"` // rngcanonical
- Rngsubdiff pgtypes.Regproc `json:"rngsubdiff"` // rngsubdiff
- }
- // PgReplicationOrigin represents a row from 'pg_catalog.pg_replication_origin'.
- type PgReplicationOrigin 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
- Roident pgtypes.Oid `json:"roident"` // roident
- Roname string `json:"roname"` // roname
- }
- // PgReplicationOriginStatus represents a row from 'pg_catalog.pg_replication_origin_status'.
- type PgReplicationOriginStatus struct {
- LocalID pgtypes.NullOid `json:"local_id"` // local_id
- ExternalID sql.NullString `json:"external_id"` // external_id
- RemoteLsn pgtypes.NullPgLsn `json:"remote_lsn"` // remote_lsn
- LocalLsn pgtypes.NullPgLsn `json:"local_lsn"` // local_lsn
- }
- // PgReplicationSlot represents a row from 'pg_catalog.pg_replication_slots'.
- type PgReplicationSlot struct {
- SlotName sql.NullString `json:"slot_name"` // slot_name
- Plugin sql.NullString `json:"plugin"` // plugin
- SlotType sql.NullString `json:"slot_type"` // slot_type
- Datoid pgtypes.NullOid `json:"datoid"` // datoid
- Database sql.NullString `json:"database"` // database
- Temporary sql.NullBool `json:"temporary"` // temporary
- Active sql.NullBool `json:"active"` // active
- ActivePid sql.NullInt64 `json:"active_pid"` // active_pid
- Xmin pgtypes.NullXid `json:"xmin"` // xmin
- CatalogXmin pgtypes.NullXid `json:"catalog_xmin"` // catalog_xmin
- RestartLsn pgtypes.NullPgLsn `json:"restart_lsn"` // restart_lsn
- ConfirmedFlushLsn pgtypes.NullPgLsn `json:"confirmed_flush_lsn"` // confirmed_flush_lsn
- WalStatus sql.NullString `json:"wal_status"` // wal_status
- SafeWalSize sql.NullInt64 `json:"safe_wal_size"` // safe_wal_size
- }
- // PgRewrite represents a row from 'pg_catalog.pg_rewrite'.
- type PgRewrite 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Rulename string `json:"rulename"` // rulename
- EvClass pgtypes.Oid `json:"ev_class"` // ev_class
- EvType pgtypes.Char `json:"ev_type"` // ev_type
- EvEnabled pgtypes.Char `json:"ev_enabled"` // ev_enabled
- IsInstead bool `json:"is_instead"` // is_instead
- EvQual pgtypes.PgNodeTree `json:"ev_qual"` // ev_qual
- EvAction pgtypes.PgNodeTree `json:"ev_action"` // ev_action
- }
- // PgRole represents a row from 'pg_catalog.pg_roles'.
- type PgRole struct {
- Rolname sql.NullString `json:"rolname"` // rolname
- Rolsuper sql.NullBool `json:"rolsuper"` // rolsuper
- Rolinherit sql.NullBool `json:"rolinherit"` // rolinherit
- Rolcreaterole sql.NullBool `json:"rolcreaterole"` // rolcreaterole
- Rolcreatedb sql.NullBool `json:"rolcreatedb"` // rolcreatedb
- Rolcanlogin sql.NullBool `json:"rolcanlogin"` // rolcanlogin
- Rolreplication sql.NullBool `json:"rolreplication"` // rolreplication
- Rolconnlimit sql.NullInt64 `json:"rolconnlimit"` // rolconnlimit
- Rolpassword sql.NullString `json:"rolpassword"` // rolpassword
- Rolvaliduntil sql.NullTime `json:"rolvaliduntil"` // rolvaliduntil
- Rolbypassrls sql.NullBool `json:"rolbypassrls"` // rolbypassrls
- Rolconfig []sql.NullString `json:"rolconfig"` // rolconfig
- Oid pgtypes.NullOid `json:"oid"` // oid
- }
- // PgRule represents a row from 'pg_catalog.pg_rules'.
- type PgRule struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- Rulename sql.NullString `json:"rulename"` // rulename
- Definition sql.NullString `json:"definition"` // definition
- }
- // PgSeclabel represents a row from 'pg_catalog.pg_seclabel'.
- type PgSeclabel 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
- Objoid pgtypes.Oid `json:"objoid"` // objoid
- Classoid pgtypes.Oid `json:"classoid"` // classoid
- Objsubid int `json:"objsubid"` // objsubid
- Provider string `json:"provider"` // provider
- Label string `json:"label"` // label
- }
- // PgSeclabel represents a row from 'pg_catalog.pg_seclabels'.
- type PgSeclabel struct {
- Objoid pgtypes.NullOid `json:"objoid"` // objoid
- Classoid pgtypes.NullOid `json:"classoid"` // classoid
- Objsubid sql.NullInt64 `json:"objsubid"` // objsubid
- Objtype sql.NullString `json:"objtype"` // objtype
- Objnamespace pgtypes.NullOid `json:"objnamespace"` // objnamespace
- Objname sql.NullString `json:"objname"` // objname
- Provider sql.NullString `json:"provider"` // provider
- Label sql.NullString `json:"label"` // label
- }
- // PgSequence represents a row from 'pg_catalog.pg_sequence'.
- type PgSequence 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
- Seqrelid pgtypes.Oid `json:"seqrelid"` // seqrelid
- Seqtypid pgtypes.Oid `json:"seqtypid"` // seqtypid
- Seqstart int64 `json:"seqstart"` // seqstart
- Seqincrement int64 `json:"seqincrement"` // seqincrement
- Seqmax int64 `json:"seqmax"` // seqmax
- Seqmin int64 `json:"seqmin"` // seqmin
- Seqcache int64 `json:"seqcache"` // seqcache
- Seqcycle bool `json:"seqcycle"` // seqcycle
- }
- // PgSequence represents a row from 'pg_catalog.pg_sequences'.
- type PgSequence struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Sequencename sql.NullString `json:"sequencename"` // sequencename
- Sequenceowner sql.NullString `json:"sequenceowner"` // sequenceowner
- DataType pgtypes.NullRegtype `json:"data_type"` // data_type
- StartValue sql.NullInt64 `json:"start_value"` // start_value
- MinValue sql.NullInt64 `json:"min_value"` // min_value
- MaxValue sql.NullInt64 `json:"max_value"` // max_value
- IncrementBy sql.NullInt64 `json:"increment_by"` // increment_by
- Cycle sql.NullBool `json:"cycle"` // cycle
- CacheSize sql.NullInt64 `json:"cache_size"` // cache_size
- LastValue sql.NullInt64 `json:"last_value"` // last_value
- }
- // PgSetting represents a row from 'pg_catalog.pg_settings'.
- type PgSetting struct {
- Name sql.NullString `json:"name"` // name
- Setting sql.NullString `json:"setting"` // setting
- Unit sql.NullString `json:"unit"` // unit
- Category sql.NullString `json:"category"` // category
- ShortDesc sql.NullString `json:"short_desc"` // short_desc
- ExtraDesc sql.NullString `json:"extra_desc"` // extra_desc
- Context sql.NullString `json:"context"` // context
- Vartype sql.NullString `json:"vartype"` // vartype
- Source sql.NullString `json:"source"` // source
- MinVal sql.NullString `json:"min_val"` // min_val
- MaxVal sql.NullString `json:"max_val"` // max_val
- Enumvals []sql.NullString `json:"enumvals"` // enumvals
- BootVal sql.NullString `json:"boot_val"` // boot_val
- ResetVal sql.NullString `json:"reset_val"` // reset_val
- Sourcefile sql.NullString `json:"sourcefile"` // sourcefile
- Sourceline sql.NullInt64 `json:"sourceline"` // sourceline
- PendingRestart sql.NullBool `json:"pending_restart"` // pending_restart
- }
- // PgShadow represents a row from 'pg_catalog.pg_shadow'.
- type PgShadow struct {
- Usename sql.NullString `json:"usename"` // usename
- Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
- Usecreatedb sql.NullBool `json:"usecreatedb"` // usecreatedb
- Usesuper sql.NullBool `json:"usesuper"` // usesuper
- Userepl sql.NullBool `json:"userepl"` // userepl
- Usebypassrls sql.NullBool `json:"usebypassrls"` // usebypassrls
- Passwd sql.NullString `json:"passwd"` // passwd
- Valuntil sql.NullTime `json:"valuntil"` // valuntil
- Useconfig []sql.NullString `json:"useconfig"` // useconfig
- }
- // PgShdepend represents a row from 'pg_catalog.pg_shdepend'.
- type PgShdepend 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
- Dbid pgtypes.Oid `json:"dbid"` // dbid
- Classid pgtypes.Oid `json:"classid"` // classid
- Objid pgtypes.Oid `json:"objid"` // objid
- Objsubid int `json:"objsubid"` // objsubid
- Refclassid pgtypes.Oid `json:"refclassid"` // refclassid
- Refobjid pgtypes.Oid `json:"refobjid"` // refobjid
- Deptype pgtypes.Char `json:"deptype"` // deptype
- }
- // PgShdescription represents a row from 'pg_catalog.pg_shdescription'.
- type PgShdescription 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
- Objoid pgtypes.Oid `json:"objoid"` // objoid
- Classoid pgtypes.Oid `json:"classoid"` // classoid
- Description string `json:"description"` // description
- }
- // PgShmemAllocation represents a row from 'pg_catalog.pg_shmem_allocations'.
- type PgShmemAllocation struct {
- Name sql.NullString `json:"name"` // name
- Off sql.NullInt64 `json:"off"` // off
- Size sql.NullInt64 `json:"size"` // size
- AllocatedSize sql.NullInt64 `json:"allocated_size"` // allocated_size
- }
- // PgShseclabel represents a row from 'pg_catalog.pg_shseclabel'.
- type PgShseclabel 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
- Objoid pgtypes.Oid `json:"objoid"` // objoid
- Classoid pgtypes.Oid `json:"classoid"` // classoid
- Provider string `json:"provider"` // provider
- Label string `json:"label"` // label
- }
- // PgStat represents a row from 'pg_catalog.pg_stats'.
- type PgStat struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- Attname sql.NullString `json:"attname"` // attname
- Inherited sql.NullBool `json:"inherited"` // inherited
- NullFrac sql.NullFloat64 `json:"null_frac"` // null_frac
- AvgWidth sql.NullInt64 `json:"avg_width"` // avg_width
- NDistinct sql.NullFloat64 `json:"n_distinct"` // n_distinct
- MostCommonVals pgtypes.NullAnyarray `json:"most_common_vals"` // most_common_vals
- MostCommonFreqs []sql.NullFloat64 `json:"most_common_freqs"` // most_common_freqs
- HistogramBounds pgtypes.NullAnyarray `json:"histogram_bounds"` // histogram_bounds
- Correlation sql.NullFloat64 `json:"correlation"` // correlation
- MostCommonElems pgtypes.NullAnyarray `json:"most_common_elems"` // most_common_elems
- MostCommonElemFreqs []sql.NullFloat64 `json:"most_common_elem_freqs"` // most_common_elem_freqs
- ElemCountHistogram []sql.NullFloat64 `json:"elem_count_histogram"` // elem_count_histogram
- }
- // PgStatActivity represents a row from 'pg_catalog.pg_stat_activity'.
- type PgStatActivity struct {
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Pid sql.NullInt64 `json:"pid"` // pid
- LeaderPid sql.NullInt64 `json:"leader_pid"` // leader_pid
- Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
- Usename sql.NullString `json:"usename"` // usename
- ApplicationName sql.NullString `json:"application_name"` // application_name
- ClientAddr sql.NullString `json:"client_addr"` // client_addr
- ClientHostname sql.NullString `json:"client_hostname"` // client_hostname
- ClientPort sql.NullInt64 `json:"client_port"` // client_port
- BackendStart sql.NullTime `json:"backend_start"` // backend_start
- XactStart sql.NullTime `json:"xact_start"` // xact_start
- QueryStart sql.NullTime `json:"query_start"` // query_start
- StateChange sql.NullTime `json:"state_change"` // state_change
- WaitEventType sql.NullString `json:"wait_event_type"` // wait_event_type
- WaitEvent sql.NullString `json:"wait_event"` // wait_event
- State sql.NullString `json:"state"` // state
- BackendXid pgtypes.NullXid `json:"backend_xid"` // backend_xid
- BackendXmin pgtypes.NullXid `json:"backend_xmin"` // backend_xmin
- Query sql.NullString `json:"query"` // query
- BackendType sql.NullString `json:"backend_type"` // backend_type
- }
- // PgStatAllIndex represents a row from 'pg_catalog.pg_stat_all_indexes'.
- type PgStatAllIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- }
- // PgStatAllTable represents a row from 'pg_catalog.pg_stat_all_tables'.
- type PgStatAllTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
- NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
- NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
- NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
- LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
- LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
- LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
- LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
- VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
- AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
- AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
- AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
- }
- // PgStatArchiver represents a row from 'pg_catalog.pg_stat_archiver'.
- type PgStatArchiver struct {
- ArchivedCount sql.NullInt64 `json:"archived_count"` // archived_count
- LastArchivedWal sql.NullString `json:"last_archived_wal"` // last_archived_wal
- LastArchivedTime sql.NullTime `json:"last_archived_time"` // last_archived_time
- FailedCount sql.NullInt64 `json:"failed_count"` // failed_count
- LastFailedWal sql.NullString `json:"last_failed_wal"` // last_failed_wal
- LastFailedTime sql.NullTime `json:"last_failed_time"` // last_failed_time
- StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
- }
- // PgStatBgwriter represents a row from 'pg_catalog.pg_stat_bgwriter'.
- type PgStatBgwriter struct {
- CheckpointsTimed sql.NullInt64 `json:"checkpoints_timed"` // checkpoints_timed
- CheckpointsReq sql.NullInt64 `json:"checkpoints_req"` // checkpoints_req
- CheckpointWriteTime sql.NullFloat64 `json:"checkpoint_write_time"` // checkpoint_write_time
- CheckpointSyncTime sql.NullFloat64 `json:"checkpoint_sync_time"` // checkpoint_sync_time
- BuffersCheckpoint sql.NullInt64 `json:"buffers_checkpoint"` // buffers_checkpoint
- BuffersClean sql.NullInt64 `json:"buffers_clean"` // buffers_clean
- MaxwrittenClean sql.NullInt64 `json:"maxwritten_clean"` // maxwritten_clean
- BuffersBackend sql.NullInt64 `json:"buffers_backend"` // buffers_backend
- BuffersBackendFsync sql.NullInt64 `json:"buffers_backend_fsync"` // buffers_backend_fsync
- BuffersAlloc sql.NullInt64 `json:"buffers_alloc"` // buffers_alloc
- StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
- }
- // PgStatDatabase represents a row from 'pg_catalog.pg_stat_database'.
- type PgStatDatabase struct {
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Numbackends sql.NullInt64 `json:"numbackends"` // numbackends
- XactCommit sql.NullInt64 `json:"xact_commit"` // xact_commit
- XactRollback sql.NullInt64 `json:"xact_rollback"` // xact_rollback
- BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
- BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
- TupReturned sql.NullInt64 `json:"tup_returned"` // tup_returned
- TupFetched sql.NullInt64 `json:"tup_fetched"` // tup_fetched
- TupInserted sql.NullInt64 `json:"tup_inserted"` // tup_inserted
- TupUpdated sql.NullInt64 `json:"tup_updated"` // tup_updated
- TupDeleted sql.NullInt64 `json:"tup_deleted"` // tup_deleted
- Conflicts sql.NullInt64 `json:"conflicts"` // conflicts
- TempFiles sql.NullInt64 `json:"temp_files"` // temp_files
- TempBytes sql.NullInt64 `json:"temp_bytes"` // temp_bytes
- Deadlocks sql.NullInt64 `json:"deadlocks"` // deadlocks
- ChecksumFailures sql.NullInt64 `json:"checksum_failures"` // checksum_failures
- ChecksumLastFailure sql.NullTime `json:"checksum_last_failure"` // checksum_last_failure
- BlkReadTime sql.NullFloat64 `json:"blk_read_time"` // blk_read_time
- BlkWriteTime sql.NullFloat64 `json:"blk_write_time"` // blk_write_time
- StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
- }
- // PgStatDatabaseConflict represents a row from 'pg_catalog.pg_stat_database_conflicts'.
- type PgStatDatabaseConflict struct {
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- ConflTablespace sql.NullInt64 `json:"confl_tablespace"` // confl_tablespace
- ConflLock sql.NullInt64 `json:"confl_lock"` // confl_lock
- ConflSnapshot sql.NullInt64 `json:"confl_snapshot"` // confl_snapshot
- ConflBufferpin sql.NullInt64 `json:"confl_bufferpin"` // confl_bufferpin
- ConflDeadlock sql.NullInt64 `json:"confl_deadlock"` // confl_deadlock
- }
- // PgStatGssapi represents a row from 'pg_catalog.pg_stat_gssapi'.
- type PgStatGssapi struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- GssAuthenticated sql.NullBool `json:"gss_authenticated"` // gss_authenticated
- Principal sql.NullString `json:"principal"` // principal
- Encrypted sql.NullBool `json:"encrypted"` // encrypted
- }
- // PgStatProgressAnalyze represents a row from 'pg_catalog.pg_stat_progress_analyze'.
- type PgStatProgressAnalyze struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Relid pgtypes.NullOid `json:"relid"` // relid
- Phase sql.NullString `json:"phase"` // phase
- SampleBlksTotal sql.NullInt64 `json:"sample_blks_total"` // sample_blks_total
- SampleBlksScanned sql.NullInt64 `json:"sample_blks_scanned"` // sample_blks_scanned
- ExtStatsTotal sql.NullInt64 `json:"ext_stats_total"` // ext_stats_total
- ExtStatsComputed sql.NullInt64 `json:"ext_stats_computed"` // ext_stats_computed
- ChildTablesTotal sql.NullInt64 `json:"child_tables_total"` // child_tables_total
- ChildTablesDone sql.NullInt64 `json:"child_tables_done"` // child_tables_done
- CurrentChildTableRelid pgtypes.NullOid `json:"current_child_table_relid"` // current_child_table_relid
- }
- // PgStatProgressBasebackup represents a row from 'pg_catalog.pg_stat_progress_basebackup'.
- type PgStatProgressBasebackup struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Phase sql.NullString `json:"phase"` // phase
- BackupTotal sql.NullInt64 `json:"backup_total"` // backup_total
- BackupStreamed sql.NullInt64 `json:"backup_streamed"` // backup_streamed
- TablespacesTotal sql.NullInt64 `json:"tablespaces_total"` // tablespaces_total
- TablespacesStreamed sql.NullInt64 `json:"tablespaces_streamed"` // tablespaces_streamed
- }
- // PgStatProgressCluster represents a row from 'pg_catalog.pg_stat_progress_cluster'.
- type PgStatProgressCluster struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Relid pgtypes.NullOid `json:"relid"` // relid
- Command sql.NullString `json:"command"` // command
- Phase sql.NullString `json:"phase"` // phase
- ClusterIndexRelid pgtypes.NullOid `json:"cluster_index_relid"` // cluster_index_relid
- HeapTuplesScanned sql.NullInt64 `json:"heap_tuples_scanned"` // heap_tuples_scanned
- HeapTuplesWritten sql.NullInt64 `json:"heap_tuples_written"` // heap_tuples_written
- HeapBlksTotal sql.NullInt64 `json:"heap_blks_total"` // heap_blks_total
- HeapBlksScanned sql.NullInt64 `json:"heap_blks_scanned"` // heap_blks_scanned
- IndexRebuildCount sql.NullInt64 `json:"index_rebuild_count"` // index_rebuild_count
- }
- // PgStatProgressCreateIndex represents a row from 'pg_catalog.pg_stat_progress_create_index'.
- type PgStatProgressCreateIndex struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Relid pgtypes.NullOid `json:"relid"` // relid
- IndexRelid pgtypes.NullOid `json:"index_relid"` // index_relid
- Command sql.NullString `json:"command"` // command
- Phase sql.NullString `json:"phase"` // phase
- LockersTotal sql.NullInt64 `json:"lockers_total"` // lockers_total
- LockersDone sql.NullInt64 `json:"lockers_done"` // lockers_done
- CurrentLockerPid sql.NullInt64 `json:"current_locker_pid"` // current_locker_pid
- BlocksTotal sql.NullInt64 `json:"blocks_total"` // blocks_total
- BlocksDone sql.NullInt64 `json:"blocks_done"` // blocks_done
- TuplesTotal sql.NullInt64 `json:"tuples_total"` // tuples_total
- TuplesDone sql.NullInt64 `json:"tuples_done"` // tuples_done
- PartitionsTotal sql.NullInt64 `json:"partitions_total"` // partitions_total
- PartitionsDone sql.NullInt64 `json:"partitions_done"` // partitions_done
- }
- // PgStatProgressVacuum represents a row from 'pg_catalog.pg_stat_progress_vacuum'.
- type PgStatProgressVacuum struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Datid pgtypes.NullOid `json:"datid"` // datid
- Datname sql.NullString `json:"datname"` // datname
- Relid pgtypes.NullOid `json:"relid"` // relid
- Phase sql.NullString `json:"phase"` // phase
- HeapBlksTotal sql.NullInt64 `json:"heap_blks_total"` // heap_blks_total
- HeapBlksScanned sql.NullInt64 `json:"heap_blks_scanned"` // heap_blks_scanned
- HeapBlksVacuumed sql.NullInt64 `json:"heap_blks_vacuumed"` // heap_blks_vacuumed
- IndexVacuumCount sql.NullInt64 `json:"index_vacuum_count"` // index_vacuum_count
- MaxDeadTuples sql.NullInt64 `json:"max_dead_tuples"` // max_dead_tuples
- NumDeadTuples sql.NullInt64 `json:"num_dead_tuples"` // num_dead_tuples
- }
- // PgStatReplication represents a row from 'pg_catalog.pg_stat_replication'.
- type PgStatReplication struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
- Usename sql.NullString `json:"usename"` // usename
- ApplicationName sql.NullString `json:"application_name"` // application_name
- ClientAddr sql.NullString `json:"client_addr"` // client_addr
- ClientHostname sql.NullString `json:"client_hostname"` // client_hostname
- ClientPort sql.NullInt64 `json:"client_port"` // client_port
- BackendStart sql.NullTime `json:"backend_start"` // backend_start
- BackendXmin pgtypes.NullXid `json:"backend_xmin"` // backend_xmin
- State sql.NullString `json:"state"` // state
- SentLsn pgtypes.NullPgLsn `json:"sent_lsn"` // sent_lsn
- WriteLsn pgtypes.NullPgLsn `json:"write_lsn"` // write_lsn
- FlushLsn pgtypes.NullPgLsn `json:"flush_lsn"` // flush_lsn
- ReplayLsn pgtypes.NullPgLsn `json:"replay_lsn"` // replay_lsn
- WriteLag []byte `json:"write_lag"` // write_lag
- FlushLag []byte `json:"flush_lag"` // flush_lag
- ReplayLag []byte `json:"replay_lag"` // replay_lag
- SyncPriority sql.NullInt64 `json:"sync_priority"` // sync_priority
- SyncState sql.NullString `json:"sync_state"` // sync_state
- ReplyTime sql.NullTime `json:"reply_time"` // reply_time
- }
- // PgStatSlru represents a row from 'pg_catalog.pg_stat_slru'.
- type PgStatSlru struct {
- Name sql.NullString `json:"name"` // name
- BlksZeroed sql.NullInt64 `json:"blks_zeroed"` // blks_zeroed
- BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
- BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
- BlksWritten sql.NullInt64 `json:"blks_written"` // blks_written
- BlksExists sql.NullInt64 `json:"blks_exists"` // blks_exists
- Flushes sql.NullInt64 `json:"flushes"` // flushes
- Truncates sql.NullInt64 `json:"truncates"` // truncates
- StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
- }
- // PgStatSsl represents a row from 'pg_catalog.pg_stat_ssl'.
- type PgStatSsl struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Ssl sql.NullBool `json:"ssl"` // ssl
- Version sql.NullString `json:"version"` // version
- Cipher sql.NullString `json:"cipher"` // cipher
- Bits sql.NullInt64 `json:"bits"` // bits
- Compression sql.NullBool `json:"compression"` // compression
- ClientDn sql.NullString `json:"client_dn"` // client_dn
- ClientSerial sql.NullFloat64 `json:"client_serial"` // client_serial
- IssuerDn sql.NullString `json:"issuer_dn"` // issuer_dn
- }
- // PgStatSubscription represents a row from 'pg_catalog.pg_stat_subscription'.
- type PgStatSubscription struct {
- Subid pgtypes.NullOid `json:"subid"` // subid
- Subname sql.NullString `json:"subname"` // subname
- Pid sql.NullInt64 `json:"pid"` // pid
- Relid pgtypes.NullOid `json:"relid"` // relid
- ReceivedLsn pgtypes.NullPgLsn `json:"received_lsn"` // received_lsn
- LastMsgSendTime sql.NullTime `json:"last_msg_send_time"` // last_msg_send_time
- LastMsgReceiptTime sql.NullTime `json:"last_msg_receipt_time"` // last_msg_receipt_time
- LatestEndLsn pgtypes.NullPgLsn `json:"latest_end_lsn"` // latest_end_lsn
- LatestEndTime sql.NullTime `json:"latest_end_time"` // latest_end_time
- }
- // PgStatSysIndex represents a row from 'pg_catalog.pg_stat_sys_indexes'.
- type PgStatSysIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- }
- // PgStatSysTable represents a row from 'pg_catalog.pg_stat_sys_tables'.
- type PgStatSysTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
- NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
- NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
- NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
- LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
- LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
- LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
- LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
- VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
- AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
- AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
- AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
- }
- // PgStatUserFunction represents a row from 'pg_catalog.pg_stat_user_functions'.
- type PgStatUserFunction struct {
- Funcid pgtypes.NullOid `json:"funcid"` // funcid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Funcname sql.NullString `json:"funcname"` // funcname
- Calls sql.NullInt64 `json:"calls"` // calls
- TotalTime sql.NullFloat64 `json:"total_time"` // total_time
- SelfTime sql.NullFloat64 `json:"self_time"` // self_time
- }
- // PgStatUserIndex represents a row from 'pg_catalog.pg_stat_user_indexes'.
- type PgStatUserIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- }
- // PgStatUserTable represents a row from 'pg_catalog.pg_stat_user_tables'.
- type PgStatUserTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
- NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
- NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
- NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
- LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
- LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
- LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
- LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
- VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
- AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
- AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
- AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
- }
- // PgStatWalReceiver represents a row from 'pg_catalog.pg_stat_wal_receiver'.
- type PgStatWalReceiver struct {
- Pid sql.NullInt64 `json:"pid"` // pid
- Status sql.NullString `json:"status"` // status
- ReceiveStartLsn pgtypes.NullPgLsn `json:"receive_start_lsn"` // receive_start_lsn
- ReceiveStartTli sql.NullInt64 `json:"receive_start_tli"` // receive_start_tli
- WrittenLsn pgtypes.NullPgLsn `json:"written_lsn"` // written_lsn
- FlushedLsn pgtypes.NullPgLsn `json:"flushed_lsn"` // flushed_lsn
- ReceivedTli sql.NullInt64 `json:"received_tli"` // received_tli
- LastMsgSendTime sql.NullTime `json:"last_msg_send_time"` // last_msg_send_time
- LastMsgReceiptTime sql.NullTime `json:"last_msg_receipt_time"` // last_msg_receipt_time
- LatestEndLsn pgtypes.NullPgLsn `json:"latest_end_lsn"` // latest_end_lsn
- LatestEndTime sql.NullTime `json:"latest_end_time"` // latest_end_time
- SlotName sql.NullString `json:"slot_name"` // slot_name
- SenderHost sql.NullString `json:"sender_host"` // sender_host
- SenderPort sql.NullInt64 `json:"sender_port"` // sender_port
- Conninfo sql.NullString `json:"conninfo"` // conninfo
- }
- // PgStatXactAllTable represents a row from 'pg_catalog.pg_stat_xact_all_tables'.
- type PgStatXactAllTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- }
- // PgStatXactSysTable represents a row from 'pg_catalog.pg_stat_xact_sys_tables'.
- type PgStatXactSysTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- }
- // PgStatXactUserFunction represents a row from 'pg_catalog.pg_stat_xact_user_functions'.
- type PgStatXactUserFunction struct {
- Funcid pgtypes.NullOid `json:"funcid"` // funcid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Funcname sql.NullString `json:"funcname"` // funcname
- Calls sql.NullInt64 `json:"calls"` // calls
- TotalTime sql.NullFloat64 `json:"total_time"` // total_time
- SelfTime sql.NullFloat64 `json:"self_time"` // self_time
- }
- // PgStatXactUserTable represents a row from 'pg_catalog.pg_stat_xact_user_tables'.
- type PgStatXactUserTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
- SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
- IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
- IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
- NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
- NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
- NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
- NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
- }
- // PgStatioAllIndex represents a row from 'pg_catalog.pg_statio_all_indexes'.
- type PgStatioAllIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- }
- // PgStatioAllSequence represents a row from 'pg_catalog.pg_statio_all_sequences'.
- type PgStatioAllSequence struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
- BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
- }
- // PgStatioAllTable represents a row from 'pg_catalog.pg_statio_all_tables'.
- type PgStatioAllTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
- HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
- ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
- TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
- TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
- }
- // PgStatioSysIndex represents a row from 'pg_catalog.pg_statio_sys_indexes'.
- type PgStatioSysIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- }
- // PgStatioSysSequence represents a row from 'pg_catalog.pg_statio_sys_sequences'.
- type PgStatioSysSequence struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
- BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
- }
- // PgStatioSysTable represents a row from 'pg_catalog.pg_statio_sys_tables'.
- type PgStatioSysTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
- HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
- ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
- TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
- TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
- }
- // PgStatioUserIndex represents a row from 'pg_catalog.pg_statio_user_indexes'.
- type PgStatioUserIndex struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- }
- // PgStatioUserSequence represents a row from 'pg_catalog.pg_statio_user_sequences'.
- type PgStatioUserSequence struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
- BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
- }
- // PgStatioUserTable represents a row from 'pg_catalog.pg_statio_user_tables'.
- type PgStatioUserTable struct {
- Relid pgtypes.NullOid `json:"relid"` // relid
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Relname sql.NullString `json:"relname"` // relname
- HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
- HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
- IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
- IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
- ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
- ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
- TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
- TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
- }
- // PgStatistic represents a row from 'pg_catalog.pg_statistic'.
- type PgStatistic 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
- Starelid pgtypes.Oid `json:"starelid"` // starelid
- Staattnum int16 `json:"staattnum"` // staattnum
- Stainherit bool `json:"stainherit"` // stainherit
- Stanullfrac float32 `json:"stanullfrac"` // stanullfrac
- Stawidth int `json:"stawidth"` // stawidth
- Stadistinct float32 `json:"stadistinct"` // stadistinct
- Stakind1 int16 `json:"stakind1"` // stakind1
- Stakind2 int16 `json:"stakind2"` // stakind2
- Stakind3 int16 `json:"stakind3"` // stakind3
- Stakind4 int16 `json:"stakind4"` // stakind4
- Stakind5 int16 `json:"stakind5"` // stakind5
- Staop1 pgtypes.Oid `json:"staop1"` // staop1
- Staop2 pgtypes.Oid `json:"staop2"` // staop2
- Staop3 pgtypes.Oid `json:"staop3"` // staop3
- Staop4 pgtypes.Oid `json:"staop4"` // staop4
- Staop5 pgtypes.Oid `json:"staop5"` // staop5
- Stacoll1 pgtypes.Oid `json:"stacoll1"` // stacoll1
- Stacoll2 pgtypes.Oid `json:"stacoll2"` // stacoll2
- Stacoll3 pgtypes.Oid `json:"stacoll3"` // stacoll3
- Stacoll4 pgtypes.Oid `json:"stacoll4"` // stacoll4
- Stacoll5 pgtypes.Oid `json:"stacoll5"` // stacoll5
- Stanumbers1 []sql.NullFloat64 `json:"stanumbers1"` // stanumbers1
- Stanumbers2 []sql.NullFloat64 `json:"stanumbers2"` // stanumbers2
- Stanumbers3 []sql.NullFloat64 `json:"stanumbers3"` // stanumbers3
- Stanumbers4 []sql.NullFloat64 `json:"stanumbers4"` // stanumbers4
- Stanumbers5 []sql.NullFloat64 `json:"stanumbers5"` // stanumbers5
- Stavalues1 pgtypes.NullAnyarray `json:"stavalues1"` // stavalues1
- Stavalues2 pgtypes.NullAnyarray `json:"stavalues2"` // stavalues2
- Stavalues3 pgtypes.NullAnyarray `json:"stavalues3"` // stavalues3
- Stavalues4 pgtypes.NullAnyarray `json:"stavalues4"` // stavalues4
- Stavalues5 pgtypes.NullAnyarray `json:"stavalues5"` // stavalues5
- }
- // PgStatisticExt represents a row from 'pg_catalog.pg_statistic_ext'.
- type PgStatisticExt 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Stxrelid pgtypes.Oid `json:"stxrelid"` // stxrelid
- Stxname string `json:"stxname"` // stxname
- Stxnamespace pgtypes.Oid `json:"stxnamespace"` // stxnamespace
- Stxowner pgtypes.Oid `json:"stxowner"` // stxowner
- Stxstattarget int `json:"stxstattarget"` // stxstattarget
- Stxkeys pgtypes.Int2vector `json:"stxkeys"` // stxkeys
- Stxkind []pgtypes.Char `json:"stxkind"` // stxkind
- }
- // PgStatisticExtDatum represents a row from 'pg_catalog.pg_statistic_ext_data'.
- type PgStatisticExtDatum 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
- Stxoid pgtypes.Oid `json:"stxoid"` // stxoid
- Stxdndistinct pgtypes.NullPgNdistinct `json:"stxdndistinct"` // stxdndistinct
- Stxddependencies pgtypes.NullPgDependencies `json:"stxddependencies"` // stxddependencies
- Stxdmcv pgtypes.NullPgMcvList `json:"stxdmcv"` // stxdmcv
- }
- // PgStatsExt represents a row from 'pg_catalog.pg_stats_ext'.
- type PgStatsExt struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- StatisticsSchemaname sql.NullString `json:"statistics_schemaname"` // statistics_schemaname
- StatisticsName sql.NullString `json:"statistics_name"` // statistics_name
- StatisticsOwner sql.NullString `json:"statistics_owner"` // statistics_owner
- Attnames []sql.NullString `json:"attnames"` // attnames
- Kinds []pgtypes.NullChar `json:"kinds"` // kinds
- NDistinct pgtypes.NullPgNdistinct `json:"n_distinct"` // n_distinct
- Dependencies pgtypes.NullPgDependencies `json:"dependencies"` // dependencies
- MostCommonVals []sql.NullString `json:"most_common_vals"` // most_common_vals
- MostCommonValNulls []sql.NullBool `json:"most_common_val_nulls"` // most_common_val_nulls
- MostCommonFreqs []sql.NullFloat64 `json:"most_common_freqs"` // most_common_freqs
- MostCommonBaseFreqs []sql.NullFloat64 `json:"most_common_base_freqs"` // most_common_base_freqs
- }
- // PgSubscription represents a row from 'pg_catalog.pg_subscription'.
- type PgSubscription 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Subdbid pgtypes.Oid `json:"subdbid"` // subdbid
- Subname string `json:"subname"` // subname
- Subowner pgtypes.Oid `json:"subowner"` // subowner
- Subenabled bool `json:"subenabled"` // subenabled
- Subconninfo string `json:"subconninfo"` // subconninfo
- Subslotname sql.NullString `json:"subslotname"` // subslotname
- Subsynccommit string `json:"subsynccommit"` // subsynccommit
- Subpublications StringSlice `json:"subpublications"` // subpublications
- }
- // PgSubscriptionRel represents a row from 'pg_catalog.pg_subscription_rel'.
- type PgSubscriptionRel 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
- Srsubid pgtypes.Oid `json:"srsubid"` // srsubid
- Srrelid pgtypes.Oid `json:"srrelid"` // srrelid
- Srsubstate pgtypes.Char `json:"srsubstate"` // srsubstate
- Srsublsn pgtypes.NullPgLsn `json:"srsublsn"` // srsublsn
- }
- // PgTable represents a row from 'pg_catalog.pg_tables'.
- type PgTable struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Tablename sql.NullString `json:"tablename"` // tablename
- Tableowner sql.NullString `json:"tableowner"` // tableowner
- Tablespace sql.NullString `json:"tablespace"` // tablespace
- Hasindexes sql.NullBool `json:"hasindexes"` // hasindexes
- Hasrules sql.NullBool `json:"hasrules"` // hasrules
- Hastriggers sql.NullBool `json:"hastriggers"` // hastriggers
- Rowsecurity sql.NullBool `json:"rowsecurity"` // rowsecurity
- }
- // PgTablespace represents a row from 'pg_catalog.pg_tablespace'.
- type PgTablespace 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Spcname string `json:"spcname"` // spcname
- Spcowner pgtypes.Oid `json:"spcowner"` // spcowner
- Spcacl []pgtypes.NullAclitem `json:"spcacl"` // spcacl
- Spcoptions []sql.NullString `json:"spcoptions"` // spcoptions
- }
- // PgTimezoneAbbrev represents a row from 'pg_catalog.pg_timezone_abbrevs'.
- type PgTimezoneAbbrev struct {
- Abbrev sql.NullString `json:"abbrev"` // abbrev
- UTCOffset []byte `json:"utc_offset"` // utc_offset
- IsDst sql.NullBool `json:"is_dst"` // is_dst
- }
- // PgTimezoneName represents a row from 'pg_catalog.pg_timezone_names'.
- type PgTimezoneName struct {
- Name sql.NullString `json:"name"` // name
- Abbrev sql.NullString `json:"abbrev"` // abbrev
- UTCOffset []byte `json:"utc_offset"` // utc_offset
- IsDst sql.NullBool `json:"is_dst"` // is_dst
- }
- // PgTransform represents a row from 'pg_catalog.pg_transform'.
- type PgTransform 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Trftype pgtypes.Oid `json:"trftype"` // trftype
- Trflang pgtypes.Oid `json:"trflang"` // trflang
- Trffromsql pgtypes.Regproc `json:"trffromsql"` // trffromsql
- Trftosql pgtypes.Regproc `json:"trftosql"` // trftosql
- }
- // PgTrigger represents a row from 'pg_catalog.pg_trigger'.
- type PgTrigger 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Tgrelid pgtypes.Oid `json:"tgrelid"` // tgrelid
- Tgparentid pgtypes.Oid `json:"tgparentid"` // tgparentid
- Tgname string `json:"tgname"` // tgname
- Tgfoid pgtypes.Oid `json:"tgfoid"` // tgfoid
- Tgtype int16 `json:"tgtype"` // tgtype
- Tgenabled pgtypes.Char `json:"tgenabled"` // tgenabled
- Tgisinternal bool `json:"tgisinternal"` // tgisinternal
- Tgconstrrelid pgtypes.Oid `json:"tgconstrrelid"` // tgconstrrelid
- Tgconstrindid pgtypes.Oid `json:"tgconstrindid"` // tgconstrindid
- Tgconstraint pgtypes.Oid `json:"tgconstraint"` // tgconstraint
- Tgdeferrable bool `json:"tgdeferrable"` // tgdeferrable
- Tginitdeferred bool `json:"tginitdeferred"` // tginitdeferred
- Tgnargs int16 `json:"tgnargs"` // tgnargs
- Tgattr pgtypes.Int2vector `json:"tgattr"` // tgattr
- Tgargs []byte `json:"tgargs"` // tgargs
- Tgqual pgtypes.NullPgNodeTree `json:"tgqual"` // tgqual
- Tgoldtable sql.NullString `json:"tgoldtable"` // tgoldtable
- Tgnewtable sql.NullString `json:"tgnewtable"` // tgnewtable
- }
- // PgTsConfig represents a row from 'pg_catalog.pg_ts_config'.
- type PgTsConfig 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Cfgname string `json:"cfgname"` // cfgname
- Cfgnamespace pgtypes.Oid `json:"cfgnamespace"` // cfgnamespace
- Cfgowner pgtypes.Oid `json:"cfgowner"` // cfgowner
- Cfgparser pgtypes.Oid `json:"cfgparser"` // cfgparser
- }
- // PgTsConfigMap represents a row from 'pg_catalog.pg_ts_config_map'.
- type PgTsConfigMap 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
- Mapcfg pgtypes.Oid `json:"mapcfg"` // mapcfg
- Maptokentype int `json:"maptokentype"` // maptokentype
- Mapseqno int `json:"mapseqno"` // mapseqno
- Mapdict pgtypes.Oid `json:"mapdict"` // mapdict
- }
- // PgTsDict represents a row from 'pg_catalog.pg_ts_dict'.
- type PgTsDict 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Dictname string `json:"dictname"` // dictname
- Dictnamespace pgtypes.Oid `json:"dictnamespace"` // dictnamespace
- Dictowner pgtypes.Oid `json:"dictowner"` // dictowner
- Dicttemplate pgtypes.Oid `json:"dicttemplate"` // dicttemplate
- Dictinitoption sql.NullString `json:"dictinitoption"` // dictinitoption
- }
- // PgTsParser represents a row from 'pg_catalog.pg_ts_parser'.
- type PgTsParser 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Prsname string `json:"prsname"` // prsname
- Prsnamespace pgtypes.Oid `json:"prsnamespace"` // prsnamespace
- Prsstart pgtypes.Regproc `json:"prsstart"` // prsstart
- Prstoken pgtypes.Regproc `json:"prstoken"` // prstoken
- Prsend pgtypes.Regproc `json:"prsend"` // prsend
- Prsheadline pgtypes.Regproc `json:"prsheadline"` // prsheadline
- Prslextype pgtypes.Regproc `json:"prslextype"` // prslextype
- }
- // PgTsTemplate represents a row from 'pg_catalog.pg_ts_template'.
- type PgTsTemplate 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Tmplname string `json:"tmplname"` // tmplname
- Tmplnamespace pgtypes.Oid `json:"tmplnamespace"` // tmplnamespace
- Tmplinit pgtypes.Regproc `json:"tmplinit"` // tmplinit
- Tmpllexize pgtypes.Regproc `json:"tmpllexize"` // tmpllexize
- }
- // PgType represents a row from 'pg_catalog.pg_type'.
- type PgType 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Typname string `json:"typname"` // typname
- Typnamespace pgtypes.Oid `json:"typnamespace"` // typnamespace
- Typowner pgtypes.Oid `json:"typowner"` // typowner
- Typlen int16 `json:"typlen"` // typlen
- Typbyval bool `json:"typbyval"` // typbyval
- Typtype pgtypes.Char `json:"typtype"` // typtype
- Typcategory pgtypes.Char `json:"typcategory"` // typcategory
- Typispreferred bool `json:"typispreferred"` // typispreferred
- Typisdefined bool `json:"typisdefined"` // typisdefined
- Typdelim pgtypes.Char `json:"typdelim"` // typdelim
- Typrelid pgtypes.Oid `json:"typrelid"` // typrelid
- Typelem pgtypes.Oid `json:"typelem"` // typelem
- Typarray pgtypes.Oid `json:"typarray"` // typarray
- Typinput pgtypes.Regproc `json:"typinput"` // typinput
- Typoutput pgtypes.Regproc `json:"typoutput"` // typoutput
- Typreceive pgtypes.Regproc `json:"typreceive"` // typreceive
- Typsend pgtypes.Regproc `json:"typsend"` // typsend
- Typmodin pgtypes.Regproc `json:"typmodin"` // typmodin
- Typmodout pgtypes.Regproc `json:"typmodout"` // typmodout
- Typanalyze pgtypes.Regproc `json:"typanalyze"` // typanalyze
- Typalign pgtypes.Char `json:"typalign"` // typalign
- Typstorage pgtypes.Char `json:"typstorage"` // typstorage
- Typnotnull bool `json:"typnotnull"` // typnotnull
- Typbasetype pgtypes.Oid `json:"typbasetype"` // typbasetype
- Typtypmod int `json:"typtypmod"` // typtypmod
- Typndims int `json:"typndims"` // typndims
- Typcollation pgtypes.Oid `json:"typcollation"` // typcollation
- Typdefaultbin pgtypes.NullPgNodeTree `json:"typdefaultbin"` // typdefaultbin
- Typdefault sql.NullString `json:"typdefault"` // typdefault
- Typacl []pgtypes.NullAclitem `json:"typacl"` // typacl
- }
- // PgUser represents a row from 'pg_catalog.pg_user'.
- type PgUser struct {
- Usename sql.NullString `json:"usename"` // usename
- Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
- Usecreatedb sql.NullBool `json:"usecreatedb"` // usecreatedb
- Usesuper sql.NullBool `json:"usesuper"` // usesuper
- Userepl sql.NullBool `json:"userepl"` // userepl
- Usebypassrls sql.NullBool `json:"usebypassrls"` // usebypassrls
- Passwd sql.NullString `json:"passwd"` // passwd
- Valuntil sql.NullTime `json:"valuntil"` // valuntil
- Useconfig []sql.NullString `json:"useconfig"` // useconfig
- }
- // PgUserMapping represents a row from 'pg_catalog.pg_user_mapping'.
- type PgUserMapping 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
- Oid pgtypes.Oid `json:"oid"` // oid
- Umuser pgtypes.Oid `json:"umuser"` // umuser
- Umserver pgtypes.Oid `json:"umserver"` // umserver
- Umoptions []sql.NullString `json:"umoptions"` // umoptions
- }
- // PgUserMapping represents a row from 'pg_catalog.pg_user_mappings'.
- type PgUserMapping struct {
- Umid pgtypes.NullOid `json:"umid"` // umid
- Srvid pgtypes.NullOid `json:"srvid"` // srvid
- Srvname sql.NullString `json:"srvname"` // srvname
- Umuser pgtypes.NullOid `json:"umuser"` // umuser
- Usename sql.NullString `json:"usename"` // usename
- Umoptions []sql.NullString `json:"umoptions"` // umoptions
- }
- // PgView represents a row from 'pg_catalog.pg_views'.
- type PgView struct {
- Schemaname sql.NullString `json:"schemaname"` // schemaname
- Viewname sql.NullString `json:"viewname"` // viewname
- Viewowner sql.NullString `json:"viewowner"` // viewowner
- Definition sql.NullString `json:"definition"` // definition
- }
- // PgAggregateByAggfnoid retrieves a row from 'pg_catalog.pg_aggregate' as a PgAggregate.
- //
- // Generated from index 'pg_aggregate_fnoid_index'.
- func PgAggregateByAggfnoid(ctx context.Context, db DB, aggfnoid pgtypes.Regproc) (*PgAggregate, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, aggfnoid, aggkind, aggnumdirectargs, aggtransfn, aggfinalfn, aggcombinefn, aggserialfn, aggdeserialfn, aggmtransfn, aggminvtransfn, aggmfinalfn, aggfinalextra, aggmfinalextra, aggfinalmodify, aggmfinalmodify, aggsortop, aggtranstype, aggtransspace, aggmtranstype, aggmtransspace, agginitval, aggminitval ` +
- `FROM pg_catalog.pg_aggregate ` +
- `WHERE aggfnoid = $1`
- // run
- logf(sqlstr, aggfnoid)
- pa := PgAggregate{}
- if err := db.QueryRowContext(ctx, sqlstr, aggfnoid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Aggfnoid, &pa.Aggkind, &pa.Aggnumdirectargs, &pa.Aggtransfn, &pa.Aggfinalfn, &pa.Aggcombinefn, &pa.Aggserialfn, &pa.Aggdeserialfn, &pa.Aggmtransfn, &pa.Aggminvtransfn, &pa.Aggmfinalfn, &pa.Aggfinalextra, &pa.Aggmfinalextra, &pa.Aggfinalmodify, &pa.Aggmfinalmodify, &pa.Aggsortop, &pa.Aggtranstype, &pa.Aggtransspace, &pa.Aggmtranstype, &pa.Aggmtransspace, &pa.Agginitval, &pa.Aggminitval); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmByAmname retrieves a row from 'pg_catalog.pg_am' as a PgAm.
- //
- // Generated from index 'pg_am_name_index'.
- func PgAmByAmname(ctx context.Context, db DB, amname string) (*PgAm, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amname, amhandler, amtype ` +
- `FROM pg_catalog.pg_am ` +
- `WHERE amname = $1`
- // run
- logf(sqlstr, amname)
- pa := PgAm{}
- if err := db.QueryRowContext(ctx, sqlstr, amname).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amname, &pa.Amhandler, &pa.Amtype); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmByOid retrieves a row from 'pg_catalog.pg_am' as a PgAm.
- //
- // Generated from index 'pg_am_oid_index'.
- func PgAmByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAm, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amname, amhandler, amtype ` +
- `FROM pg_catalog.pg_am ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pa := PgAm{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amname, &pa.Amhandler, &pa.Amtype); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmopByAmopfamilyAmoplefttypeAmoprighttypeAmopstrategy retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
- //
- // Generated from index 'pg_amop_fam_strat_index'.
- func PgAmopByAmopfamilyAmoplefttypeAmoprighttypeAmopstrategy(ctx context.Context, db DB, amopfamily, amoplefttype, amoprighttype pgtypes.Oid, amopstrategy int16) (*PgAmop, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
- `FROM pg_catalog.pg_amop ` +
- `WHERE amopfamily = $1 AND amoplefttype = $2 AND amoprighttype = $3 AND amopstrategy = $4`
- // run
- logf(sqlstr, amopfamily, amoplefttype, amoprighttype, amopstrategy)
- pa := PgAmop{}
- if err := db.QueryRowContext(ctx, sqlstr, amopfamily, amoplefttype, amoprighttype, amopstrategy).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amopfamily, &pa.Amoplefttype, &pa.Amoprighttype, &pa.Amopstrategy, &pa.Amoppurpose, &pa.Amopopr, &pa.Amopmethod, &pa.Amopsortfamily); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmopByOid retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
- //
- // Generated from index 'pg_amop_oid_index'.
- func PgAmopByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAmop, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
- `FROM pg_catalog.pg_amop ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pa := PgAmop{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amopfamily, &pa.Amoplefttype, &pa.Amoprighttype, &pa.Amopstrategy, &pa.Amoppurpose, &pa.Amopopr, &pa.Amopmethod, &pa.Amopsortfamily); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmopByAmopoprAmoppurposeAmopfamily retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
- //
- // Generated from index 'pg_amop_opr_fam_index'.
- func PgAmopByAmopoprAmoppurposeAmopfamily(ctx context.Context, db DB, amopopr pgtypes.Oid, amoppurpose pgtypes.Char, amopfamily pgtypes.Oid) (*PgAmop, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
- `FROM pg_catalog.pg_amop ` +
- `WHERE amopopr = $1 AND amoppurpose = $2 AND amopfamily = $3`
- // run
- logf(sqlstr, amopopr, amoppurpose, amopfamily)
- pa := PgAmop{}
- if err := db.QueryRowContext(ctx, sqlstr, amopopr, amoppurpose, amopfamily).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amopfamily, &pa.Amoplefttype, &pa.Amoprighttype, &pa.Amopstrategy, &pa.Amoppurpose, &pa.Amopopr, &pa.Amopmethod, &pa.Amopsortfamily); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmprocByAmprocfamilyAmproclefttypeAmprocrighttypeAmprocnum retrieves a row from 'pg_catalog.pg_amproc' as a PgAmproc.
- //
- // Generated from index 'pg_amproc_fam_proc_index'.
- func PgAmprocByAmprocfamilyAmproclefttypeAmprocrighttypeAmprocnum(ctx context.Context, db DB, amprocfamily, amproclefttype, amprocrighttype pgtypes.Oid, amprocnum int16) (*PgAmproc, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amprocfamily, amproclefttype, amprocrighttype, amprocnum, amproc ` +
- `FROM pg_catalog.pg_amproc ` +
- `WHERE amprocfamily = $1 AND amproclefttype = $2 AND amprocrighttype = $3 AND amprocnum = $4`
- // run
- logf(sqlstr, amprocfamily, amproclefttype, amprocrighttype, amprocnum)
- pa := PgAmproc{}
- if err := db.QueryRowContext(ctx, sqlstr, amprocfamily, amproclefttype, amprocrighttype, amprocnum).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amprocfamily, &pa.Amproclefttype, &pa.Amprocrighttype, &pa.Amprocnum, &pa.Amproc); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAmprocByOid retrieves a row from 'pg_catalog.pg_amproc' as a PgAmproc.
- //
- // Generated from index 'pg_amproc_oid_index'.
- func PgAmprocByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAmproc, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amprocfamily, amproclefttype, amprocrighttype, amprocnum, amproc ` +
- `FROM pg_catalog.pg_amproc ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pa := PgAmproc{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Amprocfamily, &pa.Amproclefttype, &pa.Amprocrighttype, &pa.Amprocnum, &pa.Amproc); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAttrdefByAdrelidAdnum retrieves a row from 'pg_catalog.pg_attrdef' as a PgAttrdef.
- //
- // Generated from index 'pg_attrdef_adrelid_adnum_index'.
- func PgAttrdefByAdrelidAdnum(ctx context.Context, db DB, adrelid pgtypes.Oid, adnum int16) (*PgAttrdef, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, adrelid, adnum, adbin ` +
- `FROM pg_catalog.pg_attrdef ` +
- `WHERE adrelid = $1 AND adnum = $2`
- // run
- logf(sqlstr, adrelid, adnum)
- pa := PgAttrdef{}
- if err := db.QueryRowContext(ctx, sqlstr, adrelid, adnum).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Adrelid, &pa.Adnum, &pa.Adbin); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAttrdefByOid retrieves a row from 'pg_catalog.pg_attrdef' as a PgAttrdef.
- //
- // Generated from index 'pg_attrdef_oid_index'.
- func PgAttrdefByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAttrdef, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, adrelid, adnum, adbin ` +
- `FROM pg_catalog.pg_attrdef ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pa := PgAttrdef{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Adrelid, &pa.Adnum, &pa.Adbin); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAttributeByAttrelidAttname retrieves a row from 'pg_catalog.pg_attribute' as a PgAttribute.
- //
- // Generated from index 'pg_attribute_relid_attnam_index'.
- func PgAttributeByAttrelidAttname(ctx context.Context, db DB, attrelid pgtypes.Oid, attname string) (*PgAttribute, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, attrelid, attname, atttypid, attstattarget, attlen, attnum, attndims, attcacheoff, atttypmod, attbyval, attstorage, attalign, attnotnull, atthasdef, atthasmissing, attidentity, attgenerated, attisdropped, attislocal, attinhcount, attcollation, attacl, attoptions, attfdwoptions, attmissingval ` +
- `FROM pg_catalog.pg_attribute ` +
- `WHERE attrelid = $1 AND attname = $2`
- // run
- logf(sqlstr, attrelid, attname)
- pa := PgAttribute{}
- if err := db.QueryRowContext(ctx, sqlstr, attrelid, attname).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Attrelid, &pa.Attname, &pa.Atttypid, &pa.Attstattarget, &pa.Attlen, &pa.Attnum, &pa.Attndims, &pa.Attcacheoff, &pa.Atttypmod, &pa.Attbyval, &pa.Attstorage, &pa.Attalign, &pa.Attnotnull, &pa.Atthasdef, &pa.Atthasmissing, &pa.Attidentity, &pa.Attgenerated, &pa.Attisdropped, &pa.Attislocal, &pa.Attinhcount, &pa.Attcollation, &pa.Attacl, &pa.Attoptions, &pa.Attfdwoptions, &pa.Attmissingval); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAttributeByAttrelidAttnum retrieves a row from 'pg_catalog.pg_attribute' as a PgAttribute.
- //
- // Generated from index 'pg_attribute_relid_attnum_index'.
- func PgAttributeByAttrelidAttnum(ctx context.Context, db DB, attrelid pgtypes.Oid, attnum int16) (*PgAttribute, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, attrelid, attname, atttypid, attstattarget, attlen, attnum, attndims, attcacheoff, atttypmod, attbyval, attstorage, attalign, attnotnull, atthasdef, atthasmissing, attidentity, attgenerated, attisdropped, attislocal, attinhcount, attcollation, attacl, attoptions, attfdwoptions, attmissingval ` +
- `FROM pg_catalog.pg_attribute ` +
- `WHERE attrelid = $1 AND attnum = $2`
- // run
- logf(sqlstr, attrelid, attnum)
- pa := PgAttribute{}
- if err := db.QueryRowContext(ctx, sqlstr, attrelid, attnum).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Attrelid, &pa.Attname, &pa.Atttypid, &pa.Attstattarget, &pa.Attlen, &pa.Attnum, &pa.Attndims, &pa.Attcacheoff, &pa.Atttypmod, &pa.Attbyval, &pa.Attstorage, &pa.Attalign, &pa.Attnotnull, &pa.Atthasdef, &pa.Atthasmissing, &pa.Attidentity, &pa.Attgenerated, &pa.Attisdropped, &pa.Attislocal, &pa.Attinhcount, &pa.Attcollation, &pa.Attacl, &pa.Attoptions, &pa.Attfdwoptions, &pa.Attmissingval); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAuthMemberByMemberRoleid retrieves a row from 'pg_catalog.pg_auth_members' as a PgAuthMember.
- //
- // Generated from index 'pg_auth_members_member_role_index'.
- func PgAuthMemberByMemberRoleid(ctx context.Context, db DB, member, roleid pgtypes.Oid) (*PgAuthMember, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, roleid, member, grantor, admin_option ` +
- `FROM pg_catalog.pg_auth_members ` +
- `WHERE member = $1 AND roleid = $2`
- // run
- logf(sqlstr, member, roleid)
- pam := PgAuthMember{}
- if err := db.QueryRowContext(ctx, sqlstr, member, roleid).Scan(&pam.Tableoid, &pam.Cmax, &pam.Xmax, &pam.Cmin, &pam.Xmin, &pam.Ctid, &pam.Roleid, &pam.Member, &pam.Grantor, &pam.AdminOption); err != nil {
- return nil, logerror(err)
- }
- return &pam, nil
- }
- // PgAuthMemberByRoleidMember retrieves a row from 'pg_catalog.pg_auth_members' as a PgAuthMember.
- //
- // Generated from index 'pg_auth_members_role_member_index'.
- func PgAuthMemberByRoleidMember(ctx context.Context, db DB, roleid, member pgtypes.Oid) (*PgAuthMember, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, roleid, member, grantor, admin_option ` +
- `FROM pg_catalog.pg_auth_members ` +
- `WHERE roleid = $1 AND member = $2`
- // run
- logf(sqlstr, roleid, member)
- pam := PgAuthMember{}
- if err := db.QueryRowContext(ctx, sqlstr, roleid, member).Scan(&pam.Tableoid, &pam.Cmax, &pam.Xmax, &pam.Cmin, &pam.Xmin, &pam.Ctid, &pam.Roleid, &pam.Member, &pam.Grantor, &pam.AdminOption); err != nil {
- return nil, logerror(err)
- }
- return &pam, nil
- }
- // PgAuthidByOid retrieves a row from 'pg_catalog.pg_authid' as a PgAuthid.
- //
- // Generated from index 'pg_authid_oid_index'.
- func PgAuthidByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAuthid, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolreplication, rolbypassrls, rolconnlimit, rolpassword, rolvaliduntil ` +
- `FROM pg_catalog.pg_authid ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pa := PgAuthid{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Rolname, &pa.Rolsuper, &pa.Rolinherit, &pa.Rolcreaterole, &pa.Rolcreatedb, &pa.Rolcanlogin, &pa.Rolreplication, &pa.Rolbypassrls, &pa.Rolconnlimit, &pa.Rolpassword, &pa.Rolvaliduntil); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgAuthidByRolname retrieves a row from 'pg_catalog.pg_authid' as a PgAuthid.
- //
- // Generated from index 'pg_authid_rolname_index'.
- func PgAuthidByRolname(ctx context.Context, db DB, rolname string) (*PgAuthid, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolreplication, rolbypassrls, rolconnlimit, rolpassword, rolvaliduntil ` +
- `FROM pg_catalog.pg_authid ` +
- `WHERE rolname = $1`
- // run
- logf(sqlstr, rolname)
- pa := PgAuthid{}
- if err := db.QueryRowContext(ctx, sqlstr, rolname).Scan(&pa.Tableoid, &pa.Cmax, &pa.Xmax, &pa.Cmin, &pa.Xmin, &pa.Ctid, &pa.Oid, &pa.Rolname, &pa.Rolsuper, &pa.Rolinherit, &pa.Rolcreaterole, &pa.Rolcreatedb, &pa.Rolcanlogin, &pa.Rolreplication, &pa.Rolbypassrls, &pa.Rolconnlimit, &pa.Rolpassword, &pa.Rolvaliduntil); err != nil {
- return nil, logerror(err)
- }
- return &pa, nil
- }
- // PgCastByOid retrieves a row from 'pg_catalog.pg_cast' as a PgCast.
- //
- // Generated from index 'pg_cast_oid_index'.
- func PgCastByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgCast, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, castsource, casttarget, castfunc, castcontext, castmethod ` +
- `FROM pg_catalog.pg_cast ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pc := PgCast{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Castsource, &pc.Casttarget, &pc.Castfunc, &pc.Castcontext, &pc.Castmethod); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgCastByCastsourceCasttarget retrieves a row from 'pg_catalog.pg_cast' as a PgCast.
- //
- // Generated from index 'pg_cast_source_target_index'.
- func PgCastByCastsourceCasttarget(ctx context.Context, db DB, castsource, casttarget pgtypes.Oid) (*PgCast, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, castsource, casttarget, castfunc, castcontext, castmethod ` +
- `FROM pg_catalog.pg_cast ` +
- `WHERE castsource = $1 AND casttarget = $2`
- // run
- logf(sqlstr, castsource, casttarget)
- pc := PgCast{}
- if err := db.QueryRowContext(ctx, sqlstr, castsource, casttarget).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Castsource, &pc.Casttarget, &pc.Castfunc, &pc.Castcontext, &pc.Castmethod); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgClassByOid retrieves a row from 'pg_catalog.pg_class' as a PgClass.
- //
- // Generated from index 'pg_class_oid_index'.
- func PgClassByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgClass, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, relname, relnamespace, reltype, reloftype, relowner, relam, relfilenode, reltablespace, relpages, reltuples, relallvisible, reltoastrelid, relhasindex, relisshared, relpersistence, relkind, relnatts, relchecks, relhasrules, relhastriggers, relhassubclass, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relispartition, relrewrite, relfrozenxid, relminmxid, relacl, reloptions, relpartbound ` +
- `FROM pg_catalog.pg_class ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pc := PgClass{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Relname, &pc.Relnamespace, &pc.Reltype, &pc.Reloftype, &pc.Relowner, &pc.Relam, &pc.Relfilenode, &pc.Reltablespace, &pc.Relpages, &pc.Reltuples, &pc.Relallvisible, &pc.Reltoastrelid, &pc.Relhasindex, &pc.Relisshared, &pc.Relpersistence, &pc.Relkind, &pc.Relnatts, &pc.Relchecks, &pc.Relhasrules, &pc.Relhastriggers, &pc.Relhassubclass, &pc.Relrowsecurity, &pc.Relforcerowsecurity, &pc.Relispopulated, &pc.Relreplident, &pc.Relispartition, &pc.Relrewrite, &pc.Relfrozenxid, &pc.Relminmxid, &pc.Relacl, &pc.Reloptions, &pc.Relpartbound); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgClassByRelnameRelnamespace retrieves a row from 'pg_catalog.pg_class' as a PgClass.
- //
- // Generated from index 'pg_class_relname_nsp_index'.
- func PgClassByRelnameRelnamespace(ctx context.Context, db DB, relname string, relnamespace pgtypes.Oid) (*PgClass, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, relname, relnamespace, reltype, reloftype, relowner, relam, relfilenode, reltablespace, relpages, reltuples, relallvisible, reltoastrelid, relhasindex, relisshared, relpersistence, relkind, relnatts, relchecks, relhasrules, relhastriggers, relhassubclass, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relispartition, relrewrite, relfrozenxid, relminmxid, relacl, reloptions, relpartbound ` +
- `FROM pg_catalog.pg_class ` +
- `WHERE relname = $1 AND relnamespace = $2`
- // run
- logf(sqlstr, relname, relnamespace)
- pc := PgClass{}
- if err := db.QueryRowContext(ctx, sqlstr, relname, relnamespace).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Relname, &pc.Relnamespace, &pc.Reltype, &pc.Reloftype, &pc.Relowner, &pc.Relam, &pc.Relfilenode, &pc.Reltablespace, &pc.Relpages, &pc.Reltuples, &pc.Relallvisible, &pc.Reltoastrelid, &pc.Relhasindex, &pc.Relisshared, &pc.Relpersistence, &pc.Relkind, &pc.Relnatts, &pc.Relchecks, &pc.Relhasrules, &pc.Relhastriggers, &pc.Relhassubclass, &pc.Relrowsecurity, &pc.Relforcerowsecurity, &pc.Relispopulated, &pc.Relreplident, &pc.Relispartition, &pc.Relrewrite, &pc.Relfrozenxid, &pc.Relminmxid, &pc.Relacl, &pc.Reloptions, &pc.Relpartbound); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgClassByReltablespaceRelfilenode retrieves a row from 'pg_catalog.pg_class' as a PgClass.
- //
- // Generated from index 'pg_class_tblspc_relfilenode_index'.
- func PgClassByReltablespaceRelfilenode(ctx context.Context, db DB, reltablespace, relfilenode pgtypes.Oid) ([]*PgClass, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, relname, relnamespace, reltype, reloftype, relowner, relam, relfilenode, reltablespace, relpages, reltuples, relallvisible, reltoastrelid, relhasindex, relisshared, relpersistence, relkind, relnatts, relchecks, relhasrules, relhastriggers, relhassubclass, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relispartition, relrewrite, relfrozenxid, relminmxid, relacl, reloptions, relpartbound ` +
- `FROM pg_catalog.pg_class ` +
- `WHERE reltablespace = $1 AND relfilenode = $2`
- // run
- logf(sqlstr, reltablespace, relfilenode)
- rows, err := db.QueryContext(ctx, sqlstr, reltablespace, relfilenode)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgClass
- for rows.Next() {
- pc := PgClass{}
- // scan
- if err := rows.Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Relname, &pc.Relnamespace, &pc.Reltype, &pc.Reloftype, &pc.Relowner, &pc.Relam, &pc.Relfilenode, &pc.Reltablespace, &pc.Relpages, &pc.Reltuples, &pc.Relallvisible, &pc.Reltoastrelid, &pc.Relhasindex, &pc.Relisshared, &pc.Relpersistence, &pc.Relkind, &pc.Relnatts, &pc.Relchecks, &pc.Relhasrules, &pc.Relhastriggers, &pc.Relhassubclass, &pc.Relrowsecurity, &pc.Relforcerowsecurity, &pc.Relispopulated, &pc.Relreplident, &pc.Relispartition, &pc.Relrewrite, &pc.Relfrozenxid, &pc.Relminmxid, &pc.Relacl, &pc.Reloptions, &pc.Relpartbound); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pc)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgCollationByCollnameCollencodingCollnamespace retrieves a row from 'pg_catalog.pg_collation' as a PgCollation.
- //
- // Generated from index 'pg_collation_name_enc_nsp_index'.
- func PgCollationByCollnameCollencodingCollnamespace(ctx context.Context, db DB, collname string, collencoding int, collnamespace pgtypes.Oid) (*PgCollation, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, collname, collnamespace, collowner, collprovider, collisdeterministic, collencoding, collcollate, collctype, collversion ` +
- `FROM pg_catalog.pg_collation ` +
- `WHERE collname = $1 AND collencoding = $2 AND collnamespace = $3`
- // run
- logf(sqlstr, collname, collencoding, collnamespace)
- pc := PgCollation{}
- if err := db.QueryRowContext(ctx, sqlstr, collname, collencoding, collnamespace).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Collname, &pc.Collnamespace, &pc.Collowner, &pc.Collprovider, &pc.Collisdeterministic, &pc.Collencoding, &pc.Collcollate, &pc.Collctype, &pc.Collversion); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgCollationByOid retrieves a row from 'pg_catalog.pg_collation' as a PgCollation.
- //
- // Generated from index 'pg_collation_oid_index'.
- func PgCollationByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgCollation, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, collname, collnamespace, collowner, collprovider, collisdeterministic, collencoding, collcollate, collctype, collversion ` +
- `FROM pg_catalog.pg_collation ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pc := PgCollation{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Collname, &pc.Collnamespace, &pc.Collowner, &pc.Collprovider, &pc.Collisdeterministic, &pc.Collencoding, &pc.Collcollate, &pc.Collctype, &pc.Collversion); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgConstraintByConnameConnamespace retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
- //
- // Generated from index 'pg_constraint_conname_nsp_index'.
- func PgConstraintByConnameConnamespace(ctx context.Context, db DB, conname string, connamespace pgtypes.Oid) ([]*PgConstraint, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, contype, condeferrable, condeferred, convalidated, conrelid, contypid, conindid, conparentid, confrelid, confupdtype, confdeltype, confmatchtype, conislocal, coninhcount, connoinherit, conkey, confkey, conpfeqop, conppeqop, conffeqop, conexclop, conbin ` +
- `FROM pg_catalog.pg_constraint ` +
- `WHERE conname = $1 AND connamespace = $2`
- // run
- logf(sqlstr, conname, connamespace)
- rows, err := db.QueryContext(ctx, sqlstr, conname, connamespace)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgConstraint
- for rows.Next() {
- pc := PgConstraint{}
- // scan
- if err := rows.Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Contype, &pc.Condeferrable, &pc.Condeferred, &pc.Convalidated, &pc.Conrelid, &pc.Contypid, &pc.Conindid, &pc.Conparentid, &pc.Confrelid, &pc.Confupdtype, &pc.Confdeltype, &pc.Confmatchtype, &pc.Conislocal, &pc.Coninhcount, &pc.Connoinherit, &pc.Conkey, &pc.Confkey, &pc.Conpfeqop, &pc.Conppeqop, &pc.Conffeqop, &pc.Conexclop, &pc.Conbin); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pc)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgConstraintByConparentid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
- //
- // Generated from index 'pg_constraint_conparentid_index'.
- func PgConstraintByConparentid(ctx context.Context, db DB, conparentid pgtypes.Oid) ([]*PgConstraint, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, contype, condeferrable, condeferred, convalidated, conrelid, contypid, conindid, conparentid, confrelid, confupdtype, confdeltype, confmatchtype, conislocal, coninhcount, connoinherit, conkey, confkey, conpfeqop, conppeqop, conffeqop, conexclop, conbin ` +
- `FROM pg_catalog.pg_constraint ` +
- `WHERE conparentid = $1`
- // run
- logf(sqlstr, conparentid)
- rows, err := db.QueryContext(ctx, sqlstr, conparentid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgConstraint
- for rows.Next() {
- pc := PgConstraint{}
- // scan
- if err := rows.Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Contype, &pc.Condeferrable, &pc.Condeferred, &pc.Convalidated, &pc.Conrelid, &pc.Contypid, &pc.Conindid, &pc.Conparentid, &pc.Confrelid, &pc.Confupdtype, &pc.Confdeltype, &pc.Confmatchtype, &pc.Conislocal, &pc.Coninhcount, &pc.Connoinherit, &pc.Conkey, &pc.Confkey, &pc.Conpfeqop, &pc.Conppeqop, &pc.Conffeqop, &pc.Conexclop, &pc.Conbin); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pc)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgConstraintByConrelidContypidConname retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
- //
- // Generated from index 'pg_constraint_conrelid_contypid_conname_index'.
- func PgConstraintByConrelidContypidConname(ctx context.Context, db DB, conrelid, contypid pgtypes.Oid, conname string) (*PgConstraint, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, contype, condeferrable, condeferred, convalidated, conrelid, contypid, conindid, conparentid, confrelid, confupdtype, confdeltype, confmatchtype, conislocal, coninhcount, connoinherit, conkey, confkey, conpfeqop, conppeqop, conffeqop, conexclop, conbin ` +
- `FROM pg_catalog.pg_constraint ` +
- `WHERE conrelid = $1 AND contypid = $2 AND conname = $3`
- // run
- logf(sqlstr, conrelid, contypid, conname)
- pc := PgConstraint{}
- if err := db.QueryRowContext(ctx, sqlstr, conrelid, contypid, conname).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Contype, &pc.Condeferrable, &pc.Condeferred, &pc.Convalidated, &pc.Conrelid, &pc.Contypid, &pc.Conindid, &pc.Conparentid, &pc.Confrelid, &pc.Confupdtype, &pc.Confdeltype, &pc.Confmatchtype, &pc.Conislocal, &pc.Coninhcount, &pc.Connoinherit, &pc.Conkey, &pc.Confkey, &pc.Conpfeqop, &pc.Conppeqop, &pc.Conffeqop, &pc.Conexclop, &pc.Conbin); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgConstraintByContypid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
- //
- // Generated from index 'pg_constraint_contypid_index'.
- func PgConstraintByContypid(ctx context.Context, db DB, contypid pgtypes.Oid) ([]*PgConstraint, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, contype, condeferrable, condeferred, convalidated, conrelid, contypid, conindid, conparentid, confrelid, confupdtype, confdeltype, confmatchtype, conislocal, coninhcount, connoinherit, conkey, confkey, conpfeqop, conppeqop, conffeqop, conexclop, conbin ` +
- `FROM pg_catalog.pg_constraint ` +
- `WHERE contypid = $1`
- // run
- logf(sqlstr, contypid)
- rows, err := db.QueryContext(ctx, sqlstr, contypid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgConstraint
- for rows.Next() {
- pc := PgConstraint{}
- // scan
- if err := rows.Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Contype, &pc.Condeferrable, &pc.Condeferred, &pc.Convalidated, &pc.Conrelid, &pc.Contypid, &pc.Conindid, &pc.Conparentid, &pc.Confrelid, &pc.Confupdtype, &pc.Confdeltype, &pc.Confmatchtype, &pc.Conislocal, &pc.Coninhcount, &pc.Connoinherit, &pc.Conkey, &pc.Confkey, &pc.Conpfeqop, &pc.Conppeqop, &pc.Conffeqop, &pc.Conexclop, &pc.Conbin); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pc)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgConstraintByOid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
- //
- // Generated from index 'pg_constraint_oid_index'.
- func PgConstraintByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgConstraint, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, contype, condeferrable, condeferred, convalidated, conrelid, contypid, conindid, conparentid, confrelid, confupdtype, confdeltype, confmatchtype, conislocal, coninhcount, connoinherit, conkey, confkey, conpfeqop, conppeqop, conffeqop, conexclop, conbin ` +
- `FROM pg_catalog.pg_constraint ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pc := PgConstraint{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Contype, &pc.Condeferrable, &pc.Condeferred, &pc.Convalidated, &pc.Conrelid, &pc.Contypid, &pc.Conindid, &pc.Conparentid, &pc.Confrelid, &pc.Confupdtype, &pc.Confdeltype, &pc.Confmatchtype, &pc.Conislocal, &pc.Coninhcount, &pc.Connoinherit, &pc.Conkey, &pc.Confkey, &pc.Conpfeqop, &pc.Conppeqop, &pc.Conffeqop, &pc.Conexclop, &pc.Conbin); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgConversionByConnamespaceConforencodingContoencodingOid retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
- //
- // Generated from index 'pg_conversion_default_index'.
- func PgConversionByConnamespaceConforencodingContoencodingOid(ctx context.Context, db DB, connamespace pgtypes.Oid, conforencoding, contoencoding int, oid pgtypes.Oid) (*PgConversion, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
- `FROM pg_catalog.pg_conversion ` +
- `WHERE connamespace = $1 AND conforencoding = $2 AND contoencoding = $3 AND oid = $4`
- // run
- logf(sqlstr, connamespace, conforencoding, contoencoding, oid)
- pc := PgConversion{}
- if err := db.QueryRowContext(ctx, sqlstr, connamespace, conforencoding, contoencoding, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Conowner, &pc.Conforencoding, &pc.Contoencoding, &pc.Conproc, &pc.Condefault); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgConversionByConnameConnamespace retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
- //
- // Generated from index 'pg_conversion_name_nsp_index'.
- func PgConversionByConnameConnamespace(ctx context.Context, db DB, conname string, connamespace pgtypes.Oid) (*PgConversion, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
- `FROM pg_catalog.pg_conversion ` +
- `WHERE conname = $1 AND connamespace = $2`
- // run
- logf(sqlstr, conname, connamespace)
- pc := PgConversion{}
- if err := db.QueryRowContext(ctx, sqlstr, conname, connamespace).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Conowner, &pc.Conforencoding, &pc.Contoencoding, &pc.Conproc, &pc.Condefault); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgConversionByOid retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
- //
- // Generated from index 'pg_conversion_oid_index'.
- func PgConversionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgConversion, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
- `FROM pg_catalog.pg_conversion ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pc := PgConversion{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pc.Tableoid, &pc.Cmax, &pc.Xmax, &pc.Cmin, &pc.Xmin, &pc.Ctid, &pc.Oid, &pc.Conname, &pc.Connamespace, &pc.Conowner, &pc.Conforencoding, &pc.Contoencoding, &pc.Conproc, &pc.Condefault); err != nil {
- return nil, logerror(err)
- }
- return &pc, nil
- }
- // PgDatabaseByDatname retrieves a row from 'pg_catalog.pg_database' as a PgDatabase.
- //
- // Generated from index 'pg_database_datname_index'.
- func PgDatabaseByDatname(ctx context.Context, db DB, datname string) (*PgDatabase, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, datname, datdba, encoding, datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl ` +
- `FROM pg_catalog.pg_database ` +
- `WHERE datname = $1`
- // run
- logf(sqlstr, datname)
- pd := PgDatabase{}
- if err := db.QueryRowContext(ctx, sqlstr, datname).Scan(&pd.Tableoid, &pd.Cmax, &pd.Xmax, &pd.Cmin, &pd.Xmin, &pd.Ctid, &pd.Oid, &pd.Datname, &pd.Datdba, &pd.Encoding, &pd.Datcollate, &pd.Datctype, &pd.Datistemplate, &pd.Datallowconn, &pd.Datconnlimit, &pd.Datlastsysoid, &pd.Datfrozenxid, &pd.Datminmxid, &pd.Dattablespace, &pd.Datacl); err != nil {
- return nil, logerror(err)
- }
- return &pd, nil
- }
- // PgDatabaseByOid retrieves a row from 'pg_catalog.pg_database' as a PgDatabase.
- //
- // Generated from index 'pg_database_oid_index'.
- func PgDatabaseByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgDatabase, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, datname, datdba, encoding, datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl ` +
- `FROM pg_catalog.pg_database ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pd := PgDatabase{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pd.Tableoid, &pd.Cmax, &pd.Xmax, &pd.Cmin, &pd.Xmin, &pd.Ctid, &pd.Oid, &pd.Datname, &pd.Datdba, &pd.Encoding, &pd.Datcollate, &pd.Datctype, &pd.Datistemplate, &pd.Datallowconn, &pd.Datconnlimit, &pd.Datlastsysoid, &pd.Datfrozenxid, &pd.Datminmxid, &pd.Dattablespace, &pd.Datacl); err != nil {
- return nil, logerror(err)
- }
- return &pd, nil
- }
- // PgDbRoleSettingBySetdatabaseSetrole retrieves a row from 'pg_catalog.pg_db_role_setting' as a PgDbRoleSetting.
- //
- // Generated from index 'pg_db_role_setting_databaseid_rol_index'.
- func PgDbRoleSettingBySetdatabaseSetrole(ctx context.Context, db DB, setdatabase, setrole pgtypes.Oid) (*PgDbRoleSetting, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, setdatabase, setrole, setconfig ` +
- `FROM pg_catalog.pg_db_role_setting ` +
- `WHERE setdatabase = $1 AND setrole = $2`
- // run
- logf(sqlstr, setdatabase, setrole)
- pdrs := PgDbRoleSetting{}
- if err := db.QueryRowContext(ctx, sqlstr, setdatabase, setrole).Scan(&pdrs.Tableoid, &pdrs.Cmax, &pdrs.Xmax, &pdrs.Cmin, &pdrs.Xmin, &pdrs.Ctid, &pdrs.Setdatabase, &pdrs.Setrole, &pdrs.Setconfig); err != nil {
- return nil, logerror(err)
- }
- return &pdrs, nil
- }
- // PgDefaultACLByOid retrieves a row from 'pg_catalog.pg_default_acl' as a PgDefaultACL.
- //
- // Generated from index 'pg_default_acl_oid_index'.
- func PgDefaultACLByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgDefaultACL, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, defaclrole, defaclnamespace, defaclobjtype, defaclacl ` +
- `FROM pg_catalog.pg_default_acl ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pda := PgDefaultACL{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pda.Tableoid, &pda.Cmax, &pda.Xmax, &pda.Cmin, &pda.Xmin, &pda.Ctid, &pda.Oid, &pda.Defaclrole, &pda.Defaclnamespace, &pda.Defaclobjtype, &pda.Defaclacl); err != nil {
- return nil, logerror(err)
- }
- return &pda, nil
- }
- // PgDefaultACLByDefaclroleDefaclnamespaceDefaclobjtype retrieves a row from 'pg_catalog.pg_default_acl' as a PgDefaultACL.
- //
- // Generated from index 'pg_default_acl_role_nsp_obj_index'.
- func PgDefaultACLByDefaclroleDefaclnamespaceDefaclobjtype(ctx context.Context, db DB, defaclrole, defaclnamespace pgtypes.Oid, defaclobjtype pgtypes.Char) (*PgDefaultACL, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, defaclrole, defaclnamespace, defaclobjtype, defaclacl ` +
- `FROM pg_catalog.pg_default_acl ` +
- `WHERE defaclrole = $1 AND defaclnamespace = $2 AND defaclobjtype = $3`
- // run
- logf(sqlstr, defaclrole, defaclnamespace, defaclobjtype)
- pda := PgDefaultACL{}
- if err := db.QueryRowContext(ctx, sqlstr, defaclrole, defaclnamespace, defaclobjtype).Scan(&pda.Tableoid, &pda.Cmax, &pda.Xmax, &pda.Cmin, &pda.Xmin, &pda.Ctid, &pda.Oid, &pda.Defaclrole, &pda.Defaclnamespace, &pda.Defaclobjtype, &pda.Defaclacl); err != nil {
- return nil, logerror(err)
- }
- return &pda, nil
- }
- // PgDependByClassidObjidObjsubid retrieves a row from 'pg_catalog.pg_depend' as a PgDepend.
- //
- // Generated from index 'pg_depend_depender_index'.
- func PgDependByClassidObjidObjsubid(ctx context.Context, db DB, classid, objid pgtypes.Oid, objsubid int) ([]*PgDepend, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype ` +
- `FROM pg_catalog.pg_depend ` +
- `WHERE classid = $1 AND objid = $2 AND objsubid = $3`
- // run
- logf(sqlstr, classid, objid, objsubid)
- rows, err := db.QueryContext(ctx, sqlstr, classid, objid, objsubid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgDepend
- for rows.Next() {
- pd := PgDepend{}
- // scan
- if err := rows.Scan(&pd.Tableoid, &pd.Cmax, &pd.Xmax, &pd.Cmin, &pd.Xmin, &pd.Ctid, &pd.Classid, &pd.Objid, &pd.Objsubid, &pd.Refclassid, &pd.Refobjid, &pd.Refobjsubid, &pd.Deptype); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pd)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgDependByRefclassidRefobjidRefobjsubid retrieves a row from 'pg_catalog.pg_depend' as a PgDepend.
- //
- // Generated from index 'pg_depend_reference_index'.
- func PgDependByRefclassidRefobjidRefobjsubid(ctx context.Context, db DB, refclassid, refobjid pgtypes.Oid, refobjsubid int) ([]*PgDepend, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype ` +
- `FROM pg_catalog.pg_depend ` +
- `WHERE refclassid = $1 AND refobjid = $2 AND refobjsubid = $3`
- // run
- logf(sqlstr, refclassid, refobjid, refobjsubid)
- rows, err := db.QueryContext(ctx, sqlstr, refclassid, refobjid, refobjsubid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgDepend
- for rows.Next() {
- pd := PgDepend{}
- // scan
- if err := rows.Scan(&pd.Tableoid, &pd.Cmax, &pd.Xmax, &pd.Cmin, &pd.Xmin, &pd.Ctid, &pd.Classid, &pd.Objid, &pd.Objsubid, &pd.Refclassid, &pd.Refobjid, &pd.Refobjsubid, &pd.Deptype); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pd)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgDescriptionByObjoidClassoidObjsubid retrieves a row from 'pg_catalog.pg_description' as a PgDescription.
- //
- // Generated from index 'pg_description_o_c_o_index'.
- func PgDescriptionByObjoidClassoidObjsubid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int) (*PgDescription, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, description ` +
- `FROM pg_catalog.pg_description ` +
- `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3`
- // run
- logf(sqlstr, objoid, classoid, objsubid)
- pd := PgDescription{}
- if err := db.QueryRowContext(ctx, sqlstr, objoid, classoid, objsubid).Scan(&pd.Tableoid, &pd.Cmax, &pd.Xmax, &pd.Cmin, &pd.Xmin, &pd.Ctid, &pd.Objoid, &pd.Classoid, &pd.Objsubid, &pd.Description); err != nil {
- return nil, logerror(err)
- }
- return &pd, nil
- }
- // PgEnumByOid retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
- //
- // Generated from index 'pg_enum_oid_index'.
- func PgEnumByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgEnum, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
- `FROM pg_catalog.pg_enum ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pe := PgEnum{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pe.Tableoid, &pe.Cmax, &pe.Xmax, &pe.Cmin, &pe.Xmin, &pe.Ctid, &pe.Oid, &pe.Enumtypid, &pe.Enumsortorder, &pe.Enumlabel); err != nil {
- return nil, logerror(err)
- }
- return &pe, nil
- }
- // PgEnumByEnumtypidEnumlabel retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
- //
- // Generated from index 'pg_enum_typid_label_index'.
- func PgEnumByEnumtypidEnumlabel(ctx context.Context, db DB, enumtypid pgtypes.Oid, enumlabel string) (*PgEnum, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
- `FROM pg_catalog.pg_enum ` +
- `WHERE enumtypid = $1 AND enumlabel = $2`
- // run
- logf(sqlstr, enumtypid, enumlabel)
- pe := PgEnum{}
- if err := db.QueryRowContext(ctx, sqlstr, enumtypid, enumlabel).Scan(&pe.Tableoid, &pe.Cmax, &pe.Xmax, &pe.Cmin, &pe.Xmin, &pe.Ctid, &pe.Oid, &pe.Enumtypid, &pe.Enumsortorder, &pe.Enumlabel); err != nil {
- return nil, logerror(err)
- }
- return &pe, nil
- }
- // PgEnumByEnumtypidEnumsortorder retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
- //
- // Generated from index 'pg_enum_typid_sortorder_index'.
- func PgEnumByEnumtypidEnumsortorder(ctx context.Context, db DB, enumtypid pgtypes.Oid, enumsortorder float32) (*PgEnum, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
- `FROM pg_catalog.pg_enum ` +
- `WHERE enumtypid = $1 AND enumsortorder = $2`
- // run
- logf(sqlstr, enumtypid, enumsortorder)
- pe := PgEnum{}
- if err := db.QueryRowContext(ctx, sqlstr, enumtypid, enumsortorder).Scan(&pe.Tableoid, &pe.Cmax, &pe.Xmax, &pe.Cmin, &pe.Xmin, &pe.Ctid, &pe.Oid, &pe.Enumtypid, &pe.Enumsortorder, &pe.Enumlabel); err != nil {
- return nil, logerror(err)
- }
- return &pe, nil
- }
- // PgEventTriggerByEvtname retrieves a row from 'pg_catalog.pg_event_trigger' as a PgEventTrigger.
- //
- // Generated from index 'pg_event_trigger_evtname_index'.
- func PgEventTriggerByEvtname(ctx context.Context, db DB, evtname string) (*PgEventTrigger, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, evtname, evtevent, evtowner, evtfoid, evtenabled, evttags ` +
- `FROM pg_catalog.pg_event_trigger ` +
- `WHERE evtname = $1`
- // run
- logf(sqlstr, evtname)
- pet := PgEventTrigger{}
- if err := db.QueryRowContext(ctx, sqlstr, evtname).Scan(&pet.Tableoid, &pet.Cmax, &pet.Xmax, &pet.Cmin, &pet.Xmin, &pet.Ctid, &pet.Oid, &pet.Evtname, &pet.Evtevent, &pet.Evtowner, &pet.Evtfoid, &pet.Evtenabled, &pet.Evttags); err != nil {
- return nil, logerror(err)
- }
- return &pet, nil
- }
- // PgEventTriggerByOid retrieves a row from 'pg_catalog.pg_event_trigger' as a PgEventTrigger.
- //
- // Generated from index 'pg_event_trigger_oid_index'.
- func PgEventTriggerByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgEventTrigger, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, evtname, evtevent, evtowner, evtfoid, evtenabled, evttags ` +
- `FROM pg_catalog.pg_event_trigger ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pet := PgEventTrigger{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pet.Tableoid, &pet.Cmax, &pet.Xmax, &pet.Cmin, &pet.Xmin, &pet.Ctid, &pet.Oid, &pet.Evtname, &pet.Evtevent, &pet.Evtowner, &pet.Evtfoid, &pet.Evtenabled, &pet.Evttags); err != nil {
- return nil, logerror(err)
- }
- return &pet, nil
- }
- // PgExtensionByExtname retrieves a row from 'pg_catalog.pg_extension' as a PgExtension.
- //
- // Generated from index 'pg_extension_name_index'.
- func PgExtensionByExtname(ctx context.Context, db DB, extname string) (*PgExtension, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition ` +
- `FROM pg_catalog.pg_extension ` +
- `WHERE extname = $1`
- // run
- logf(sqlstr, extname)
- pe := PgExtension{}
- if err := db.QueryRowContext(ctx, sqlstr, extname).Scan(&pe.Tableoid, &pe.Cmax, &pe.Xmax, &pe.Cmin, &pe.Xmin, &pe.Ctid, &pe.Oid, &pe.Extname, &pe.Extowner, &pe.Extnamespace, &pe.Extrelocatable, &pe.Extversion, &pe.Extconfig, &pe.Extcondition); err != nil {
- return nil, logerror(err)
- }
- return &pe, nil
- }
- // PgExtensionByOid retrieves a row from 'pg_catalog.pg_extension' as a PgExtension.
- //
- // Generated from index 'pg_extension_oid_index'.
- func PgExtensionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgExtension, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition ` +
- `FROM pg_catalog.pg_extension ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pe := PgExtension{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pe.Tableoid, &pe.Cmax, &pe.Xmax, &pe.Cmin, &pe.Xmin, &pe.Ctid, &pe.Oid, &pe.Extname, &pe.Extowner, &pe.Extnamespace, &pe.Extrelocatable, &pe.Extversion, &pe.Extconfig, &pe.Extcondition); err != nil {
- return nil, logerror(err)
- }
- return &pe, nil
- }
- // PgForeignDataWrapperByFdwname retrieves a row from 'pg_catalog.pg_foreign_data_wrapper' as a PgForeignDataWrapper.
- //
- // Generated from index 'pg_foreign_data_wrapper_name_index'.
- func PgForeignDataWrapperByFdwname(ctx context.Context, db DB, fdwname string) (*PgForeignDataWrapper, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, fdwname, fdwowner, fdwhandler, fdwvalidator, fdwacl, fdwoptions ` +
- `FROM pg_catalog.pg_foreign_data_wrapper ` +
- `WHERE fdwname = $1`
- // run
- logf(sqlstr, fdwname)
- pfdw := PgForeignDataWrapper{}
- if err := db.QueryRowContext(ctx, sqlstr, fdwname).Scan(&pfdw.Tableoid, &pfdw.Cmax, &pfdw.Xmax, &pfdw.Cmin, &pfdw.Xmin, &pfdw.Ctid, &pfdw.Oid, &pfdw.Fdwname, &pfdw.Fdwowner, &pfdw.Fdwhandler, &pfdw.Fdwvalidator, &pfdw.Fdwacl, &pfdw.Fdwoptions); err != nil {
- return nil, logerror(err)
- }
- return &pfdw, nil
- }
- // PgForeignDataWrapperByOid retrieves a row from 'pg_catalog.pg_foreign_data_wrapper' as a PgForeignDataWrapper.
- //
- // Generated from index 'pg_foreign_data_wrapper_oid_index'.
- func PgForeignDataWrapperByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgForeignDataWrapper, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, fdwname, fdwowner, fdwhandler, fdwvalidator, fdwacl, fdwoptions ` +
- `FROM pg_catalog.pg_foreign_data_wrapper ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pfdw := PgForeignDataWrapper{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pfdw.Tableoid, &pfdw.Cmax, &pfdw.Xmax, &pfdw.Cmin, &pfdw.Xmin, &pfdw.Ctid, &pfdw.Oid, &pfdw.Fdwname, &pfdw.Fdwowner, &pfdw.Fdwhandler, &pfdw.Fdwvalidator, &pfdw.Fdwacl, &pfdw.Fdwoptions); err != nil {
- return nil, logerror(err)
- }
- return &pfdw, nil
- }
- // PgForeignServerBySrvname retrieves a row from 'pg_catalog.pg_foreign_server' as a PgForeignServer.
- //
- // Generated from index 'pg_foreign_server_name_index'.
- func PgForeignServerBySrvname(ctx context.Context, db DB, srvname string) (*PgForeignServer, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, srvname, srvowner, srvfdw, srvtype, srvversion, srvacl, srvoptions ` +
- `FROM pg_catalog.pg_foreign_server ` +
- `WHERE srvname = $1`
- // run
- logf(sqlstr, srvname)
- pfs := PgForeignServer{}
- if err := db.QueryRowContext(ctx, sqlstr, srvname).Scan(&pfs.Tableoid, &pfs.Cmax, &pfs.Xmax, &pfs.Cmin, &pfs.Xmin, &pfs.Ctid, &pfs.Oid, &pfs.Srvname, &pfs.Srvowner, &pfs.Srvfdw, &pfs.Srvtype, &pfs.Srvversion, &pfs.Srvacl, &pfs.Srvoptions); err != nil {
- return nil, logerror(err)
- }
- return &pfs, nil
- }
- // PgForeignServerByOid retrieves a row from 'pg_catalog.pg_foreign_server' as a PgForeignServer.
- //
- // Generated from index 'pg_foreign_server_oid_index'.
- func PgForeignServerByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgForeignServer, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, srvname, srvowner, srvfdw, srvtype, srvversion, srvacl, srvoptions ` +
- `FROM pg_catalog.pg_foreign_server ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pfs := PgForeignServer{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pfs.Tableoid, &pfs.Cmax, &pfs.Xmax, &pfs.Cmin, &pfs.Xmin, &pfs.Ctid, &pfs.Oid, &pfs.Srvname, &pfs.Srvowner, &pfs.Srvfdw, &pfs.Srvtype, &pfs.Srvversion, &pfs.Srvacl, &pfs.Srvoptions); err != nil {
- return nil, logerror(err)
- }
- return &pfs, nil
- }
- // PgForeignTableByFtrelid retrieves a row from 'pg_catalog.pg_foreign_table' as a PgForeignTable.
- //
- // Generated from index 'pg_foreign_table_relid_index'.
- func PgForeignTableByFtrelid(ctx context.Context, db DB, ftrelid pgtypes.Oid) (*PgForeignTable, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, ftrelid, ftserver, ftoptions ` +
- `FROM pg_catalog.pg_foreign_table ` +
- `WHERE ftrelid = $1`
- // run
- logf(sqlstr, ftrelid)
- pft := PgForeignTable{}
- if err := db.QueryRowContext(ctx, sqlstr, ftrelid).Scan(&pft.Tableoid, &pft.Cmax, &pft.Xmax, &pft.Cmin, &pft.Xmin, &pft.Ctid, &pft.Ftrelid, &pft.Ftserver, &pft.Ftoptions); err != nil {
- return nil, logerror(err)
- }
- return &pft, nil
- }
- // PgIndexByIndexrelid retrieves a row from 'pg_catalog.pg_index' as a PgIndex.
- //
- // Generated from index 'pg_index_indexrelid_index'.
- func PgIndexByIndexrelid(ctx context.Context, db DB, indexrelid pgtypes.Oid) (*PgIndex, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, indexrelid, indrelid, indnatts, indnkeyatts, indisunique, indisprimary, indisexclusion, indimmediate, indisclustered, indisvalid, indcheckxmin, indisready, indislive, indisreplident, indkey, indcollation, indclass, indoption, indexprs, indpred ` +
- `FROM pg_catalog.pg_index ` +
- `WHERE indexrelid = $1`
- // run
- logf(sqlstr, indexrelid)
- pi := PgIndex{}
- if err := db.QueryRowContext(ctx, sqlstr, indexrelid).Scan(&pi.Tableoid, &pi.Cmax, &pi.Xmax, &pi.Cmin, &pi.Xmin, &pi.Ctid, &pi.Indexrelid, &pi.Indrelid, &pi.Indnatts, &pi.Indnkeyatts, &pi.Indisunique, &pi.Indisprimary, &pi.Indisexclusion, &pi.Indimmediate, &pi.Indisclustered, &pi.Indisvalid, &pi.Indcheckxmin, &pi.Indisready, &pi.Indislive, &pi.Indisreplident, &pi.Indkey, &pi.Indcollation, &pi.Indclass, &pi.Indoption, &pi.Indexprs, &pi.Indpred); err != nil {
- return nil, logerror(err)
- }
- return &pi, nil
- }
- // PgIndexByIndrelid retrieves a row from 'pg_catalog.pg_index' as a PgIndex.
- //
- // Generated from index 'pg_index_indrelid_index'.
- func PgIndexByIndrelid(ctx context.Context, db DB, indrelid pgtypes.Oid) ([]*PgIndex, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, indexrelid, indrelid, indnatts, indnkeyatts, indisunique, indisprimary, indisexclusion, indimmediate, indisclustered, indisvalid, indcheckxmin, indisready, indislive, indisreplident, indkey, indcollation, indclass, indoption, indexprs, indpred ` +
- `FROM pg_catalog.pg_index ` +
- `WHERE indrelid = $1`
- // run
- logf(sqlstr, indrelid)
- rows, err := db.QueryContext(ctx, sqlstr, indrelid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgIndex
- for rows.Next() {
- pi := PgIndex{}
- // scan
- if err := rows.Scan(&pi.Tableoid, &pi.Cmax, &pi.Xmax, &pi.Cmin, &pi.Xmin, &pi.Ctid, &pi.Indexrelid, &pi.Indrelid, &pi.Indnatts, &pi.Indnkeyatts, &pi.Indisunique, &pi.Indisprimary, &pi.Indisexclusion, &pi.Indimmediate, &pi.Indisclustered, &pi.Indisvalid, &pi.Indcheckxmin, &pi.Indisready, &pi.Indislive, &pi.Indisreplident, &pi.Indkey, &pi.Indcollation, &pi.Indclass, &pi.Indoption, &pi.Indexprs, &pi.Indpred); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pi)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgInheritsByInhparent retrieves a row from 'pg_catalog.pg_inherits' as a PgInherit.
- //
- // Generated from index 'pg_inherits_parent_index'.
- func PgInheritsByInhparent(ctx context.Context, db DB, inhparent pgtypes.Oid) ([]*PgInherit, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, inhrelid, inhparent, inhseqno ` +
- `FROM pg_catalog.pg_inherits ` +
- `WHERE inhparent = $1`
- // run
- logf(sqlstr, inhparent)
- rows, err := db.QueryContext(ctx, sqlstr, inhparent)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgInherit
- for rows.Next() {
- pi := PgInherit{}
- // scan
- if err := rows.Scan(&pi.Tableoid, &pi.Cmax, &pi.Xmax, &pi.Cmin, &pi.Xmin, &pi.Ctid, &pi.Inhrelid, &pi.Inhparent, &pi.Inhseqno); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pi)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgInheritByInhrelidInhseqno retrieves a row from 'pg_catalog.pg_inherits' as a PgInherit.
- //
- // Generated from index 'pg_inherits_relid_seqno_index'.
- func PgInheritByInhrelidInhseqno(ctx context.Context, db DB, inhrelid pgtypes.Oid, inhseqno int) (*PgInherit, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, inhrelid, inhparent, inhseqno ` +
- `FROM pg_catalog.pg_inherits ` +
- `WHERE inhrelid = $1 AND inhseqno = $2`
- // run
- logf(sqlstr, inhrelid, inhseqno)
- pi := PgInherit{}
- if err := db.QueryRowContext(ctx, sqlstr, inhrelid, inhseqno).Scan(&pi.Tableoid, &pi.Cmax, &pi.Xmax, &pi.Cmin, &pi.Xmin, &pi.Ctid, &pi.Inhrelid, &pi.Inhparent, &pi.Inhseqno); err != nil {
- return nil, logerror(err)
- }
- return &pi, nil
- }
- // PgInitPrivByObjoidClassoidObjsubid retrieves a row from 'pg_catalog.pg_init_privs' as a PgInitPriv.
- //
- // Generated from index 'pg_init_privs_o_c_o_index'.
- func PgInitPrivByObjoidClassoidObjsubid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int) (*PgInitPriv, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, privtype, initprivs ` +
- `FROM pg_catalog.pg_init_privs ` +
- `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3`
- // run
- logf(sqlstr, objoid, classoid, objsubid)
- pip := PgInitPriv{}
- if err := db.QueryRowContext(ctx, sqlstr, objoid, classoid, objsubid).Scan(&pip.Tableoid, &pip.Cmax, &pip.Xmax, &pip.Cmin, &pip.Xmin, &pip.Ctid, &pip.Objoid, &pip.Classoid, &pip.Objsubid, &pip.Privtype, &pip.Initprivs); err != nil {
- return nil, logerror(err)
- }
- return &pip, nil
- }
- // PgLanguageByLanname retrieves a row from 'pg_catalog.pg_language' as a PgLanguage.
- //
- // Generated from index 'pg_language_name_index'.
- func PgLanguageByLanname(ctx context.Context, db DB, lanname string) (*PgLanguage, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lanname, lanowner, lanispl, lanpltrusted, lanplcallfoid, laninline, lanvalidator, lanacl ` +
- `FROM pg_catalog.pg_language ` +
- `WHERE lanname = $1`
- // run
- logf(sqlstr, lanname)
- pl := PgLanguage{}
- if err := db.QueryRowContext(ctx, sqlstr, lanname).Scan(&pl.Tableoid, &pl.Cmax, &pl.Xmax, &pl.Cmin, &pl.Xmin, &pl.Ctid, &pl.Oid, &pl.Lanname, &pl.Lanowner, &pl.Lanispl, &pl.Lanpltrusted, &pl.Lanplcallfoid, &pl.Laninline, &pl.Lanvalidator, &pl.Lanacl); err != nil {
- return nil, logerror(err)
- }
- return &pl, nil
- }
- // PgLanguageByOid retrieves a row from 'pg_catalog.pg_language' as a PgLanguage.
- //
- // Generated from index 'pg_language_oid_index'.
- func PgLanguageByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgLanguage, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lanname, lanowner, lanispl, lanpltrusted, lanplcallfoid, laninline, lanvalidator, lanacl ` +
- `FROM pg_catalog.pg_language ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pl := PgLanguage{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pl.Tableoid, &pl.Cmax, &pl.Xmax, &pl.Cmin, &pl.Xmin, &pl.Ctid, &pl.Oid, &pl.Lanname, &pl.Lanowner, &pl.Lanispl, &pl.Lanpltrusted, &pl.Lanplcallfoid, &pl.Laninline, &pl.Lanvalidator, &pl.Lanacl); err != nil {
- return nil, logerror(err)
- }
- return &pl, nil
- }
- // PgLargeobjectByLoidPageno retrieves a row from 'pg_catalog.pg_largeobject' as a PgLargeobject.
- //
- // Generated from index 'pg_largeobject_loid_pn_index'.
- func PgLargeobjectByLoidPageno(ctx context.Context, db DB, loid pgtypes.Oid, pageno int) (*PgLargeobject, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, loid, pageno, data ` +
- `FROM pg_catalog.pg_largeobject ` +
- `WHERE loid = $1 AND pageno = $2`
- // run
- logf(sqlstr, loid, pageno)
- pl := PgLargeobject{}
- if err := db.QueryRowContext(ctx, sqlstr, loid, pageno).Scan(&pl.Tableoid, &pl.Cmax, &pl.Xmax, &pl.Cmin, &pl.Xmin, &pl.Ctid, &pl.Loid, &pl.Pageno, &pl.Data); err != nil {
- return nil, logerror(err)
- }
- return &pl, nil
- }
- // PgLargeobjectMetadatumByOid retrieves a row from 'pg_catalog.pg_largeobject_metadata' as a PgLargeobjectMetadatum.
- //
- // Generated from index 'pg_largeobject_metadata_oid_index'.
- func PgLargeobjectMetadatumByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgLargeobjectMetadatum, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lomowner, lomacl ` +
- `FROM pg_catalog.pg_largeobject_metadata ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- plm := PgLargeobjectMetadatum{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&plm.Tableoid, &plm.Cmax, &plm.Xmax, &plm.Cmin, &plm.Xmin, &plm.Ctid, &plm.Oid, &plm.Lomowner, &plm.Lomacl); err != nil {
- return nil, logerror(err)
- }
- return &plm, nil
- }
- // PgNamespaceByNspname retrieves a row from 'pg_catalog.pg_namespace' as a PgNamespace.
- //
- // Generated from index 'pg_namespace_nspname_index'.
- func PgNamespaceByNspname(ctx context.Context, db DB, nspname string) (*PgNamespace, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, nspname, nspowner, nspacl ` +
- `FROM pg_catalog.pg_namespace ` +
- `WHERE nspname = $1`
- // run
- logf(sqlstr, nspname)
- pn := PgNamespace{}
- if err := db.QueryRowContext(ctx, sqlstr, nspname).Scan(&pn.Tableoid, &pn.Cmax, &pn.Xmax, &pn.Cmin, &pn.Xmin, &pn.Ctid, &pn.Oid, &pn.Nspname, &pn.Nspowner, &pn.Nspacl); err != nil {
- return nil, logerror(err)
- }
- return &pn, nil
- }
- // PgNamespaceByOid retrieves a row from 'pg_catalog.pg_namespace' as a PgNamespace.
- //
- // Generated from index 'pg_namespace_oid_index'.
- func PgNamespaceByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgNamespace, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, nspname, nspowner, nspacl ` +
- `FROM pg_catalog.pg_namespace ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pn := PgNamespace{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pn.Tableoid, &pn.Cmax, &pn.Xmax, &pn.Cmin, &pn.Xmin, &pn.Ctid, &pn.Oid, &pn.Nspname, &pn.Nspowner, &pn.Nspacl); err != nil {
- return nil, logerror(err)
- }
- return &pn, nil
- }
- // PgOpclassByOpcmethodOpcnameOpcnamespace retrieves a row from 'pg_catalog.pg_opclass' as a PgOpclass.
- //
- // Generated from index 'pg_opclass_am_name_nsp_index'.
- func PgOpclassByOpcmethodOpcnameOpcnamespace(ctx context.Context, db DB, opcmethod pgtypes.Oid, opcname string, opcnamespace pgtypes.Oid) (*PgOpclass, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opcmethod, opcname, opcnamespace, opcowner, opcfamily, opcintype, opcdefault, opckeytype ` +
- `FROM pg_catalog.pg_opclass ` +
- `WHERE opcmethod = $1 AND opcname = $2 AND opcnamespace = $3`
- // run
- logf(sqlstr, opcmethod, opcname, opcnamespace)
- po := PgOpclass{}
- if err := db.QueryRowContext(ctx, sqlstr, opcmethod, opcname, opcnamespace).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Opcmethod, &po.Opcname, &po.Opcnamespace, &po.Opcowner, &po.Opcfamily, &po.Opcintype, &po.Opcdefault, &po.Opckeytype); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgOpclassByOid retrieves a row from 'pg_catalog.pg_opclass' as a PgOpclass.
- //
- // Generated from index 'pg_opclass_oid_index'.
- func PgOpclassByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOpclass, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opcmethod, opcname, opcnamespace, opcowner, opcfamily, opcintype, opcdefault, opckeytype ` +
- `FROM pg_catalog.pg_opclass ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- po := PgOpclass{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Opcmethod, &po.Opcname, &po.Opcnamespace, &po.Opcowner, &po.Opcfamily, &po.Opcintype, &po.Opcdefault, &po.Opckeytype); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgOperatorByOid retrieves a row from 'pg_catalog.pg_operator' as a PgOperator.
- //
- // Generated from index 'pg_operator_oid_index'.
- func PgOperatorByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOperator, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, oprname, oprnamespace, oprowner, oprkind, oprcanmerge, oprcanhash, oprleft, oprright, oprresult, oprcom, oprnegate, oprcode, oprrest, oprjoin ` +
- `FROM pg_catalog.pg_operator ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- po := PgOperator{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Oprname, &po.Oprnamespace, &po.Oprowner, &po.Oprkind, &po.Oprcanmerge, &po.Oprcanhash, &po.Oprleft, &po.Oprright, &po.Oprresult, &po.Oprcom, &po.Oprnegate, &po.Oprcode, &po.Oprrest, &po.Oprjoin); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgOperatorByOprnameOprleftOprrightOprnamespace retrieves a row from 'pg_catalog.pg_operator' as a PgOperator.
- //
- // Generated from index 'pg_operator_oprname_l_r_n_index'.
- func PgOperatorByOprnameOprleftOprrightOprnamespace(ctx context.Context, db DB, oprname string, oprleft, oprright, oprnamespace pgtypes.Oid) (*PgOperator, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, oprname, oprnamespace, oprowner, oprkind, oprcanmerge, oprcanhash, oprleft, oprright, oprresult, oprcom, oprnegate, oprcode, oprrest, oprjoin ` +
- `FROM pg_catalog.pg_operator ` +
- `WHERE oprname = $1 AND oprleft = $2 AND oprright = $3 AND oprnamespace = $4`
- // run
- logf(sqlstr, oprname, oprleft, oprright, oprnamespace)
- po := PgOperator{}
- if err := db.QueryRowContext(ctx, sqlstr, oprname, oprleft, oprright, oprnamespace).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Oprname, &po.Oprnamespace, &po.Oprowner, &po.Oprkind, &po.Oprcanmerge, &po.Oprcanhash, &po.Oprleft, &po.Oprright, &po.Oprresult, &po.Oprcom, &po.Oprnegate, &po.Oprcode, &po.Oprrest, &po.Oprjoin); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgOpfamilyByOpfmethodOpfnameOpfnamespace retrieves a row from 'pg_catalog.pg_opfamily' as a PgOpfamily.
- //
- // Generated from index 'pg_opfamily_am_name_nsp_index'.
- func PgOpfamilyByOpfmethodOpfnameOpfnamespace(ctx context.Context, db DB, opfmethod pgtypes.Oid, opfname string, opfnamespace pgtypes.Oid) (*PgOpfamily, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opfmethod, opfname, opfnamespace, opfowner ` +
- `FROM pg_catalog.pg_opfamily ` +
- `WHERE opfmethod = $1 AND opfname = $2 AND opfnamespace = $3`
- // run
- logf(sqlstr, opfmethod, opfname, opfnamespace)
- po := PgOpfamily{}
- if err := db.QueryRowContext(ctx, sqlstr, opfmethod, opfname, opfnamespace).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Opfmethod, &po.Opfname, &po.Opfnamespace, &po.Opfowner); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgOpfamilyByOid retrieves a row from 'pg_catalog.pg_opfamily' as a PgOpfamily.
- //
- // Generated from index 'pg_opfamily_oid_index'.
- func PgOpfamilyByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOpfamily, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opfmethod, opfname, opfnamespace, opfowner ` +
- `FROM pg_catalog.pg_opfamily ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- po := PgOpfamily{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&po.Tableoid, &po.Cmax, &po.Xmax, &po.Cmin, &po.Xmin, &po.Ctid, &po.Oid, &po.Opfmethod, &po.Opfname, &po.Opfnamespace, &po.Opfowner); err != nil {
- return nil, logerror(err)
- }
- return &po, nil
- }
- // PgPartitionedTableByPartrelid retrieves a row from 'pg_catalog.pg_partitioned_table' as a PgPartitionedTable.
- //
- // Generated from index 'pg_partitioned_table_partrelid_index'.
- func PgPartitionedTableByPartrelid(ctx context.Context, db DB, partrelid pgtypes.Oid) (*PgPartitionedTable, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, partrelid, partstrat, partnatts, partdefid, partattrs, partclass, partcollation, partexprs ` +
- `FROM pg_catalog.pg_partitioned_table ` +
- `WHERE partrelid = $1`
- // run
- logf(sqlstr, partrelid)
- ppt := PgPartitionedTable{}
- if err := db.QueryRowContext(ctx, sqlstr, partrelid).Scan(&ppt.Tableoid, &ppt.Cmax, &ppt.Xmax, &ppt.Cmin, &ppt.Xmin, &ppt.Ctid, &ppt.Partrelid, &ppt.Partstrat, &ppt.Partnatts, &ppt.Partdefid, &ppt.Partattrs, &ppt.Partclass, &ppt.Partcollation, &ppt.Partexprs); err != nil {
- return nil, logerror(err)
- }
- return &ppt, nil
- }
- // PgPolicyByOid retrieves a row from 'pg_catalog.pg_policy' as a PgPolicy.
- //
- // Generated from index 'pg_policy_oid_index'.
- func PgPolicyByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPolicy, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, polname, polrelid, polcmd, polpermissive, polroles, polqual, polwithcheck ` +
- `FROM pg_catalog.pg_policy ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pp := PgPolicy{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Polname, &pp.Polrelid, &pp.Polcmd, &pp.Polpermissive, &pp.Polroles, &pp.Polqual, &pp.Polwithcheck); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgPolicyByPolrelidPolname retrieves a row from 'pg_catalog.pg_policy' as a PgPolicy.
- //
- // Generated from index 'pg_policy_polrelid_polname_index'.
- func PgPolicyByPolrelidPolname(ctx context.Context, db DB, polrelid pgtypes.Oid, polname string) (*PgPolicy, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, polname, polrelid, polcmd, polpermissive, polroles, polqual, polwithcheck ` +
- `FROM pg_catalog.pg_policy ` +
- `WHERE polrelid = $1 AND polname = $2`
- // run
- logf(sqlstr, polrelid, polname)
- pp := PgPolicy{}
- if err := db.QueryRowContext(ctx, sqlstr, polrelid, polname).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Polname, &pp.Polrelid, &pp.Polcmd, &pp.Polpermissive, &pp.Polroles, &pp.Polqual, &pp.Polwithcheck); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgProcByOid retrieves a row from 'pg_catalog.pg_proc' as a PgProc.
- //
- // Generated from index 'pg_proc_oid_index'.
- func PgProcByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgProc, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, proname, pronamespace, proowner, prolang, procost, prorows, provariadic, prosupport, prokind, prosecdef, proleakproof, proisstrict, proretset, provolatile, proparallel, pronargs, pronargdefaults, prorettype, proargtypes, proallargtypes, proargmodes, proargnames, proargdefaults, protrftypes, prosrc, probin, proconfig, proacl ` +
- `FROM pg_catalog.pg_proc ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pp := PgProc{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Proname, &pp.Pronamespace, &pp.Proowner, &pp.Prolang, &pp.Procost, &pp.Prorows, &pp.Provariadic, &pp.Prosupport, &pp.Prokind, &pp.Prosecdef, &pp.Proleakproof, &pp.Proisstrict, &pp.Proretset, &pp.Provolatile, &pp.Proparallel, &pp.Pronargs, &pp.Pronargdefaults, &pp.Prorettype, &pp.Proargtypes, &pp.Proallargtypes, &pp.Proargmodes, &pp.Proargnames, &pp.Proargdefaults, &pp.Protrftypes, &pp.Prosrc, &pp.Probin, &pp.Proconfig, &pp.Proacl); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgProcByPronameProargtypesPronamespace retrieves a row from 'pg_catalog.pg_proc' as a PgProc.
- //
- // Generated from index 'pg_proc_proname_args_nsp_index'.
- func PgProcByPronameProargtypesPronamespace(ctx context.Context, db DB, proname string, proargtypes pgtypes.Oidvector, pronamespace pgtypes.Oid) (*PgProc, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, proname, pronamespace, proowner, prolang, procost, prorows, provariadic, prosupport, prokind, prosecdef, proleakproof, proisstrict, proretset, provolatile, proparallel, pronargs, pronargdefaults, prorettype, proargtypes, proallargtypes, proargmodes, proargnames, proargdefaults, protrftypes, prosrc, probin, proconfig, proacl ` +
- `FROM pg_catalog.pg_proc ` +
- `WHERE proname = $1 AND proargtypes = $2 AND pronamespace = $3`
- // run
- logf(sqlstr, proname, proargtypes, pronamespace)
- pp := PgProc{}
- if err := db.QueryRowContext(ctx, sqlstr, proname, proargtypes, pronamespace).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Proname, &pp.Pronamespace, &pp.Proowner, &pp.Prolang, &pp.Procost, &pp.Prorows, &pp.Provariadic, &pp.Prosupport, &pp.Prokind, &pp.Prosecdef, &pp.Proleakproof, &pp.Proisstrict, &pp.Proretset, &pp.Provolatile, &pp.Proparallel, &pp.Pronargs, &pp.Pronargdefaults, &pp.Prorettype, &pp.Proargtypes, &pp.Proallargtypes, &pp.Proargmodes, &pp.Proargnames, &pp.Proargdefaults, &pp.Protrftypes, &pp.Prosrc, &pp.Probin, &pp.Proconfig, &pp.Proacl); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgPublicationByOid retrieves a row from 'pg_catalog.pg_publication' as a PgPublication.
- //
- // Generated from index 'pg_publication_oid_index'.
- func PgPublicationByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPublication, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, pubname, pubowner, puballtables, pubinsert, pubupdate, pubdelete, pubtruncate, pubviaroot ` +
- `FROM pg_catalog.pg_publication ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pp := PgPublication{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Pubname, &pp.Pubowner, &pp.Puballtables, &pp.Pubinsert, &pp.Pubupdate, &pp.Pubdelete, &pp.Pubtruncate, &pp.Pubviaroot); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgPublicationByPubname retrieves a row from 'pg_catalog.pg_publication' as a PgPublication.
- //
- // Generated from index 'pg_publication_pubname_index'.
- func PgPublicationByPubname(ctx context.Context, db DB, pubname string) (*PgPublication, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, pubname, pubowner, puballtables, pubinsert, pubupdate, pubdelete, pubtruncate, pubviaroot ` +
- `FROM pg_catalog.pg_publication ` +
- `WHERE pubname = $1`
- // run
- logf(sqlstr, pubname)
- pp := PgPublication{}
- if err := db.QueryRowContext(ctx, sqlstr, pubname).Scan(&pp.Tableoid, &pp.Cmax, &pp.Xmax, &pp.Cmin, &pp.Xmin, &pp.Ctid, &pp.Oid, &pp.Pubname, &pp.Pubowner, &pp.Puballtables, &pp.Pubinsert, &pp.Pubupdate, &pp.Pubdelete, &pp.Pubtruncate, &pp.Pubviaroot); err != nil {
- return nil, logerror(err)
- }
- return &pp, nil
- }
- // PgPublicationRelByOid retrieves a row from 'pg_catalog.pg_publication_rel' as a PgPublicationRel.
- //
- // Generated from index 'pg_publication_rel_oid_index'.
- func PgPublicationRelByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPublicationRel, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, prpubid, prrelid ` +
- `FROM pg_catalog.pg_publication_rel ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- ppr := PgPublicationRel{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&ppr.Tableoid, &ppr.Cmax, &ppr.Xmax, &ppr.Cmin, &ppr.Xmin, &ppr.Ctid, &ppr.Oid, &ppr.Prpubid, &ppr.Prrelid); err != nil {
- return nil, logerror(err)
- }
- return &ppr, nil
- }
- // PgPublicationRelByPrrelidPrpubid retrieves a row from 'pg_catalog.pg_publication_rel' as a PgPublicationRel.
- //
- // Generated from index 'pg_publication_rel_prrelid_prpubid_index'.
- func PgPublicationRelByPrrelidPrpubid(ctx context.Context, db DB, prrelid, prpubid pgtypes.Oid) (*PgPublicationRel, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, prpubid, prrelid ` +
- `FROM pg_catalog.pg_publication_rel ` +
- `WHERE prrelid = $1 AND prpubid = $2`
- // run
- logf(sqlstr, prrelid, prpubid)
- ppr := PgPublicationRel{}
- if err := db.QueryRowContext(ctx, sqlstr, prrelid, prpubid).Scan(&ppr.Tableoid, &ppr.Cmax, &ppr.Xmax, &ppr.Cmin, &ppr.Xmin, &ppr.Ctid, &ppr.Oid, &ppr.Prpubid, &ppr.Prrelid); err != nil {
- return nil, logerror(err)
- }
- return &ppr, nil
- }
- // PgRangeByRngtypid retrieves a row from 'pg_catalog.pg_range' as a PgRange.
- //
- // Generated from index 'pg_range_rngtypid_index'.
- func PgRangeByRngtypid(ctx context.Context, db DB, rngtypid pgtypes.Oid) (*PgRange, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, rngtypid, rngsubtype, rngcollation, rngsubopc, rngcanonical, rngsubdiff ` +
- `FROM pg_catalog.pg_range ` +
- `WHERE rngtypid = $1`
- // run
- logf(sqlstr, rngtypid)
- pr := PgRange{}
- if err := db.QueryRowContext(ctx, sqlstr, rngtypid).Scan(&pr.Tableoid, &pr.Cmax, &pr.Xmax, &pr.Cmin, &pr.Xmin, &pr.Ctid, &pr.Rngtypid, &pr.Rngsubtype, &pr.Rngcollation, &pr.Rngsubopc, &pr.Rngcanonical, &pr.Rngsubdiff); err != nil {
- return nil, logerror(err)
- }
- return &pr, nil
- }
- // PgReplicationOriginByRoident retrieves a row from 'pg_catalog.pg_replication_origin' as a PgReplicationOrigin.
- //
- // Generated from index 'pg_replication_origin_roiident_index'.
- func PgReplicationOriginByRoident(ctx context.Context, db DB, roident pgtypes.Oid) (*PgReplicationOrigin, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, roident, roname ` +
- `FROM pg_catalog.pg_replication_origin ` +
- `WHERE roident = $1`
- // run
- logf(sqlstr, roident)
- pro := PgReplicationOrigin{}
- if err := db.QueryRowContext(ctx, sqlstr, roident).Scan(&pro.Tableoid, &pro.Cmax, &pro.Xmax, &pro.Cmin, &pro.Xmin, &pro.Ctid, &pro.Roident, &pro.Roname); err != nil {
- return nil, logerror(err)
- }
- return &pro, nil
- }
- // PgReplicationOriginByRoname retrieves a row from 'pg_catalog.pg_replication_origin' as a PgReplicationOrigin.
- //
- // Generated from index 'pg_replication_origin_roname_index'.
- func PgReplicationOriginByRoname(ctx context.Context, db DB, roname string) (*PgReplicationOrigin, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, roident, roname ` +
- `FROM pg_catalog.pg_replication_origin ` +
- `WHERE roname = $1`
- // run
- logf(sqlstr, roname)
- pro := PgReplicationOrigin{}
- if err := db.QueryRowContext(ctx, sqlstr, roname).Scan(&pro.Tableoid, &pro.Cmax, &pro.Xmax, &pro.Cmin, &pro.Xmin, &pro.Ctid, &pro.Roident, &pro.Roname); err != nil {
- return nil, logerror(err)
- }
- return &pro, nil
- }
- // PgRewriteByOid retrieves a row from 'pg_catalog.pg_rewrite' as a PgRewrite.
- //
- // Generated from index 'pg_rewrite_oid_index'.
- func PgRewriteByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgRewrite, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rulename, ev_class, ev_type, ev_enabled, is_instead, ev_qual, ev_action ` +
- `FROM pg_catalog.pg_rewrite ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pr := PgRewrite{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pr.Tableoid, &pr.Cmax, &pr.Xmax, &pr.Cmin, &pr.Xmin, &pr.Ctid, &pr.Oid, &pr.Rulename, &pr.EvClass, &pr.EvType, &pr.EvEnabled, &pr.IsInstead, &pr.EvQual, &pr.EvAction); err != nil {
- return nil, logerror(err)
- }
- return &pr, nil
- }
- // PgRewriteByEvClassRulename retrieves a row from 'pg_catalog.pg_rewrite' as a PgRewrite.
- //
- // Generated from index 'pg_rewrite_rel_rulename_index'.
- func PgRewriteByEvClassRulename(ctx context.Context, db DB, evClass pgtypes.Oid, rulename string) (*PgRewrite, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rulename, ev_class, ev_type, ev_enabled, is_instead, ev_qual, ev_action ` +
- `FROM pg_catalog.pg_rewrite ` +
- `WHERE ev_class = $1 AND rulename = $2`
- // run
- logf(sqlstr, evClass, rulename)
- pr := PgRewrite{}
- if err := db.QueryRowContext(ctx, sqlstr, evClass, rulename).Scan(&pr.Tableoid, &pr.Cmax, &pr.Xmax, &pr.Cmin, &pr.Xmin, &pr.Ctid, &pr.Oid, &pr.Rulename, &pr.EvClass, &pr.EvType, &pr.EvEnabled, &pr.IsInstead, &pr.EvQual, &pr.EvAction); err != nil {
- return nil, logerror(err)
- }
- return &pr, nil
- }
- // PgSeclabelByObjoidClassoidObjsubidProvider retrieves a row from 'pg_catalog.pg_seclabel' as a PgSeclabel.
- //
- // Generated from index 'pg_seclabel_object_index'.
- func PgSeclabelByObjoidClassoidObjsubidProvider(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int, provider string) (*PgSeclabel, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, provider, label ` +
- `FROM pg_catalog.pg_seclabel ` +
- `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3 AND provider = $4`
- // run
- logf(sqlstr, objoid, classoid, objsubid, provider)
- ps := PgSeclabel{}
- if err := db.QueryRowContext(ctx, sqlstr, objoid, classoid, objsubid, provider).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Objoid, &ps.Classoid, &ps.Objsubid, &ps.Provider, &ps.Label); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgSequenceBySeqrelid retrieves a row from 'pg_catalog.pg_sequence' as a PgSequence.
- //
- // Generated from index 'pg_sequence_seqrelid_index'.
- func PgSequenceBySeqrelid(ctx context.Context, db DB, seqrelid pgtypes.Oid) (*PgSequence, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, seqrelid, seqtypid, seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle ` +
- `FROM pg_catalog.pg_sequence ` +
- `WHERE seqrelid = $1`
- // run
- logf(sqlstr, seqrelid)
- ps := PgSequence{}
- if err := db.QueryRowContext(ctx, sqlstr, seqrelid).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Seqrelid, &ps.Seqtypid, &ps.Seqstart, &ps.Seqincrement, &ps.Seqmax, &ps.Seqmin, &ps.Seqcache, &ps.Seqcycle); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgShdependByDbidClassidObjidObjsubid retrieves a row from 'pg_catalog.pg_shdepend' as a PgShdepend.
- //
- // Generated from index 'pg_shdepend_depender_index'.
- func PgShdependByDbidClassidObjidObjsubid(ctx context.Context, db DB, dbid, classid, objid pgtypes.Oid, objsubid int) ([]*PgShdepend, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, dbid, classid, objid, objsubid, refclassid, refobjid, deptype ` +
- `FROM pg_catalog.pg_shdepend ` +
- `WHERE dbid = $1 AND classid = $2 AND objid = $3 AND objsubid = $4`
- // run
- logf(sqlstr, dbid, classid, objid, objsubid)
- rows, err := db.QueryContext(ctx, sqlstr, dbid, classid, objid, objsubid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgShdepend
- for rows.Next() {
- ps := PgShdepend{}
- // scan
- if err := rows.Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Dbid, &ps.Classid, &ps.Objid, &ps.Objsubid, &ps.Refclassid, &ps.Refobjid, &ps.Deptype); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &ps)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgShdependByRefclassidRefobjid retrieves a row from 'pg_catalog.pg_shdepend' as a PgShdepend.
- //
- // Generated from index 'pg_shdepend_reference_index'.
- func PgShdependByRefclassidRefobjid(ctx context.Context, db DB, refclassid, refobjid pgtypes.Oid) ([]*PgShdepend, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, dbid, classid, objid, objsubid, refclassid, refobjid, deptype ` +
- `FROM pg_catalog.pg_shdepend ` +
- `WHERE refclassid = $1 AND refobjid = $2`
- // run
- logf(sqlstr, refclassid, refobjid)
- rows, err := db.QueryContext(ctx, sqlstr, refclassid, refobjid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgShdepend
- for rows.Next() {
- ps := PgShdepend{}
- // scan
- if err := rows.Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Dbid, &ps.Classid, &ps.Objid, &ps.Objsubid, &ps.Refclassid, &ps.Refobjid, &ps.Deptype); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &ps)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgShdescriptionByObjoidClassoid retrieves a row from 'pg_catalog.pg_shdescription' as a PgShdescription.
- //
- // Generated from index 'pg_shdescription_o_c_index'.
- func PgShdescriptionByObjoidClassoid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid) (*PgShdescription, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, description ` +
- `FROM pg_catalog.pg_shdescription ` +
- `WHERE objoid = $1 AND classoid = $2`
- // run
- logf(sqlstr, objoid, classoid)
- ps := PgShdescription{}
- if err := db.QueryRowContext(ctx, sqlstr, objoid, classoid).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Objoid, &ps.Classoid, &ps.Description); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgShseclabelByObjoidClassoidProvider retrieves a row from 'pg_catalog.pg_shseclabel' as a PgShseclabel.
- //
- // Generated from index 'pg_shseclabel_object_index'.
- func PgShseclabelByObjoidClassoidProvider(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, provider string) (*PgShseclabel, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, provider, label ` +
- `FROM pg_catalog.pg_shseclabel ` +
- `WHERE objoid = $1 AND classoid = $2 AND provider = $3`
- // run
- logf(sqlstr, objoid, classoid, provider)
- ps := PgShseclabel{}
- if err := db.QueryRowContext(ctx, sqlstr, objoid, classoid, provider).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Objoid, &ps.Classoid, &ps.Provider, &ps.Label); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgStatisticByStarelidStaattnumStainherit retrieves a row from 'pg_catalog.pg_statistic' as a PgStatistic.
- //
- // Generated from index 'pg_statistic_relid_att_inh_index'.
- func PgStatisticByStarelidStaattnumStainherit(ctx context.Context, db DB, starelid pgtypes.Oid, staattnum int16, stainherit bool) (*PgStatistic, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, starelid, staattnum, stainherit, stanullfrac, stawidth, stadistinct, stakind1, stakind2, stakind3, stakind4, stakind5, staop1, staop2, staop3, staop4, staop5, stacoll1, stacoll2, stacoll3, stacoll4, stacoll5, stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5, stavalues1, stavalues2, stavalues3, stavalues4, stavalues5 ` +
- `FROM pg_catalog.pg_statistic ` +
- `WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3`
- // run
- logf(sqlstr, starelid, staattnum, stainherit)
- ps := PgStatistic{}
- if err := db.QueryRowContext(ctx, sqlstr, starelid, staattnum, stainherit).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Starelid, &ps.Staattnum, &ps.Stainherit, &ps.Stanullfrac, &ps.Stawidth, &ps.Stadistinct, &ps.Stakind1, &ps.Stakind2, &ps.Stakind3, &ps.Stakind4, &ps.Stakind5, &ps.Staop1, &ps.Staop2, &ps.Staop3, &ps.Staop4, &ps.Staop5, &ps.Stacoll1, &ps.Stacoll2, &ps.Stacoll3, &ps.Stacoll4, &ps.Stacoll5, &ps.Stanumbers1, &ps.Stanumbers2, &ps.Stanumbers3, &ps.Stanumbers4, &ps.Stanumbers5, &ps.Stavalues1, &ps.Stavalues2, &ps.Stavalues3, &ps.Stavalues4, &ps.Stavalues5); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgStatisticExtByStxnameStxnamespace retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
- //
- // Generated from index 'pg_statistic_ext_name_index'.
- func PgStatisticExtByStxnameStxnamespace(ctx context.Context, db DB, stxname string, stxnamespace pgtypes.Oid) (*PgStatisticExt, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
- `FROM pg_catalog.pg_statistic_ext ` +
- `WHERE stxname = $1 AND stxnamespace = $2`
- // run
- logf(sqlstr, stxname, stxnamespace)
- pse := PgStatisticExt{}
- if err := db.QueryRowContext(ctx, sqlstr, stxname, stxnamespace).Scan(&pse.Tableoid, &pse.Cmax, &pse.Xmax, &pse.Cmin, &pse.Xmin, &pse.Ctid, &pse.Oid, &pse.Stxrelid, &pse.Stxname, &pse.Stxnamespace, &pse.Stxowner, &pse.Stxstattarget, &pse.Stxkeys, &pse.Stxkind); err != nil {
- return nil, logerror(err)
- }
- return &pse, nil
- }
- // PgStatisticExtByOid retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
- //
- // Generated from index 'pg_statistic_ext_oid_index'.
- func PgStatisticExtByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgStatisticExt, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
- `FROM pg_catalog.pg_statistic_ext ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pse := PgStatisticExt{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pse.Tableoid, &pse.Cmax, &pse.Xmax, &pse.Cmin, &pse.Xmin, &pse.Ctid, &pse.Oid, &pse.Stxrelid, &pse.Stxname, &pse.Stxnamespace, &pse.Stxowner, &pse.Stxstattarget, &pse.Stxkeys, &pse.Stxkind); err != nil {
- return nil, logerror(err)
- }
- return &pse, nil
- }
- // PgStatisticExtByStxrelid retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
- //
- // Generated from index 'pg_statistic_ext_relid_index'.
- func PgStatisticExtByStxrelid(ctx context.Context, db DB, stxrelid pgtypes.Oid) ([]*PgStatisticExt, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
- `FROM pg_catalog.pg_statistic_ext ` +
- `WHERE stxrelid = $1`
- // run
- logf(sqlstr, stxrelid)
- rows, err := db.QueryContext(ctx, sqlstr, stxrelid)
- if err != nil {
- return nil, logerror(err)
- }
- defer rows.Close()
- // process
- var res []*PgStatisticExt
- for rows.Next() {
- pse := PgStatisticExt{}
- // scan
- if err := rows.Scan(&pse.Tableoid, &pse.Cmax, &pse.Xmax, &pse.Cmin, &pse.Xmin, &pse.Ctid, &pse.Oid, &pse.Stxrelid, &pse.Stxname, &pse.Stxnamespace, &pse.Stxowner, &pse.Stxstattarget, &pse.Stxkeys, &pse.Stxkind); err != nil {
- return nil, logerror(err)
- }
- res = append(res, &pse)
- }
- if err := rows.Err(); err != nil {
- return nil, logerror(err)
- }
- return res, nil
- }
- // PgStatisticExtDatumByStxoid retrieves a row from 'pg_catalog.pg_statistic_ext_data' as a PgStatisticExtDatum.
- //
- // Generated from index 'pg_statistic_ext_data_stxoid_index'.
- func PgStatisticExtDatumByStxoid(ctx context.Context, db DB, stxoid pgtypes.Oid) (*PgStatisticExtDatum, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, stxoid, stxdndistinct, stxddependencies, stxdmcv ` +
- `FROM pg_catalog.pg_statistic_ext_data ` +
- `WHERE stxoid = $1`
- // run
- logf(sqlstr, stxoid)
- psed := PgStatisticExtDatum{}
- if err := db.QueryRowContext(ctx, sqlstr, stxoid).Scan(&psed.Tableoid, &psed.Cmax, &psed.Xmax, &psed.Cmin, &psed.Xmin, &psed.Ctid, &psed.Stxoid, &psed.Stxdndistinct, &psed.Stxddependencies, &psed.Stxdmcv); err != nil {
- return nil, logerror(err)
- }
- return &psed, nil
- }
- // PgSubscriptionByOid retrieves a row from 'pg_catalog.pg_subscription' as a PgSubscription.
- //
- // Generated from index 'pg_subscription_oid_index'.
- func PgSubscriptionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgSubscription, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, subdbid, subname, subowner, subenabled, subconninfo, subslotname, subsynccommit, subpublications ` +
- `FROM pg_catalog.pg_subscription ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- ps := PgSubscription{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Oid, &ps.Subdbid, &ps.Subname, &ps.Subowner, &ps.Subenabled, &ps.Subconninfo, &ps.Subslotname, &ps.Subsynccommit, &ps.Subpublications); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgSubscriptionBySubdbidSubname retrieves a row from 'pg_catalog.pg_subscription' as a PgSubscription.
- //
- // Generated from index 'pg_subscription_subname_index'.
- func PgSubscriptionBySubdbidSubname(ctx context.Context, db DB, subdbid pgtypes.Oid, subname string) (*PgSubscription, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, subdbid, subname, subowner, subenabled, subconninfo, subslotname, subsynccommit, subpublications ` +
- `FROM pg_catalog.pg_subscription ` +
- `WHERE subdbid = $1 AND subname = $2`
- // run
- logf(sqlstr, subdbid, subname)
- ps := PgSubscription{}
- if err := db.QueryRowContext(ctx, sqlstr, subdbid, subname).Scan(&ps.Tableoid, &ps.Cmax, &ps.Xmax, &ps.Cmin, &ps.Xmin, &ps.Ctid, &ps.Oid, &ps.Subdbid, &ps.Subname, &ps.Subowner, &ps.Subenabled, &ps.Subconninfo, &ps.Subslotname, &ps.Subsynccommit, &ps.Subpublications); err != nil {
- return nil, logerror(err)
- }
- return &ps, nil
- }
- // PgSubscriptionRelBySrrelidSrsubid retrieves a row from 'pg_catalog.pg_subscription_rel' as a PgSubscriptionRel.
- //
- // Generated from index 'pg_subscription_rel_srrelid_srsubid_index'.
- func PgSubscriptionRelBySrrelidSrsubid(ctx context.Context, db DB, srrelid, srsubid pgtypes.Oid) (*PgSubscriptionRel, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, srsubid, srrelid, srsubstate, srsublsn ` +
- `FROM pg_catalog.pg_subscription_rel ` +
- `WHERE srrelid = $1 AND srsubid = $2`
- // run
- logf(sqlstr, srrelid, srsubid)
- psr := PgSubscriptionRel{}
- if err := db.QueryRowContext(ctx, sqlstr, srrelid, srsubid).Scan(&psr.Tableoid, &psr.Cmax, &psr.Xmax, &psr.Cmin, &psr.Xmin, &psr.Ctid, &psr.Srsubid, &psr.Srrelid, &psr.Srsubstate, &psr.Srsublsn); err != nil {
- return nil, logerror(err)
- }
- return &psr, nil
- }
- // PgTablespaceByOid retrieves a row from 'pg_catalog.pg_tablespace' as a PgTablespace.
- //
- // Generated from index 'pg_tablespace_oid_index'.
- func PgTablespaceByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgTablespace, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, spcname, spcowner, spcacl, spcoptions ` +
- `FROM pg_catalog.pg_tablespace ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pt := PgTablespace{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pt.Tableoid, &pt.Cmax, &pt.Xmax, &pt.Cmin, &pt.Xmin, &pt.Ctid, &pt.Oid, &pt.Spcname, &pt.Spcowner, &pt.Spcacl, &pt.Spcoptions); err != nil {
- return nil, logerror(err)
- }
- return &pt, nil
- }
- // PgTablespaceBySpcname retrieves a row from 'pg_catalog.pg_tablespace' as a PgTablespace.
- //
- // Generated from index 'pg_tablespace_spcname_index'.
- func PgTablespaceBySpcname(ctx context.Context, db DB, spcname string) (*PgTablespace, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, spcname, spcowner, spcacl, spcoptions ` +
- `FROM pg_catalog.pg_tablespace ` +
- `WHERE spcname = $1`
- // run
- logf(sqlstr, spcname)
- pt := PgTablespace{}
- if err := db.QueryRowContext(ctx, sqlstr, spcname).Scan(&pt.Tableoid, &pt.Cmax, &pt.Xmax, &pt.Cmin, &pt.Xmin, &pt.Ctid, &pt.Oid, &pt.Spcname, &pt.Spcowner, &pt.Spcacl, &pt.Spcoptions); err != nil {
- return nil, logerror(err)
- }
- return &pt, nil
- }
- // PgTransformByOid retrieves a row from 'pg_catalog.pg_transform' as a PgTransform.
- //
- // Generated from index 'pg_transform_oid_index'.
- func PgTransformByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgTransform, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, trftype, trflang, trffromsql, trftosql ` +
- `FROM pg_catalog.pg_transform ` +
- `WHERE oid = $1`
- // run
- logf(sqlstr, oid)
- pt := PgTransform{}
- if err := db.QueryRowContext(ctx, sqlstr, oid).Scan(&pt.Tableoid, &pt.Cmax, &pt.Xmax, &pt.Cmin, &pt.Xmin, &pt.Ctid, &pt.Oid, &pt.Trftype, &pt.Trflang, &pt.Trffromsql, &pt.Trftosql); err != nil {
- return nil, logerror(err)
- }
- return &pt, nil
- }
- // PgTransformByTrftypeTrflang retrieves a row from 'pg_catalog.pg_transform' as a PgTransform.
- //
- // Generated from index 'pg_transform_type_lang_index'.
- func PgTransformByTrftypeTrflang(ctx context.Context, db DB, trftype, trflang pgtypes.Oid) (*PgTransform, error) {
- // query
- const sqlstr = `SELECT ` +
- `tableoid, cmax, xmax, cmin, xmin, ctid, oid, trftype, trflang, trffromsql, trftosql ` +
- `FROM pg_catalog.pg_transform ` +
- `WHERE trftype = $1 AND trflang = $2`
- // run
- logf(sqlstr, trftype, trflang)
- pt := PgTransform{}
- if err := db.QueryRowContext(