PageRenderTime 51ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 2ms

/_examples/pgcatalog/pgcatalog/pgcatalog.xo.go

https://github.com/xo/xo
Go | 12072 lines | 8683 code | 860 blank | 2529 comment | 1475 complexity | e0ce5dccc891ed58e1e979f4aca9e850 MD5 | raw file
  1. // Package pgcatalog contains generated code for schema 'pg_catalog'.
  2. package pgcatalog
  3. // Code generated by xo. DO NOT EDIT.
  4. import (
  5. "context"
  6. "database/sql"
  7. "database/sql/driver"
  8. "encoding/csv"
  9. "fmt"
  10. "io"
  11. "regexp"
  12. "strings"
  13. "time"
  14. "github.com/xo/xo/_examples/pgcatalog/pgtypes"
  15. "github.com/google/uuid"
  16. )
  17. var (
  18. // logf is used by generated code to log SQL queries.
  19. logf = func(string, ...interface{}) {}
  20. // errf is used by generated code to log SQL errors.
  21. errf = func(string, ...interface{}) {}
  22. )
  23. // logerror logs the error and returns it.
  24. func logerror(err error) error {
  25. errf("ERROR: %v", err)
  26. return err
  27. }
  28. // Logf logs a message using the package logger.
  29. func Logf(s string, v ...interface{}) {
  30. logf(s, v...)
  31. }
  32. // SetLogger sets the package logger. Valid logger types:
  33. //
  34. // io.Writer
  35. // func(string, ...interface{}) (int, error) // fmt.Printf
  36. // func(string, ...interface{}) // log.Printf
  37. //
  38. func SetLogger(logger interface{}) {
  39. logf = convLogger(logger)
  40. }
  41. // Errorf logs an error message using the package error logger.
  42. func Errorf(s string, v ...interface{}) {
  43. errf(s, v...)
  44. }
  45. // SetErrorLogger sets the package error logger. Valid logger types:
  46. //
  47. // io.Writer
  48. // func(string, ...interface{}) (int, error) // fmt.Printf
  49. // func(string, ...interface{}) // log.Printf
  50. //
  51. func SetErrorLogger(logger interface{}) {
  52. errf = convLogger(logger)
  53. }
  54. // convLogger converts logger to the standard logger interface.
  55. func convLogger(logger interface{}) func(string, ...interface{}) {
  56. switch z := logger.(type) {
  57. case io.Writer:
  58. return func(s string, v ...interface{}) {
  59. fmt.Fprintf(z, s, v...)
  60. }
  61. case func(string, ...interface{}) (int, error): // fmt.Printf
  62. return func(s string, v ...interface{}) {
  63. _, _ = z(s, v...)
  64. }
  65. case func(string, ...interface{}): // log.Printf
  66. return z
  67. }
  68. panic(fmt.Sprintf("unsupported logger type %T", logger))
  69. }
  70. // DB is the common interface for database operations that can be used with
  71. // types from schema 'pg_catalog'.
  72. //
  73. // This works with both database/sql.DB and database/sql.Tx.
  74. type DB interface {
  75. ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
  76. QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
  77. QueryRowContext(context.Context, string, ...interface{}) *sql.Row
  78. }
  79. // Error is an error.
  80. type Error string
  81. // Error satisfies the error interface.
  82. func (err Error) Error() string {
  83. return string(err)
  84. }
  85. // Error values.
  86. const (
  87. // ErrAlreadyExists is the already exists error.
  88. ErrAlreadyExists Error = "already exists"
  89. // ErrDoesNotExist is the does not exist error.
  90. ErrDoesNotExist Error = "does not exist"
  91. // ErrMarkedForDeletion is the marked for deletion error.
  92. ErrMarkedForDeletion Error = "marked for deletion"
  93. )
  94. // ErrInsertFailed is the insert failed error.
  95. type ErrInsertFailed struct {
  96. Err error
  97. }
  98. // Error satisfies the error interface.
  99. func (err *ErrInsertFailed) Error() string {
  100. return fmt.Sprintf("insert failed: %v", err.Err)
  101. }
  102. // Unwrap satisfies the unwrap interface.
  103. func (err *ErrInsertFailed) Unwrap() error {
  104. return err.Err
  105. }
  106. // ErrUpdateFailed is the update failed error.
  107. type ErrUpdateFailed struct {
  108. Err error
  109. }
  110. // Error satisfies the error interface.
  111. func (err *ErrUpdateFailed) Error() string {
  112. return fmt.Sprintf("update failed: %v", err.Err)
  113. }
  114. // Unwrap satisfies the unwrap interface.
  115. func (err *ErrUpdateFailed) Unwrap() error {
  116. return err.Err
  117. }
  118. // ErrUpsertFailed is the upsert failed error.
  119. type ErrUpsertFailed struct {
  120. Err error
  121. }
  122. // Error satisfies the error interface.
  123. func (err *ErrUpsertFailed) Error() string {
  124. return fmt.Sprintf("upsert failed: %v", err.Err)
  125. }
  126. // Unwrap satisfies the unwrap interface.
  127. func (err *ErrUpsertFailed) Unwrap() error {
  128. return err.Err
  129. }
  130. // ErrDecodeFailed is the decode failed error.
  131. type ErrDecodeFailed struct {
  132. Err error
  133. }
  134. // Error satisfies the error interface.
  135. func (err *ErrDecodeFailed) Error() string {
  136. return fmt.Sprintf("unable to decode: %v", err.Err)
  137. }
  138. // Unwrap satisfies the unwrap interface.
  139. func (err *ErrDecodeFailed) Unwrap() error {
  140. return err.Err
  141. }
  142. // ErrInvalidStringSlice is the invalid StringSlice error.
  143. const ErrInvalidStringSlice Error = "invalid StringSlice"
  144. // StringSlice is a slice of strings.
  145. type StringSlice []string
  146. // Scan satisfies the sql.Scanner interface for StringSlice.
  147. func (ss *StringSlice) Scan(v interface{}) error {
  148. buf, ok := v.([]byte)
  149. if !ok {
  150. return logerror(ErrInvalidStringSlice)
  151. }
  152. // change quote escapes for csv parser
  153. str := strings.Replace(quoteEscRE.ReplaceAllString(string(buf), `$1""`), `\\`, `\`, -1)
  154. str = str[1 : len(str)-1]
  155. // bail if only one
  156. if len(str) == 0 {
  157. return nil
  158. }
  159. // parse with csv reader
  160. r := csv.NewReader(strings.NewReader(str))
  161. line, err := r.Read()
  162. if err != nil {
  163. return logerror(&ErrDecodeFailed{err})
  164. }
  165. *ss = StringSlice(line)
  166. return nil
  167. }
  168. // quoteEscRE matches escaped characters in a string.
  169. var quoteEscRE = regexp.MustCompile(`([^\\]([\\]{2})*)\\"`)
  170. // Value satisfies the sql/driver.Valuer interface.
  171. func (ss StringSlice) Value() (driver.Value, error) {
  172. v := make([]string, len(ss))
  173. for i, s := range ss {
  174. v[i] = `"` + strings.Replace(strings.Replace(s, `\`, `\\\`, -1), `"`, `\"`, -1) + `"`
  175. }
  176. return "{" + strings.Join(v, ",") + "}", nil
  177. }
  178. // PgAggregate represents a row from 'pg_catalog.pg_aggregate'.
  179. type PgAggregate struct {
  180. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  181. Cmax pgtypes.Cid `json:"cmax"` // cmax
  182. Xmax pgtypes.Xid `json:"xmax"` // xmax
  183. Cmin pgtypes.Cid `json:"cmin"` // cmin
  184. Xmin pgtypes.Xid `json:"xmin"` // xmin
  185. Ctid pgtypes.Tid `json:"ctid"` // ctid
  186. Aggfnoid pgtypes.Regproc `json:"aggfnoid"` // aggfnoid
  187. Aggkind pgtypes.Char `json:"aggkind"` // aggkind
  188. Aggnumdirectargs int16 `json:"aggnumdirectargs"` // aggnumdirectargs
  189. Aggtransfn pgtypes.Regproc `json:"aggtransfn"` // aggtransfn
  190. Aggfinalfn pgtypes.Regproc `json:"aggfinalfn"` // aggfinalfn
  191. Aggcombinefn pgtypes.Regproc `json:"aggcombinefn"` // aggcombinefn
  192. Aggserialfn pgtypes.Regproc `json:"aggserialfn"` // aggserialfn
  193. Aggdeserialfn pgtypes.Regproc `json:"aggdeserialfn"` // aggdeserialfn
  194. Aggmtransfn pgtypes.Regproc `json:"aggmtransfn"` // aggmtransfn
  195. Aggminvtransfn pgtypes.Regproc `json:"aggminvtransfn"` // aggminvtransfn
  196. Aggmfinalfn pgtypes.Regproc `json:"aggmfinalfn"` // aggmfinalfn
  197. Aggfinalextra bool `json:"aggfinalextra"` // aggfinalextra
  198. Aggmfinalextra bool `json:"aggmfinalextra"` // aggmfinalextra
  199. Aggfinalmodify pgtypes.Char `json:"aggfinalmodify"` // aggfinalmodify
  200. Aggmfinalmodify pgtypes.Char `json:"aggmfinalmodify"` // aggmfinalmodify
  201. Aggsortop pgtypes.Oid `json:"aggsortop"` // aggsortop
  202. Aggtranstype pgtypes.Oid `json:"aggtranstype"` // aggtranstype
  203. Aggtransspace int `json:"aggtransspace"` // aggtransspace
  204. Aggmtranstype pgtypes.Oid `json:"aggmtranstype"` // aggmtranstype
  205. Aggmtransspace int `json:"aggmtransspace"` // aggmtransspace
  206. Agginitval sql.NullString `json:"agginitval"` // agginitval
  207. Aggminitval sql.NullString `json:"aggminitval"` // aggminitval
  208. }
  209. // PgAm represents a row from 'pg_catalog.pg_am'.
  210. type PgAm struct {
  211. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  212. Cmax pgtypes.Cid `json:"cmax"` // cmax
  213. Xmax pgtypes.Xid `json:"xmax"` // xmax
  214. Cmin pgtypes.Cid `json:"cmin"` // cmin
  215. Xmin pgtypes.Xid `json:"xmin"` // xmin
  216. Ctid pgtypes.Tid `json:"ctid"` // ctid
  217. Oid pgtypes.Oid `json:"oid"` // oid
  218. Amname string `json:"amname"` // amname
  219. Amhandler pgtypes.Regproc `json:"amhandler"` // amhandler
  220. Amtype pgtypes.Char `json:"amtype"` // amtype
  221. }
  222. // PgAmop represents a row from 'pg_catalog.pg_amop'.
  223. type PgAmop struct {
  224. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  225. Cmax pgtypes.Cid `json:"cmax"` // cmax
  226. Xmax pgtypes.Xid `json:"xmax"` // xmax
  227. Cmin pgtypes.Cid `json:"cmin"` // cmin
  228. Xmin pgtypes.Xid `json:"xmin"` // xmin
  229. Ctid pgtypes.Tid `json:"ctid"` // ctid
  230. Oid pgtypes.Oid `json:"oid"` // oid
  231. Amopfamily pgtypes.Oid `json:"amopfamily"` // amopfamily
  232. Amoplefttype pgtypes.Oid `json:"amoplefttype"` // amoplefttype
  233. Amoprighttype pgtypes.Oid `json:"amoprighttype"` // amoprighttype
  234. Amopstrategy int16 `json:"amopstrategy"` // amopstrategy
  235. Amoppurpose pgtypes.Char `json:"amoppurpose"` // amoppurpose
  236. Amopopr pgtypes.Oid `json:"amopopr"` // amopopr
  237. Amopmethod pgtypes.Oid `json:"amopmethod"` // amopmethod
  238. Amopsortfamily pgtypes.Oid `json:"amopsortfamily"` // amopsortfamily
  239. }
  240. // PgAmproc represents a row from 'pg_catalog.pg_amproc'.
  241. type PgAmproc struct {
  242. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  243. Cmax pgtypes.Cid `json:"cmax"` // cmax
  244. Xmax pgtypes.Xid `json:"xmax"` // xmax
  245. Cmin pgtypes.Cid `json:"cmin"` // cmin
  246. Xmin pgtypes.Xid `json:"xmin"` // xmin
  247. Ctid pgtypes.Tid `json:"ctid"` // ctid
  248. Oid pgtypes.Oid `json:"oid"` // oid
  249. Amprocfamily pgtypes.Oid `json:"amprocfamily"` // amprocfamily
  250. Amproclefttype pgtypes.Oid `json:"amproclefttype"` // amproclefttype
  251. Amprocrighttype pgtypes.Oid `json:"amprocrighttype"` // amprocrighttype
  252. Amprocnum int16 `json:"amprocnum"` // amprocnum
  253. Amproc pgtypes.Regproc `json:"amproc"` // amproc
  254. }
  255. // PgAttrdef represents a row from 'pg_catalog.pg_attrdef'.
  256. type PgAttrdef struct {
  257. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  258. Cmax pgtypes.Cid `json:"cmax"` // cmax
  259. Xmax pgtypes.Xid `json:"xmax"` // xmax
  260. Cmin pgtypes.Cid `json:"cmin"` // cmin
  261. Xmin pgtypes.Xid `json:"xmin"` // xmin
  262. Ctid pgtypes.Tid `json:"ctid"` // ctid
  263. Oid pgtypes.Oid `json:"oid"` // oid
  264. Adrelid pgtypes.Oid `json:"adrelid"` // adrelid
  265. Adnum int16 `json:"adnum"` // adnum
  266. Adbin pgtypes.PgNodeTree `json:"adbin"` // adbin
  267. }
  268. // PgAttribute represents a row from 'pg_catalog.pg_attribute'.
  269. type PgAttribute struct {
  270. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  271. Cmax pgtypes.Cid `json:"cmax"` // cmax
  272. Xmax pgtypes.Xid `json:"xmax"` // xmax
  273. Cmin pgtypes.Cid `json:"cmin"` // cmin
  274. Xmin pgtypes.Xid `json:"xmin"` // xmin
  275. Ctid pgtypes.Tid `json:"ctid"` // ctid
  276. Attrelid pgtypes.Oid `json:"attrelid"` // attrelid
  277. Attname string `json:"attname"` // attname
  278. Atttypid pgtypes.Oid `json:"atttypid"` // atttypid
  279. Attstattarget int `json:"attstattarget"` // attstattarget
  280. Attlen int16 `json:"attlen"` // attlen
  281. Attnum int16 `json:"attnum"` // attnum
  282. Attndims int `json:"attndims"` // attndims
  283. Attcacheoff int `json:"attcacheoff"` // attcacheoff
  284. Atttypmod int `json:"atttypmod"` // atttypmod
  285. Attbyval bool `json:"attbyval"` // attbyval
  286. Attstorage pgtypes.Char `json:"attstorage"` // attstorage
  287. Attalign pgtypes.Char `json:"attalign"` // attalign
  288. Attnotnull bool `json:"attnotnull"` // attnotnull
  289. Atthasdef bool `json:"atthasdef"` // atthasdef
  290. Atthasmissing bool `json:"atthasmissing"` // atthasmissing
  291. Attidentity pgtypes.Char `json:"attidentity"` // attidentity
  292. Attgenerated pgtypes.Char `json:"attgenerated"` // attgenerated
  293. Attisdropped bool `json:"attisdropped"` // attisdropped
  294. Attislocal bool `json:"attislocal"` // attislocal
  295. Attinhcount int `json:"attinhcount"` // attinhcount
  296. Attcollation pgtypes.Oid `json:"attcollation"` // attcollation
  297. Attacl []pgtypes.NullAclitem `json:"attacl"` // attacl
  298. Attoptions []sql.NullString `json:"attoptions"` // attoptions
  299. Attfdwoptions []sql.NullString `json:"attfdwoptions"` // attfdwoptions
  300. Attmissingval pgtypes.NullAnyarray `json:"attmissingval"` // attmissingval
  301. }
  302. // PgAuthMember represents a row from 'pg_catalog.pg_auth_members'.
  303. type PgAuthMember struct {
  304. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  305. Cmax pgtypes.Cid `json:"cmax"` // cmax
  306. Xmax pgtypes.Xid `json:"xmax"` // xmax
  307. Cmin pgtypes.Cid `json:"cmin"` // cmin
  308. Xmin pgtypes.Xid `json:"xmin"` // xmin
  309. Ctid pgtypes.Tid `json:"ctid"` // ctid
  310. Roleid pgtypes.Oid `json:"roleid"` // roleid
  311. Member pgtypes.Oid `json:"member"` // member
  312. Grantor pgtypes.Oid `json:"grantor"` // grantor
  313. AdminOption bool `json:"admin_option"` // admin_option
  314. }
  315. // PgAuthid represents a row from 'pg_catalog.pg_authid'.
  316. type PgAuthid struct {
  317. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  318. Cmax pgtypes.Cid `json:"cmax"` // cmax
  319. Xmax pgtypes.Xid `json:"xmax"` // xmax
  320. Cmin pgtypes.Cid `json:"cmin"` // cmin
  321. Xmin pgtypes.Xid `json:"xmin"` // xmin
  322. Ctid pgtypes.Tid `json:"ctid"` // ctid
  323. Oid pgtypes.Oid `json:"oid"` // oid
  324. Rolname string `json:"rolname"` // rolname
  325. Rolsuper bool `json:"rolsuper"` // rolsuper
  326. Rolinherit bool `json:"rolinherit"` // rolinherit
  327. Rolcreaterole bool `json:"rolcreaterole"` // rolcreaterole
  328. Rolcreatedb bool `json:"rolcreatedb"` // rolcreatedb
  329. Rolcanlogin bool `json:"rolcanlogin"` // rolcanlogin
  330. Rolreplication bool `json:"rolreplication"` // rolreplication
  331. Rolbypassrls bool `json:"rolbypassrls"` // rolbypassrls
  332. Rolconnlimit int `json:"rolconnlimit"` // rolconnlimit
  333. Rolpassword sql.NullString `json:"rolpassword"` // rolpassword
  334. Rolvaliduntil sql.NullTime `json:"rolvaliduntil"` // rolvaliduntil
  335. }
  336. // PgAvailableExtension represents a row from 'pg_catalog.pg_available_extensions'.
  337. type PgAvailableExtension struct {
  338. Name sql.NullString `json:"name"` // name
  339. DefaultVersion sql.NullString `json:"default_version"` // default_version
  340. InstalledVersion sql.NullString `json:"installed_version"` // installed_version
  341. Comment sql.NullString `json:"comment"` // comment
  342. }
  343. // PgAvailableExtensionVersion represents a row from 'pg_catalog.pg_available_extension_versions'.
  344. type PgAvailableExtensionVersion struct {
  345. Name sql.NullString `json:"name"` // name
  346. Version sql.NullString `json:"version"` // version
  347. Installed sql.NullBool `json:"installed"` // installed
  348. Superuser sql.NullBool `json:"superuser"` // superuser
  349. Trusted sql.NullBool `json:"trusted"` // trusted
  350. Relocatable sql.NullBool `json:"relocatable"` // relocatable
  351. Schema sql.NullString `json:"schema"` // schema
  352. Requires []sql.NullString `json:"requires"` // requires
  353. Comment sql.NullString `json:"comment"` // comment
  354. }
  355. // PgCast represents a row from 'pg_catalog.pg_cast'.
  356. type PgCast struct {
  357. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  358. Cmax pgtypes.Cid `json:"cmax"` // cmax
  359. Xmax pgtypes.Xid `json:"xmax"` // xmax
  360. Cmin pgtypes.Cid `json:"cmin"` // cmin
  361. Xmin pgtypes.Xid `json:"xmin"` // xmin
  362. Ctid pgtypes.Tid `json:"ctid"` // ctid
  363. Oid pgtypes.Oid `json:"oid"` // oid
  364. Castsource pgtypes.Oid `json:"castsource"` // castsource
  365. Casttarget pgtypes.Oid `json:"casttarget"` // casttarget
  366. Castfunc pgtypes.Oid `json:"castfunc"` // castfunc
  367. Castcontext pgtypes.Char `json:"castcontext"` // castcontext
  368. Castmethod pgtypes.Char `json:"castmethod"` // castmethod
  369. }
  370. // PgClass represents a row from 'pg_catalog.pg_class'.
  371. type PgClass struct {
  372. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  373. Cmax pgtypes.Cid `json:"cmax"` // cmax
  374. Xmax pgtypes.Xid `json:"xmax"` // xmax
  375. Cmin pgtypes.Cid `json:"cmin"` // cmin
  376. Xmin pgtypes.Xid `json:"xmin"` // xmin
  377. Ctid pgtypes.Tid `json:"ctid"` // ctid
  378. Oid pgtypes.Oid `json:"oid"` // oid
  379. Relname string `json:"relname"` // relname
  380. Relnamespace pgtypes.Oid `json:"relnamespace"` // relnamespace
  381. Reltype pgtypes.Oid `json:"reltype"` // reltype
  382. Reloftype pgtypes.Oid `json:"reloftype"` // reloftype
  383. Relowner pgtypes.Oid `json:"relowner"` // relowner
  384. Relam pgtypes.Oid `json:"relam"` // relam
  385. Relfilenode pgtypes.Oid `json:"relfilenode"` // relfilenode
  386. Reltablespace pgtypes.Oid `json:"reltablespace"` // reltablespace
  387. Relpages int `json:"relpages"` // relpages
  388. Reltuples float32 `json:"reltuples"` // reltuples
  389. Relallvisible int `json:"relallvisible"` // relallvisible
  390. Reltoastrelid pgtypes.Oid `json:"reltoastrelid"` // reltoastrelid
  391. Relhasindex bool `json:"relhasindex"` // relhasindex
  392. Relisshared bool `json:"relisshared"` // relisshared
  393. Relpersistence pgtypes.Char `json:"relpersistence"` // relpersistence
  394. Relkind pgtypes.Char `json:"relkind"` // relkind
  395. Relnatts int16 `json:"relnatts"` // relnatts
  396. Relchecks int16 `json:"relchecks"` // relchecks
  397. Relhasrules bool `json:"relhasrules"` // relhasrules
  398. Relhastriggers bool `json:"relhastriggers"` // relhastriggers
  399. Relhassubclass bool `json:"relhassubclass"` // relhassubclass
  400. Relrowsecurity bool `json:"relrowsecurity"` // relrowsecurity
  401. Relforcerowsecurity bool `json:"relforcerowsecurity"` // relforcerowsecurity
  402. Relispopulated bool `json:"relispopulated"` // relispopulated
  403. Relreplident pgtypes.Char `json:"relreplident"` // relreplident
  404. Relispartition bool `json:"relispartition"` // relispartition
  405. Relrewrite pgtypes.Oid `json:"relrewrite"` // relrewrite
  406. Relfrozenxid pgtypes.Xid `json:"relfrozenxid"` // relfrozenxid
  407. Relminmxid pgtypes.Xid `json:"relminmxid"` // relminmxid
  408. Relacl []pgtypes.NullAclitem `json:"relacl"` // relacl
  409. Reloptions []sql.NullString `json:"reloptions"` // reloptions
  410. Relpartbound pgtypes.NullPgNodeTree `json:"relpartbound"` // relpartbound
  411. }
  412. // PgCollation represents a row from 'pg_catalog.pg_collation'.
  413. type PgCollation struct {
  414. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  415. Cmax pgtypes.Cid `json:"cmax"` // cmax
  416. Xmax pgtypes.Xid `json:"xmax"` // xmax
  417. Cmin pgtypes.Cid `json:"cmin"` // cmin
  418. Xmin pgtypes.Xid `json:"xmin"` // xmin
  419. Ctid pgtypes.Tid `json:"ctid"` // ctid
  420. Oid pgtypes.Oid `json:"oid"` // oid
  421. Collname string `json:"collname"` // collname
  422. Collnamespace pgtypes.Oid `json:"collnamespace"` // collnamespace
  423. Collowner pgtypes.Oid `json:"collowner"` // collowner
  424. Collprovider pgtypes.Char `json:"collprovider"` // collprovider
  425. Collisdeterministic bool `json:"collisdeterministic"` // collisdeterministic
  426. Collencoding int `json:"collencoding"` // collencoding
  427. Collcollate string `json:"collcollate"` // collcollate
  428. Collctype string `json:"collctype"` // collctype
  429. Collversion sql.NullString `json:"collversion"` // collversion
  430. }
  431. // PgConfig represents a row from 'pg_catalog.pg_config'.
  432. type PgConfig struct {
  433. Name sql.NullString `json:"name"` // name
  434. Setting sql.NullString `json:"setting"` // setting
  435. }
  436. // PgConstraint represents a row from 'pg_catalog.pg_constraint'.
  437. type PgConstraint struct {
  438. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  439. Cmax pgtypes.Cid `json:"cmax"` // cmax
  440. Xmax pgtypes.Xid `json:"xmax"` // xmax
  441. Cmin pgtypes.Cid `json:"cmin"` // cmin
  442. Xmin pgtypes.Xid `json:"xmin"` // xmin
  443. Ctid pgtypes.Tid `json:"ctid"` // ctid
  444. Oid pgtypes.Oid `json:"oid"` // oid
  445. Conname string `json:"conname"` // conname
  446. Connamespace pgtypes.Oid `json:"connamespace"` // connamespace
  447. Contype pgtypes.Char `json:"contype"` // contype
  448. Condeferrable bool `json:"condeferrable"` // condeferrable
  449. Condeferred bool `json:"condeferred"` // condeferred
  450. Convalidated bool `json:"convalidated"` // convalidated
  451. Conrelid pgtypes.Oid `json:"conrelid"` // conrelid
  452. Contypid pgtypes.Oid `json:"contypid"` // contypid
  453. Conindid pgtypes.Oid `json:"conindid"` // conindid
  454. Conparentid pgtypes.Oid `json:"conparentid"` // conparentid
  455. Confrelid pgtypes.Oid `json:"confrelid"` // confrelid
  456. Confupdtype pgtypes.Char `json:"confupdtype"` // confupdtype
  457. Confdeltype pgtypes.Char `json:"confdeltype"` // confdeltype
  458. Confmatchtype pgtypes.Char `json:"confmatchtype"` // confmatchtype
  459. Conislocal bool `json:"conislocal"` // conislocal
  460. Coninhcount int `json:"coninhcount"` // coninhcount
  461. Connoinherit bool `json:"connoinherit"` // connoinherit
  462. Conkey []sql.NullInt64 `json:"conkey"` // conkey
  463. Confkey []sql.NullInt64 `json:"confkey"` // confkey
  464. Conpfeqop []pgtypes.NullOid `json:"conpfeqop"` // conpfeqop
  465. Conppeqop []pgtypes.NullOid `json:"conppeqop"` // conppeqop
  466. Conffeqop []pgtypes.NullOid `json:"conffeqop"` // conffeqop
  467. Conexclop []pgtypes.NullOid `json:"conexclop"` // conexclop
  468. Conbin pgtypes.NullPgNodeTree `json:"conbin"` // conbin
  469. }
  470. // PgConversion represents a row from 'pg_catalog.pg_conversion'.
  471. type PgConversion struct {
  472. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  473. Cmax pgtypes.Cid `json:"cmax"` // cmax
  474. Xmax pgtypes.Xid `json:"xmax"` // xmax
  475. Cmin pgtypes.Cid `json:"cmin"` // cmin
  476. Xmin pgtypes.Xid `json:"xmin"` // xmin
  477. Ctid pgtypes.Tid `json:"ctid"` // ctid
  478. Oid pgtypes.Oid `json:"oid"` // oid
  479. Conname string `json:"conname"` // conname
  480. Connamespace pgtypes.Oid `json:"connamespace"` // connamespace
  481. Conowner pgtypes.Oid `json:"conowner"` // conowner
  482. Conforencoding int `json:"conforencoding"` // conforencoding
  483. Contoencoding int `json:"contoencoding"` // contoencoding
  484. Conproc pgtypes.Regproc `json:"conproc"` // conproc
  485. Condefault bool `json:"condefault"` // condefault
  486. }
  487. // PgCursor represents a row from 'pg_catalog.pg_cursors'.
  488. type PgCursor struct {
  489. Name sql.NullString `json:"name"` // name
  490. Statement sql.NullString `json:"statement"` // statement
  491. IsHoldable sql.NullBool `json:"is_holdable"` // is_holdable
  492. IsBinary sql.NullBool `json:"is_binary"` // is_binary
  493. IsScrollable sql.NullBool `json:"is_scrollable"` // is_scrollable
  494. CreationTime sql.NullTime `json:"creation_time"` // creation_time
  495. }
  496. // PgDatabase represents a row from 'pg_catalog.pg_database'.
  497. type PgDatabase struct {
  498. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  499. Cmax pgtypes.Cid `json:"cmax"` // cmax
  500. Xmax pgtypes.Xid `json:"xmax"` // xmax
  501. Cmin pgtypes.Cid `json:"cmin"` // cmin
  502. Xmin pgtypes.Xid `json:"xmin"` // xmin
  503. Ctid pgtypes.Tid `json:"ctid"` // ctid
  504. Oid pgtypes.Oid `json:"oid"` // oid
  505. Datname string `json:"datname"` // datname
  506. Datdba pgtypes.Oid `json:"datdba"` // datdba
  507. Encoding int `json:"encoding"` // encoding
  508. Datcollate string `json:"datcollate"` // datcollate
  509. Datctype string `json:"datctype"` // datctype
  510. Datistemplate bool `json:"datistemplate"` // datistemplate
  511. Datallowconn bool `json:"datallowconn"` // datallowconn
  512. Datconnlimit int `json:"datconnlimit"` // datconnlimit
  513. Datlastsysoid pgtypes.Oid `json:"datlastsysoid"` // datlastsysoid
  514. Datfrozenxid pgtypes.Xid `json:"datfrozenxid"` // datfrozenxid
  515. Datminmxid pgtypes.Xid `json:"datminmxid"` // datminmxid
  516. Dattablespace pgtypes.Oid `json:"dattablespace"` // dattablespace
  517. Datacl []pgtypes.NullAclitem `json:"datacl"` // datacl
  518. }
  519. // PgDbRoleSetting represents a row from 'pg_catalog.pg_db_role_setting'.
  520. type PgDbRoleSetting struct {
  521. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  522. Cmax pgtypes.Cid `json:"cmax"` // cmax
  523. Xmax pgtypes.Xid `json:"xmax"` // xmax
  524. Cmin pgtypes.Cid `json:"cmin"` // cmin
  525. Xmin pgtypes.Xid `json:"xmin"` // xmin
  526. Ctid pgtypes.Tid `json:"ctid"` // ctid
  527. Setdatabase pgtypes.Oid `json:"setdatabase"` // setdatabase
  528. Setrole pgtypes.Oid `json:"setrole"` // setrole
  529. Setconfig []sql.NullString `json:"setconfig"` // setconfig
  530. }
  531. // PgDefaultACL represents a row from 'pg_catalog.pg_default_acl'.
  532. type PgDefaultACL struct {
  533. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  534. Cmax pgtypes.Cid `json:"cmax"` // cmax
  535. Xmax pgtypes.Xid `json:"xmax"` // xmax
  536. Cmin pgtypes.Cid `json:"cmin"` // cmin
  537. Xmin pgtypes.Xid `json:"xmin"` // xmin
  538. Ctid pgtypes.Tid `json:"ctid"` // ctid
  539. Oid pgtypes.Oid `json:"oid"` // oid
  540. Defaclrole pgtypes.Oid `json:"defaclrole"` // defaclrole
  541. Defaclnamespace pgtypes.Oid `json:"defaclnamespace"` // defaclnamespace
  542. Defaclobjtype pgtypes.Char `json:"defaclobjtype"` // defaclobjtype
  543. Defaclacl []pgtypes.Aclitem `json:"defaclacl"` // defaclacl
  544. }
  545. // PgDepend represents a row from 'pg_catalog.pg_depend'.
  546. type PgDepend struct {
  547. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  548. Cmax pgtypes.Cid `json:"cmax"` // cmax
  549. Xmax pgtypes.Xid `json:"xmax"` // xmax
  550. Cmin pgtypes.Cid `json:"cmin"` // cmin
  551. Xmin pgtypes.Xid `json:"xmin"` // xmin
  552. Ctid pgtypes.Tid `json:"ctid"` // ctid
  553. Classid pgtypes.Oid `json:"classid"` // classid
  554. Objid pgtypes.Oid `json:"objid"` // objid
  555. Objsubid int `json:"objsubid"` // objsubid
  556. Refclassid pgtypes.Oid `json:"refclassid"` // refclassid
  557. Refobjid pgtypes.Oid `json:"refobjid"` // refobjid
  558. Refobjsubid int `json:"refobjsubid"` // refobjsubid
  559. Deptype pgtypes.Char `json:"deptype"` // deptype
  560. }
  561. // PgDescription represents a row from 'pg_catalog.pg_description'.
  562. type PgDescription struct {
  563. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  564. Cmax pgtypes.Cid `json:"cmax"` // cmax
  565. Xmax pgtypes.Xid `json:"xmax"` // xmax
  566. Cmin pgtypes.Cid `json:"cmin"` // cmin
  567. Xmin pgtypes.Xid `json:"xmin"` // xmin
  568. Ctid pgtypes.Tid `json:"ctid"` // ctid
  569. Objoid pgtypes.Oid `json:"objoid"` // objoid
  570. Classoid pgtypes.Oid `json:"classoid"` // classoid
  571. Objsubid int `json:"objsubid"` // objsubid
  572. Description string `json:"description"` // description
  573. }
  574. // PgEnum represents a row from 'pg_catalog.pg_enum'.
  575. type PgEnum struct {
  576. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  577. Cmax pgtypes.Cid `json:"cmax"` // cmax
  578. Xmax pgtypes.Xid `json:"xmax"` // xmax
  579. Cmin pgtypes.Cid `json:"cmin"` // cmin
  580. Xmin pgtypes.Xid `json:"xmin"` // xmin
  581. Ctid pgtypes.Tid `json:"ctid"` // ctid
  582. Oid pgtypes.Oid `json:"oid"` // oid
  583. Enumtypid pgtypes.Oid `json:"enumtypid"` // enumtypid
  584. Enumsortorder float32 `json:"enumsortorder"` // enumsortorder
  585. Enumlabel string `json:"enumlabel"` // enumlabel
  586. }
  587. // PgEventTrigger represents a row from 'pg_catalog.pg_event_trigger'.
  588. type PgEventTrigger struct {
  589. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  590. Cmax pgtypes.Cid `json:"cmax"` // cmax
  591. Xmax pgtypes.Xid `json:"xmax"` // xmax
  592. Cmin pgtypes.Cid `json:"cmin"` // cmin
  593. Xmin pgtypes.Xid `json:"xmin"` // xmin
  594. Ctid pgtypes.Tid `json:"ctid"` // ctid
  595. Oid pgtypes.Oid `json:"oid"` // oid
  596. Evtname string `json:"evtname"` // evtname
  597. Evtevent string `json:"evtevent"` // evtevent
  598. Evtowner pgtypes.Oid `json:"evtowner"` // evtowner
  599. Evtfoid pgtypes.Oid `json:"evtfoid"` // evtfoid
  600. Evtenabled pgtypes.Char `json:"evtenabled"` // evtenabled
  601. Evttags []sql.NullString `json:"evttags"` // evttags
  602. }
  603. // PgExtension represents a row from 'pg_catalog.pg_extension'.
  604. type PgExtension struct {
  605. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  606. Cmax pgtypes.Cid `json:"cmax"` // cmax
  607. Xmax pgtypes.Xid `json:"xmax"` // xmax
  608. Cmin pgtypes.Cid `json:"cmin"` // cmin
  609. Xmin pgtypes.Xid `json:"xmin"` // xmin
  610. Ctid pgtypes.Tid `json:"ctid"` // ctid
  611. Oid pgtypes.Oid `json:"oid"` // oid
  612. Extname string `json:"extname"` // extname
  613. Extowner pgtypes.Oid `json:"extowner"` // extowner
  614. Extnamespace pgtypes.Oid `json:"extnamespace"` // extnamespace
  615. Extrelocatable bool `json:"extrelocatable"` // extrelocatable
  616. Extversion string `json:"extversion"` // extversion
  617. Extconfig []pgtypes.NullOid `json:"extconfig"` // extconfig
  618. Extcondition []sql.NullString `json:"extcondition"` // extcondition
  619. }
  620. // PgFileSetting represents a row from 'pg_catalog.pg_file_settings'.
  621. type PgFileSetting struct {
  622. Sourcefile sql.NullString `json:"sourcefile"` // sourcefile
  623. Sourceline sql.NullInt64 `json:"sourceline"` // sourceline
  624. Seqno sql.NullInt64 `json:"seqno"` // seqno
  625. Name sql.NullString `json:"name"` // name
  626. Setting sql.NullString `json:"setting"` // setting
  627. Applied sql.NullBool `json:"applied"` // applied
  628. Error sql.NullString `json:"error"` // error
  629. }
  630. // PgForeignDataWrapper represents a row from 'pg_catalog.pg_foreign_data_wrapper'.
  631. type PgForeignDataWrapper struct {
  632. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  633. Cmax pgtypes.Cid `json:"cmax"` // cmax
  634. Xmax pgtypes.Xid `json:"xmax"` // xmax
  635. Cmin pgtypes.Cid `json:"cmin"` // cmin
  636. Xmin pgtypes.Xid `json:"xmin"` // xmin
  637. Ctid pgtypes.Tid `json:"ctid"` // ctid
  638. Oid pgtypes.Oid `json:"oid"` // oid
  639. Fdwname string `json:"fdwname"` // fdwname
  640. Fdwowner pgtypes.Oid `json:"fdwowner"` // fdwowner
  641. Fdwhandler pgtypes.Oid `json:"fdwhandler"` // fdwhandler
  642. Fdwvalidator pgtypes.Oid `json:"fdwvalidator"` // fdwvalidator
  643. Fdwacl []pgtypes.NullAclitem `json:"fdwacl"` // fdwacl
  644. Fdwoptions []sql.NullString `json:"fdwoptions"` // fdwoptions
  645. }
  646. // PgForeignServer represents a row from 'pg_catalog.pg_foreign_server'.
  647. type PgForeignServer struct {
  648. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  649. Cmax pgtypes.Cid `json:"cmax"` // cmax
  650. Xmax pgtypes.Xid `json:"xmax"` // xmax
  651. Cmin pgtypes.Cid `json:"cmin"` // cmin
  652. Xmin pgtypes.Xid `json:"xmin"` // xmin
  653. Ctid pgtypes.Tid `json:"ctid"` // ctid
  654. Oid pgtypes.Oid `json:"oid"` // oid
  655. Srvname string `json:"srvname"` // srvname
  656. Srvowner pgtypes.Oid `json:"srvowner"` // srvowner
  657. Srvfdw pgtypes.Oid `json:"srvfdw"` // srvfdw
  658. Srvtype sql.NullString `json:"srvtype"` // srvtype
  659. Srvversion sql.NullString `json:"srvversion"` // srvversion
  660. Srvacl []pgtypes.NullAclitem `json:"srvacl"` // srvacl
  661. Srvoptions []sql.NullString `json:"srvoptions"` // srvoptions
  662. }
  663. // PgForeignTable represents a row from 'pg_catalog.pg_foreign_table'.
  664. type PgForeignTable struct {
  665. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  666. Cmax pgtypes.Cid `json:"cmax"` // cmax
  667. Xmax pgtypes.Xid `json:"xmax"` // xmax
  668. Cmin pgtypes.Cid `json:"cmin"` // cmin
  669. Xmin pgtypes.Xid `json:"xmin"` // xmin
  670. Ctid pgtypes.Tid `json:"ctid"` // ctid
  671. Ftrelid pgtypes.Oid `json:"ftrelid"` // ftrelid
  672. Ftserver pgtypes.Oid `json:"ftserver"` // ftserver
  673. Ftoptions []sql.NullString `json:"ftoptions"` // ftoptions
  674. }
  675. // PgGroup represents a row from 'pg_catalog.pg_group'.
  676. type PgGroup struct {
  677. Groname sql.NullString `json:"groname"` // groname
  678. Grosysid pgtypes.NullOid `json:"grosysid"` // grosysid
  679. Grolist []pgtypes.NullOid `json:"grolist"` // grolist
  680. }
  681. // PgHbaFileRule represents a row from 'pg_catalog.pg_hba_file_rules'.
  682. type PgHbaFileRule struct {
  683. LineNumber sql.NullInt64 `json:"line_number"` // line_number
  684. Type sql.NullString `json:"type"` // type
  685. Database []sql.NullString `json:"database"` // database
  686. UserName []sql.NullString `json:"user_name"` // user_name
  687. Address sql.NullString `json:"address"` // address
  688. Netmask sql.NullString `json:"netmask"` // netmask
  689. AuthMethod sql.NullString `json:"auth_method"` // auth_method
  690. Options []sql.NullString `json:"options"` // options
  691. Error sql.NullString `json:"error"` // error
  692. }
  693. // PgIndex represents a row from 'pg_catalog.pg_indexes'.
  694. type PgIndex struct {
  695. Schemaname sql.NullString `json:"schemaname"` // schemaname
  696. Tablename sql.NullString `json:"tablename"` // tablename
  697. Indexname sql.NullString `json:"indexname"` // indexname
  698. Tablespace sql.NullString `json:"tablespace"` // tablespace
  699. Indexdef sql.NullString `json:"indexdef"` // indexdef
  700. }
  701. // PgIndex represents a row from 'pg_catalog.pg_index'.
  702. type PgIndex struct {
  703. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  704. Cmax pgtypes.Cid `json:"cmax"` // cmax
  705. Xmax pgtypes.Xid `json:"xmax"` // xmax
  706. Cmin pgtypes.Cid `json:"cmin"` // cmin
  707. Xmin pgtypes.Xid `json:"xmin"` // xmin
  708. Ctid pgtypes.Tid `json:"ctid"` // ctid
  709. Indexrelid pgtypes.Oid `json:"indexrelid"` // indexrelid
  710. Indrelid pgtypes.Oid `json:"indrelid"` // indrelid
  711. Indnatts int16 `json:"indnatts"` // indnatts
  712. Indnkeyatts int16 `json:"indnkeyatts"` // indnkeyatts
  713. Indisunique bool `json:"indisunique"` // indisunique
  714. Indisprimary bool `json:"indisprimary"` // indisprimary
  715. Indisexclusion bool `json:"indisexclusion"` // indisexclusion
  716. Indimmediate bool `json:"indimmediate"` // indimmediate
  717. Indisclustered bool `json:"indisclustered"` // indisclustered
  718. Indisvalid bool `json:"indisvalid"` // indisvalid
  719. Indcheckxmin bool `json:"indcheckxmin"` // indcheckxmin
  720. Indisready bool `json:"indisready"` // indisready
  721. Indislive bool `json:"indislive"` // indislive
  722. Indisreplident bool `json:"indisreplident"` // indisreplident
  723. Indkey pgtypes.Int2vector `json:"indkey"` // indkey
  724. Indcollation pgtypes.Oidvector `json:"indcollation"` // indcollation
  725. Indclass pgtypes.Oidvector `json:"indclass"` // indclass
  726. Indoption pgtypes.Int2vector `json:"indoption"` // indoption
  727. Indexprs pgtypes.NullPgNodeTree `json:"indexprs"` // indexprs
  728. Indpred pgtypes.NullPgNodeTree `json:"indpred"` // indpred
  729. }
  730. // PgInherit represents a row from 'pg_catalog.pg_inherits'.
  731. type PgInherit struct {
  732. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  733. Cmax pgtypes.Cid `json:"cmax"` // cmax
  734. Xmax pgtypes.Xid `json:"xmax"` // xmax
  735. Cmin pgtypes.Cid `json:"cmin"` // cmin
  736. Xmin pgtypes.Xid `json:"xmin"` // xmin
  737. Ctid pgtypes.Tid `json:"ctid"` // ctid
  738. Inhrelid pgtypes.Oid `json:"inhrelid"` // inhrelid
  739. Inhparent pgtypes.Oid `json:"inhparent"` // inhparent
  740. Inhseqno int `json:"inhseqno"` // inhseqno
  741. }
  742. // PgInitPriv represents a row from 'pg_catalog.pg_init_privs'.
  743. type PgInitPriv struct {
  744. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  745. Cmax pgtypes.Cid `json:"cmax"` // cmax
  746. Xmax pgtypes.Xid `json:"xmax"` // xmax
  747. Cmin pgtypes.Cid `json:"cmin"` // cmin
  748. Xmin pgtypes.Xid `json:"xmin"` // xmin
  749. Ctid pgtypes.Tid `json:"ctid"` // ctid
  750. Objoid pgtypes.Oid `json:"objoid"` // objoid
  751. Classoid pgtypes.Oid `json:"classoid"` // classoid
  752. Objsubid int `json:"objsubid"` // objsubid
  753. Privtype pgtypes.Char `json:"privtype"` // privtype
  754. Initprivs []pgtypes.Aclitem `json:"initprivs"` // initprivs
  755. }
  756. // PgLanguage represents a row from 'pg_catalog.pg_language'.
  757. type PgLanguage struct {
  758. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  759. Cmax pgtypes.Cid `json:"cmax"` // cmax
  760. Xmax pgtypes.Xid `json:"xmax"` // xmax
  761. Cmin pgtypes.Cid `json:"cmin"` // cmin
  762. Xmin pgtypes.Xid `json:"xmin"` // xmin
  763. Ctid pgtypes.Tid `json:"ctid"` // ctid
  764. Oid pgtypes.Oid `json:"oid"` // oid
  765. Lanname string `json:"lanname"` // lanname
  766. Lanowner pgtypes.Oid `json:"lanowner"` // lanowner
  767. Lanispl bool `json:"lanispl"` // lanispl
  768. Lanpltrusted bool `json:"lanpltrusted"` // lanpltrusted
  769. Lanplcallfoid pgtypes.Oid `json:"lanplcallfoid"` // lanplcallfoid
  770. Laninline pgtypes.Oid `json:"laninline"` // laninline
  771. Lanvalidator pgtypes.Oid `json:"lanvalidator"` // lanvalidator
  772. Lanacl []pgtypes.NullAclitem `json:"lanacl"` // lanacl
  773. }
  774. // PgLargeobject represents a row from 'pg_catalog.pg_largeobject'.
  775. type PgLargeobject struct {
  776. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  777. Cmax pgtypes.Cid `json:"cmax"` // cmax
  778. Xmax pgtypes.Xid `json:"xmax"` // xmax
  779. Cmin pgtypes.Cid `json:"cmin"` // cmin
  780. Xmin pgtypes.Xid `json:"xmin"` // xmin
  781. Ctid pgtypes.Tid `json:"ctid"` // ctid
  782. Loid pgtypes.Oid `json:"loid"` // loid
  783. Pageno int `json:"pageno"` // pageno
  784. Data []byte `json:"data"` // data
  785. }
  786. // PgLargeobjectMetadatum represents a row from 'pg_catalog.pg_largeobject_metadata'.
  787. type PgLargeobjectMetadatum struct {
  788. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  789. Cmax pgtypes.Cid `json:"cmax"` // cmax
  790. Xmax pgtypes.Xid `json:"xmax"` // xmax
  791. Cmin pgtypes.Cid `json:"cmin"` // cmin
  792. Xmin pgtypes.Xid `json:"xmin"` // xmin
  793. Ctid pgtypes.Tid `json:"ctid"` // ctid
  794. Oid pgtypes.Oid `json:"oid"` // oid
  795. Lomowner pgtypes.Oid `json:"lomowner"` // lomowner
  796. Lomacl []pgtypes.NullAclitem `json:"lomacl"` // lomacl
  797. }
  798. // PgLock represents a row from 'pg_catalog.pg_locks'.
  799. type PgLock struct {
  800. Locktype sql.NullString `json:"locktype"` // locktype
  801. Database pgtypes.NullOid `json:"database"` // database
  802. Relation pgtypes.NullOid `json:"relation"` // relation
  803. Page sql.NullInt64 `json:"page"` // page
  804. Tuple sql.NullInt64 `json:"tuple"` // tuple
  805. Virtualxid sql.NullString `json:"virtualxid"` // virtualxid
  806. Transactionid pgtypes.NullXid `json:"transactionid"` // transactionid
  807. Classid pgtypes.NullOid `json:"classid"` // classid
  808. Objid pgtypes.NullOid `json:"objid"` // objid
  809. Objsubid sql.NullInt64 `json:"objsubid"` // objsubid
  810. Virtualtransaction sql.NullString `json:"virtualtransaction"` // virtualtransaction
  811. Pid sql.NullInt64 `json:"pid"` // pid
  812. Mode sql.NullString `json:"mode"` // mode
  813. Granted sql.NullBool `json:"granted"` // granted
  814. Fastpath sql.NullBool `json:"fastpath"` // fastpath
  815. }
  816. // PgMatview represents a row from 'pg_catalog.pg_matviews'.
  817. type PgMatview struct {
  818. Schemaname sql.NullString `json:"schemaname"` // schemaname
  819. Matviewname sql.NullString `json:"matviewname"` // matviewname
  820. Matviewowner sql.NullString `json:"matviewowner"` // matviewowner
  821. Tablespace sql.NullString `json:"tablespace"` // tablespace
  822. Hasindexes sql.NullBool `json:"hasindexes"` // hasindexes
  823. Ispopulated sql.NullBool `json:"ispopulated"` // ispopulated
  824. Definition sql.NullString `json:"definition"` // definition
  825. }
  826. // PgNamespace represents a row from 'pg_catalog.pg_namespace'.
  827. type PgNamespace struct {
  828. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  829. Cmax pgtypes.Cid `json:"cmax"` // cmax
  830. Xmax pgtypes.Xid `json:"xmax"` // xmax
  831. Cmin pgtypes.Cid `json:"cmin"` // cmin
  832. Xmin pgtypes.Xid `json:"xmin"` // xmin
  833. Ctid pgtypes.Tid `json:"ctid"` // ctid
  834. Oid pgtypes.Oid `json:"oid"` // oid
  835. Nspname string `json:"nspname"` // nspname
  836. Nspowner pgtypes.Oid `json:"nspowner"` // nspowner
  837. Nspacl []pgtypes.NullAclitem `json:"nspacl"` // nspacl
  838. }
  839. // PgOpclass represents a row from 'pg_catalog.pg_opclass'.
  840. type PgOpclass struct {
  841. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  842. Cmax pgtypes.Cid `json:"cmax"` // cmax
  843. Xmax pgtypes.Xid `json:"xmax"` // xmax
  844. Cmin pgtypes.Cid `json:"cmin"` // cmin
  845. Xmin pgtypes.Xid `json:"xmin"` // xmin
  846. Ctid pgtypes.Tid `json:"ctid"` // ctid
  847. Oid pgtypes.Oid `json:"oid"` // oid
  848. Opcmethod pgtypes.Oid `json:"opcmethod"` // opcmethod
  849. Opcname string `json:"opcname"` // opcname
  850. Opcnamespace pgtypes.Oid `json:"opcnamespace"` // opcnamespace
  851. Opcowner pgtypes.Oid `json:"opcowner"` // opcowner
  852. Opcfamily pgtypes.Oid `json:"opcfamily"` // opcfamily
  853. Opcintype pgtypes.Oid `json:"opcintype"` // opcintype
  854. Opcdefault bool `json:"opcdefault"` // opcdefault
  855. Opckeytype pgtypes.Oid `json:"opckeytype"` // opckeytype
  856. }
  857. // PgOperator represents a row from 'pg_catalog.pg_operator'.
  858. type PgOperator struct {
  859. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  860. Cmax pgtypes.Cid `json:"cmax"` // cmax
  861. Xmax pgtypes.Xid `json:"xmax"` // xmax
  862. Cmin pgtypes.Cid `json:"cmin"` // cmin
  863. Xmin pgtypes.Xid `json:"xmin"` // xmin
  864. Ctid pgtypes.Tid `json:"ctid"` // ctid
  865. Oid pgtypes.Oid `json:"oid"` // oid
  866. Oprname string `json:"oprname"` // oprname
  867. Oprnamespace pgtypes.Oid `json:"oprnamespace"` // oprnamespace
  868. Oprowner pgtypes.Oid `json:"oprowner"` // oprowner
  869. Oprkind pgtypes.Char `json:"oprkind"` // oprkind
  870. Oprcanmerge bool `json:"oprcanmerge"` // oprcanmerge
  871. Oprcanhash bool `json:"oprcanhash"` // oprcanhash
  872. Oprleft pgtypes.Oid `json:"oprleft"` // oprleft
  873. Oprright pgtypes.Oid `json:"oprright"` // oprright
  874. Oprresult pgtypes.Oid `json:"oprresult"` // oprresult
  875. Oprcom pgtypes.Oid `json:"oprcom"` // oprcom
  876. Oprnegate pgtypes.Oid `json:"oprnegate"` // oprnegate
  877. Oprcode pgtypes.Regproc `json:"oprcode"` // oprcode
  878. Oprrest pgtypes.Regproc `json:"oprrest"` // oprrest
  879. Oprjoin pgtypes.Regproc `json:"oprjoin"` // oprjoin
  880. }
  881. // PgOpfamily represents a row from 'pg_catalog.pg_opfamily'.
  882. type PgOpfamily struct {
  883. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  884. Cmax pgtypes.Cid `json:"cmax"` // cmax
  885. Xmax pgtypes.Xid `json:"xmax"` // xmax
  886. Cmin pgtypes.Cid `json:"cmin"` // cmin
  887. Xmin pgtypes.Xid `json:"xmin"` // xmin
  888. Ctid pgtypes.Tid `json:"ctid"` // ctid
  889. Oid pgtypes.Oid `json:"oid"` // oid
  890. Opfmethod pgtypes.Oid `json:"opfmethod"` // opfmethod
  891. Opfname string `json:"opfname"` // opfname
  892. Opfnamespace pgtypes.Oid `json:"opfnamespace"` // opfnamespace
  893. Opfowner pgtypes.Oid `json:"opfowner"` // opfowner
  894. }
  895. // PgPartitionedTable represents a row from 'pg_catalog.pg_partitioned_table'.
  896. type PgPartitionedTable struct {
  897. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  898. Cmax pgtypes.Cid `json:"cmax"` // cmax
  899. Xmax pgtypes.Xid `json:"xmax"` // xmax
  900. Cmin pgtypes.Cid `json:"cmin"` // cmin
  901. Xmin pgtypes.Xid `json:"xmin"` // xmin
  902. Ctid pgtypes.Tid `json:"ctid"` // ctid
  903. Partrelid pgtypes.Oid `json:"partrelid"` // partrelid
  904. Partstrat pgtypes.Char `json:"partstrat"` // partstrat
  905. Partnatts int16 `json:"partnatts"` // partnatts
  906. Partdefid pgtypes.Oid `json:"partdefid"` // partdefid
  907. Partattrs pgtypes.Int2vector `json:"partattrs"` // partattrs
  908. Partclass pgtypes.Oidvector `json:"partclass"` // partclass
  909. Partcollation pgtypes.Oidvector `json:"partcollation"` // partcollation
  910. Partexprs pgtypes.NullPgNodeTree `json:"partexprs"` // partexprs
  911. }
  912. // PgPolicy represents a row from 'pg_catalog.pg_policies'.
  913. type PgPolicy struct {
  914. Schemaname sql.NullString `json:"schemaname"` // schemaname
  915. Tablename sql.NullString `json:"tablename"` // tablename
  916. Policyname sql.NullString `json:"policyname"` // policyname
  917. Permissive sql.NullString `json:"permissive"` // permissive
  918. Roles []sql.NullString `json:"roles"` // roles
  919. Cmd sql.NullString `json:"cmd"` // cmd
  920. Qual sql.NullString `json:"qual"` // qual
  921. WithCheck sql.NullString `json:"with_check"` // with_check
  922. }
  923. // PgPolicy represents a row from 'pg_catalog.pg_policy'.
  924. type PgPolicy struct {
  925. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  926. Cmax pgtypes.Cid `json:"cmax"` // cmax
  927. Xmax pgtypes.Xid `json:"xmax"` // xmax
  928. Cmin pgtypes.Cid `json:"cmin"` // cmin
  929. Xmin pgtypes.Xid `json:"xmin"` // xmin
  930. Ctid pgtypes.Tid `json:"ctid"` // ctid
  931. Oid pgtypes.Oid `json:"oid"` // oid
  932. Polname string `json:"polname"` // polname
  933. Polrelid pgtypes.Oid `json:"polrelid"` // polrelid
  934. Polcmd pgtypes.Char `json:"polcmd"` // polcmd
  935. Polpermissive bool `json:"polpermissive"` // polpermissive
  936. Polroles []pgtypes.Oid `json:"polroles"` // polroles
  937. Polqual pgtypes.NullPgNodeTree `json:"polqual"` // polqual
  938. Polwithcheck pgtypes.NullPgNodeTree `json:"polwithcheck"` // polwithcheck
  939. }
  940. // PgPreparedStatement represents a row from 'pg_catalog.pg_prepared_statements'.
  941. type PgPreparedStatement struct {
  942. Name sql.NullString `json:"name"` // name
  943. Statement sql.NullString `json:"statement"` // statement
  944. PrepareTime sql.NullTime `json:"prepare_time"` // prepare_time
  945. ParameterTypes []pgtypes.NullRegtype `json:"parameter_types"` // parameter_types
  946. FromSQL sql.NullBool `json:"from_sql"` // from_sql
  947. }
  948. // PgPreparedXact represents a row from 'pg_catalog.pg_prepared_xacts'.
  949. type PgPreparedXact struct {
  950. Transaction pgtypes.NullXid `json:"transaction"` // transaction
  951. Gid sql.NullString `json:"gid"` // gid
  952. Prepared sql.NullTime `json:"prepared"` // prepared
  953. Owner sql.NullString `json:"owner"` // owner
  954. Database sql.NullString `json:"database"` // database
  955. }
  956. // PgProc represents a row from 'pg_catalog.pg_proc'.
  957. type PgProc struct {
  958. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  959. Cmax pgtypes.Cid `json:"cmax"` // cmax
  960. Xmax pgtypes.Xid `json:"xmax"` // xmax
  961. Cmin pgtypes.Cid `json:"cmin"` // cmin
  962. Xmin pgtypes.Xid `json:"xmin"` // xmin
  963. Ctid pgtypes.Tid `json:"ctid"` // ctid
  964. Oid pgtypes.Oid `json:"oid"` // oid
  965. Proname string `json:"proname"` // proname
  966. Pronamespace pgtypes.Oid `json:"pronamespace"` // pronamespace
  967. Proowner pgtypes.Oid `json:"proowner"` // proowner
  968. Prolang pgtypes.Oid `json:"prolang"` // prolang
  969. Procost float32 `json:"procost"` // procost
  970. Prorows float32 `json:"prorows"` // prorows
  971. Provariadic pgtypes.Oid `json:"provariadic"` // provariadic
  972. Prosupport pgtypes.Regproc `json:"prosupport"` // prosupport
  973. Prokind pgtypes.Char `json:"prokind"` // prokind
  974. Prosecdef bool `json:"prosecdef"` // prosecdef
  975. Proleakproof bool `json:"proleakproof"` // proleakproof
  976. Proisstrict bool `json:"proisstrict"` // proisstrict
  977. Proretset bool `json:"proretset"` // proretset
  978. Provolatile pgtypes.Char `json:"provolatile"` // provolatile
  979. Proparallel pgtypes.Char `json:"proparallel"` // proparallel
  980. Pronargs int16 `json:"pronargs"` // pronargs
  981. Pronargdefaults int16 `json:"pronargdefaults"` // pronargdefaults
  982. Prorettype pgtypes.Oid `json:"prorettype"` // prorettype
  983. Proargtypes pgtypes.Oidvector `json:"proargtypes"` // proargtypes
  984. Proallargtypes []pgtypes.NullOid `json:"proallargtypes"` // proallargtypes
  985. Proargmodes []pgtypes.NullChar `json:"proargmodes"` // proargmodes
  986. Proargnames []sql.NullString `json:"proargnames"` // proargnames
  987. Proargdefaults pgtypes.NullPgNodeTree `json:"proargdefaults"` // proargdefaults
  988. Protrftypes []pgtypes.NullOid `json:"protrftypes"` // protrftypes
  989. Prosrc string `json:"prosrc"` // prosrc
  990. Probin sql.NullString `json:"probin"` // probin
  991. Proconfig []sql.NullString `json:"proconfig"` // proconfig
  992. Proacl []pgtypes.NullAclitem `json:"proacl"` // proacl
  993. }
  994. // PgPublication represents a row from 'pg_catalog.pg_publication'.
  995. type PgPublication struct {
  996. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  997. Cmax pgtypes.Cid `json:"cmax"` // cmax
  998. Xmax pgtypes.Xid `json:"xmax"` // xmax
  999. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1000. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1001. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1002. Oid pgtypes.Oid `json:"oid"` // oid
  1003. Pubname string `json:"pubname"` // pubname
  1004. Pubowner pgtypes.Oid `json:"pubowner"` // pubowner
  1005. Puballtables bool `json:"puballtables"` // puballtables
  1006. Pubinsert bool `json:"pubinsert"` // pubinsert
  1007. Pubupdate bool `json:"pubupdate"` // pubupdate
  1008. Pubdelete bool `json:"pubdelete"` // pubdelete
  1009. Pubtruncate bool `json:"pubtruncate"` // pubtruncate
  1010. Pubviaroot bool `json:"pubviaroot"` // pubviaroot
  1011. }
  1012. // PgPublicationRel represents a row from 'pg_catalog.pg_publication_rel'.
  1013. type PgPublicationRel struct {
  1014. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1015. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1016. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1017. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1018. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1019. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1020. Oid pgtypes.Oid `json:"oid"` // oid
  1021. Prpubid pgtypes.Oid `json:"prpubid"` // prpubid
  1022. Prrelid pgtypes.Oid `json:"prrelid"` // prrelid
  1023. }
  1024. // PgPublicationTable represents a row from 'pg_catalog.pg_publication_tables'.
  1025. type PgPublicationTable struct {
  1026. Pubname sql.NullString `json:"pubname"` // pubname
  1027. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1028. Tablename sql.NullString `json:"tablename"` // tablename
  1029. }
  1030. // PgRange represents a row from 'pg_catalog.pg_range'.
  1031. type PgRange struct {
  1032. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1033. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1034. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1035. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1036. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1037. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1038. Rngtypid pgtypes.Oid `json:"rngtypid"` // rngtypid
  1039. Rngsubtype pgtypes.Oid `json:"rngsubtype"` // rngsubtype
  1040. Rngcollation pgtypes.Oid `json:"rngcollation"` // rngcollation
  1041. Rngsubopc pgtypes.Oid `json:"rngsubopc"` // rngsubopc
  1042. Rngcanonical pgtypes.Regproc `json:"rngcanonical"` // rngcanonical
  1043. Rngsubdiff pgtypes.Regproc `json:"rngsubdiff"` // rngsubdiff
  1044. }
  1045. // PgReplicationOrigin represents a row from 'pg_catalog.pg_replication_origin'.
  1046. type PgReplicationOrigin struct {
  1047. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1048. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1049. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1050. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1051. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1052. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1053. Roident pgtypes.Oid `json:"roident"` // roident
  1054. Roname string `json:"roname"` // roname
  1055. }
  1056. // PgReplicationOriginStatus represents a row from 'pg_catalog.pg_replication_origin_status'.
  1057. type PgReplicationOriginStatus struct {
  1058. LocalID pgtypes.NullOid `json:"local_id"` // local_id
  1059. ExternalID sql.NullString `json:"external_id"` // external_id
  1060. RemoteLsn pgtypes.NullPgLsn `json:"remote_lsn"` // remote_lsn
  1061. LocalLsn pgtypes.NullPgLsn `json:"local_lsn"` // local_lsn
  1062. }
  1063. // PgReplicationSlot represents a row from 'pg_catalog.pg_replication_slots'.
  1064. type PgReplicationSlot struct {
  1065. SlotName sql.NullString `json:"slot_name"` // slot_name
  1066. Plugin sql.NullString `json:"plugin"` // plugin
  1067. SlotType sql.NullString `json:"slot_type"` // slot_type
  1068. Datoid pgtypes.NullOid `json:"datoid"` // datoid
  1069. Database sql.NullString `json:"database"` // database
  1070. Temporary sql.NullBool `json:"temporary"` // temporary
  1071. Active sql.NullBool `json:"active"` // active
  1072. ActivePid sql.NullInt64 `json:"active_pid"` // active_pid
  1073. Xmin pgtypes.NullXid `json:"xmin"` // xmin
  1074. CatalogXmin pgtypes.NullXid `json:"catalog_xmin"` // catalog_xmin
  1075. RestartLsn pgtypes.NullPgLsn `json:"restart_lsn"` // restart_lsn
  1076. ConfirmedFlushLsn pgtypes.NullPgLsn `json:"confirmed_flush_lsn"` // confirmed_flush_lsn
  1077. WalStatus sql.NullString `json:"wal_status"` // wal_status
  1078. SafeWalSize sql.NullInt64 `json:"safe_wal_size"` // safe_wal_size
  1079. }
  1080. // PgRewrite represents a row from 'pg_catalog.pg_rewrite'.
  1081. type PgRewrite struct {
  1082. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1083. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1084. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1085. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1086. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1087. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1088. Oid pgtypes.Oid `json:"oid"` // oid
  1089. Rulename string `json:"rulename"` // rulename
  1090. EvClass pgtypes.Oid `json:"ev_class"` // ev_class
  1091. EvType pgtypes.Char `json:"ev_type"` // ev_type
  1092. EvEnabled pgtypes.Char `json:"ev_enabled"` // ev_enabled
  1093. IsInstead bool `json:"is_instead"` // is_instead
  1094. EvQual pgtypes.PgNodeTree `json:"ev_qual"` // ev_qual
  1095. EvAction pgtypes.PgNodeTree `json:"ev_action"` // ev_action
  1096. }
  1097. // PgRole represents a row from 'pg_catalog.pg_roles'.
  1098. type PgRole struct {
  1099. Rolname sql.NullString `json:"rolname"` // rolname
  1100. Rolsuper sql.NullBool `json:"rolsuper"` // rolsuper
  1101. Rolinherit sql.NullBool `json:"rolinherit"` // rolinherit
  1102. Rolcreaterole sql.NullBool `json:"rolcreaterole"` // rolcreaterole
  1103. Rolcreatedb sql.NullBool `json:"rolcreatedb"` // rolcreatedb
  1104. Rolcanlogin sql.NullBool `json:"rolcanlogin"` // rolcanlogin
  1105. Rolreplication sql.NullBool `json:"rolreplication"` // rolreplication
  1106. Rolconnlimit sql.NullInt64 `json:"rolconnlimit"` // rolconnlimit
  1107. Rolpassword sql.NullString `json:"rolpassword"` // rolpassword
  1108. Rolvaliduntil sql.NullTime `json:"rolvaliduntil"` // rolvaliduntil
  1109. Rolbypassrls sql.NullBool `json:"rolbypassrls"` // rolbypassrls
  1110. Rolconfig []sql.NullString `json:"rolconfig"` // rolconfig
  1111. Oid pgtypes.NullOid `json:"oid"` // oid
  1112. }
  1113. // PgRule represents a row from 'pg_catalog.pg_rules'.
  1114. type PgRule struct {
  1115. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1116. Tablename sql.NullString `json:"tablename"` // tablename
  1117. Rulename sql.NullString `json:"rulename"` // rulename
  1118. Definition sql.NullString `json:"definition"` // definition
  1119. }
  1120. // PgSeclabel represents a row from 'pg_catalog.pg_seclabel'.
  1121. type PgSeclabel struct {
  1122. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1123. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1124. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1125. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1126. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1127. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1128. Objoid pgtypes.Oid `json:"objoid"` // objoid
  1129. Classoid pgtypes.Oid `json:"classoid"` // classoid
  1130. Objsubid int `json:"objsubid"` // objsubid
  1131. Provider string `json:"provider"` // provider
  1132. Label string `json:"label"` // label
  1133. }
  1134. // PgSeclabel represents a row from 'pg_catalog.pg_seclabels'.
  1135. type PgSeclabel struct {
  1136. Objoid pgtypes.NullOid `json:"objoid"` // objoid
  1137. Classoid pgtypes.NullOid `json:"classoid"` // classoid
  1138. Objsubid sql.NullInt64 `json:"objsubid"` // objsubid
  1139. Objtype sql.NullString `json:"objtype"` // objtype
  1140. Objnamespace pgtypes.NullOid `json:"objnamespace"` // objnamespace
  1141. Objname sql.NullString `json:"objname"` // objname
  1142. Provider sql.NullString `json:"provider"` // provider
  1143. Label sql.NullString `json:"label"` // label
  1144. }
  1145. // PgSequence represents a row from 'pg_catalog.pg_sequence'.
  1146. type PgSequence struct {
  1147. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1148. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1149. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1150. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1151. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1152. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1153. Seqrelid pgtypes.Oid `json:"seqrelid"` // seqrelid
  1154. Seqtypid pgtypes.Oid `json:"seqtypid"` // seqtypid
  1155. Seqstart int64 `json:"seqstart"` // seqstart
  1156. Seqincrement int64 `json:"seqincrement"` // seqincrement
  1157. Seqmax int64 `json:"seqmax"` // seqmax
  1158. Seqmin int64 `json:"seqmin"` // seqmin
  1159. Seqcache int64 `json:"seqcache"` // seqcache
  1160. Seqcycle bool `json:"seqcycle"` // seqcycle
  1161. }
  1162. // PgSequence represents a row from 'pg_catalog.pg_sequences'.
  1163. type PgSequence struct {
  1164. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1165. Sequencename sql.NullString `json:"sequencename"` // sequencename
  1166. Sequenceowner sql.NullString `json:"sequenceowner"` // sequenceowner
  1167. DataType pgtypes.NullRegtype `json:"data_type"` // data_type
  1168. StartValue sql.NullInt64 `json:"start_value"` // start_value
  1169. MinValue sql.NullInt64 `json:"min_value"` // min_value
  1170. MaxValue sql.NullInt64 `json:"max_value"` // max_value
  1171. IncrementBy sql.NullInt64 `json:"increment_by"` // increment_by
  1172. Cycle sql.NullBool `json:"cycle"` // cycle
  1173. CacheSize sql.NullInt64 `json:"cache_size"` // cache_size
  1174. LastValue sql.NullInt64 `json:"last_value"` // last_value
  1175. }
  1176. // PgSetting represents a row from 'pg_catalog.pg_settings'.
  1177. type PgSetting struct {
  1178. Name sql.NullString `json:"name"` // name
  1179. Setting sql.NullString `json:"setting"` // setting
  1180. Unit sql.NullString `json:"unit"` // unit
  1181. Category sql.NullString `json:"category"` // category
  1182. ShortDesc sql.NullString `json:"short_desc"` // short_desc
  1183. ExtraDesc sql.NullString `json:"extra_desc"` // extra_desc
  1184. Context sql.NullString `json:"context"` // context
  1185. Vartype sql.NullString `json:"vartype"` // vartype
  1186. Source sql.NullString `json:"source"` // source
  1187. MinVal sql.NullString `json:"min_val"` // min_val
  1188. MaxVal sql.NullString `json:"max_val"` // max_val
  1189. Enumvals []sql.NullString `json:"enumvals"` // enumvals
  1190. BootVal sql.NullString `json:"boot_val"` // boot_val
  1191. ResetVal sql.NullString `json:"reset_val"` // reset_val
  1192. Sourcefile sql.NullString `json:"sourcefile"` // sourcefile
  1193. Sourceline sql.NullInt64 `json:"sourceline"` // sourceline
  1194. PendingRestart sql.NullBool `json:"pending_restart"` // pending_restart
  1195. }
  1196. // PgShadow represents a row from 'pg_catalog.pg_shadow'.
  1197. type PgShadow struct {
  1198. Usename sql.NullString `json:"usename"` // usename
  1199. Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
  1200. Usecreatedb sql.NullBool `json:"usecreatedb"` // usecreatedb
  1201. Usesuper sql.NullBool `json:"usesuper"` // usesuper
  1202. Userepl sql.NullBool `json:"userepl"` // userepl
  1203. Usebypassrls sql.NullBool `json:"usebypassrls"` // usebypassrls
  1204. Passwd sql.NullString `json:"passwd"` // passwd
  1205. Valuntil sql.NullTime `json:"valuntil"` // valuntil
  1206. Useconfig []sql.NullString `json:"useconfig"` // useconfig
  1207. }
  1208. // PgShdepend represents a row from 'pg_catalog.pg_shdepend'.
  1209. type PgShdepend struct {
  1210. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1211. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1212. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1213. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1214. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1215. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1216. Dbid pgtypes.Oid `json:"dbid"` // dbid
  1217. Classid pgtypes.Oid `json:"classid"` // classid
  1218. Objid pgtypes.Oid `json:"objid"` // objid
  1219. Objsubid int `json:"objsubid"` // objsubid
  1220. Refclassid pgtypes.Oid `json:"refclassid"` // refclassid
  1221. Refobjid pgtypes.Oid `json:"refobjid"` // refobjid
  1222. Deptype pgtypes.Char `json:"deptype"` // deptype
  1223. }
  1224. // PgShdescription represents a row from 'pg_catalog.pg_shdescription'.
  1225. type PgShdescription struct {
  1226. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1227. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1228. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1229. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1230. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1231. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1232. Objoid pgtypes.Oid `json:"objoid"` // objoid
  1233. Classoid pgtypes.Oid `json:"classoid"` // classoid
  1234. Description string `json:"description"` // description
  1235. }
  1236. // PgShmemAllocation represents a row from 'pg_catalog.pg_shmem_allocations'.
  1237. type PgShmemAllocation struct {
  1238. Name sql.NullString `json:"name"` // name
  1239. Off sql.NullInt64 `json:"off"` // off
  1240. Size sql.NullInt64 `json:"size"` // size
  1241. AllocatedSize sql.NullInt64 `json:"allocated_size"` // allocated_size
  1242. }
  1243. // PgShseclabel represents a row from 'pg_catalog.pg_shseclabel'.
  1244. type PgShseclabel struct {
  1245. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1246. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1247. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1248. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1249. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1250. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1251. Objoid pgtypes.Oid `json:"objoid"` // objoid
  1252. Classoid pgtypes.Oid `json:"classoid"` // classoid
  1253. Provider string `json:"provider"` // provider
  1254. Label string `json:"label"` // label
  1255. }
  1256. // PgStat represents a row from 'pg_catalog.pg_stats'.
  1257. type PgStat struct {
  1258. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1259. Tablename sql.NullString `json:"tablename"` // tablename
  1260. Attname sql.NullString `json:"attname"` // attname
  1261. Inherited sql.NullBool `json:"inherited"` // inherited
  1262. NullFrac sql.NullFloat64 `json:"null_frac"` // null_frac
  1263. AvgWidth sql.NullInt64 `json:"avg_width"` // avg_width
  1264. NDistinct sql.NullFloat64 `json:"n_distinct"` // n_distinct
  1265. MostCommonVals pgtypes.NullAnyarray `json:"most_common_vals"` // most_common_vals
  1266. MostCommonFreqs []sql.NullFloat64 `json:"most_common_freqs"` // most_common_freqs
  1267. HistogramBounds pgtypes.NullAnyarray `json:"histogram_bounds"` // histogram_bounds
  1268. Correlation sql.NullFloat64 `json:"correlation"` // correlation
  1269. MostCommonElems pgtypes.NullAnyarray `json:"most_common_elems"` // most_common_elems
  1270. MostCommonElemFreqs []sql.NullFloat64 `json:"most_common_elem_freqs"` // most_common_elem_freqs
  1271. ElemCountHistogram []sql.NullFloat64 `json:"elem_count_histogram"` // elem_count_histogram
  1272. }
  1273. // PgStatActivity represents a row from 'pg_catalog.pg_stat_activity'.
  1274. type PgStatActivity struct {
  1275. Datid pgtypes.NullOid `json:"datid"` // datid
  1276. Datname sql.NullString `json:"datname"` // datname
  1277. Pid sql.NullInt64 `json:"pid"` // pid
  1278. LeaderPid sql.NullInt64 `json:"leader_pid"` // leader_pid
  1279. Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
  1280. Usename sql.NullString `json:"usename"` // usename
  1281. ApplicationName sql.NullString `json:"application_name"` // application_name
  1282. ClientAddr sql.NullString `json:"client_addr"` // client_addr
  1283. ClientHostname sql.NullString `json:"client_hostname"` // client_hostname
  1284. ClientPort sql.NullInt64 `json:"client_port"` // client_port
  1285. BackendStart sql.NullTime `json:"backend_start"` // backend_start
  1286. XactStart sql.NullTime `json:"xact_start"` // xact_start
  1287. QueryStart sql.NullTime `json:"query_start"` // query_start
  1288. StateChange sql.NullTime `json:"state_change"` // state_change
  1289. WaitEventType sql.NullString `json:"wait_event_type"` // wait_event_type
  1290. WaitEvent sql.NullString `json:"wait_event"` // wait_event
  1291. State sql.NullString `json:"state"` // state
  1292. BackendXid pgtypes.NullXid `json:"backend_xid"` // backend_xid
  1293. BackendXmin pgtypes.NullXid `json:"backend_xmin"` // backend_xmin
  1294. Query sql.NullString `json:"query"` // query
  1295. BackendType sql.NullString `json:"backend_type"` // backend_type
  1296. }
  1297. // PgStatAllIndex represents a row from 'pg_catalog.pg_stat_all_indexes'.
  1298. type PgStatAllIndex struct {
  1299. Relid pgtypes.NullOid `json:"relid"` // relid
  1300. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1301. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1302. Relname sql.NullString `json:"relname"` // relname
  1303. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1304. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1305. IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
  1306. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1307. }
  1308. // PgStatAllTable represents a row from 'pg_catalog.pg_stat_all_tables'.
  1309. type PgStatAllTable struct {
  1310. Relid pgtypes.NullOid `json:"relid"` // relid
  1311. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1312. Relname sql.NullString `json:"relname"` // relname
  1313. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1314. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1315. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1316. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1317. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1318. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1319. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1320. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1321. NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
  1322. NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
  1323. NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
  1324. NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
  1325. LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
  1326. LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
  1327. LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
  1328. LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
  1329. VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
  1330. AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
  1331. AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
  1332. AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
  1333. }
  1334. // PgStatArchiver represents a row from 'pg_catalog.pg_stat_archiver'.
  1335. type PgStatArchiver struct {
  1336. ArchivedCount sql.NullInt64 `json:"archived_count"` // archived_count
  1337. LastArchivedWal sql.NullString `json:"last_archived_wal"` // last_archived_wal
  1338. LastArchivedTime sql.NullTime `json:"last_archived_time"` // last_archived_time
  1339. FailedCount sql.NullInt64 `json:"failed_count"` // failed_count
  1340. LastFailedWal sql.NullString `json:"last_failed_wal"` // last_failed_wal
  1341. LastFailedTime sql.NullTime `json:"last_failed_time"` // last_failed_time
  1342. StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
  1343. }
  1344. // PgStatBgwriter represents a row from 'pg_catalog.pg_stat_bgwriter'.
  1345. type PgStatBgwriter struct {
  1346. CheckpointsTimed sql.NullInt64 `json:"checkpoints_timed"` // checkpoints_timed
  1347. CheckpointsReq sql.NullInt64 `json:"checkpoints_req"` // checkpoints_req
  1348. CheckpointWriteTime sql.NullFloat64 `json:"checkpoint_write_time"` // checkpoint_write_time
  1349. CheckpointSyncTime sql.NullFloat64 `json:"checkpoint_sync_time"` // checkpoint_sync_time
  1350. BuffersCheckpoint sql.NullInt64 `json:"buffers_checkpoint"` // buffers_checkpoint
  1351. BuffersClean sql.NullInt64 `json:"buffers_clean"` // buffers_clean
  1352. MaxwrittenClean sql.NullInt64 `json:"maxwritten_clean"` // maxwritten_clean
  1353. BuffersBackend sql.NullInt64 `json:"buffers_backend"` // buffers_backend
  1354. BuffersBackendFsync sql.NullInt64 `json:"buffers_backend_fsync"` // buffers_backend_fsync
  1355. BuffersAlloc sql.NullInt64 `json:"buffers_alloc"` // buffers_alloc
  1356. StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
  1357. }
  1358. // PgStatDatabase represents a row from 'pg_catalog.pg_stat_database'.
  1359. type PgStatDatabase struct {
  1360. Datid pgtypes.NullOid `json:"datid"` // datid
  1361. Datname sql.NullString `json:"datname"` // datname
  1362. Numbackends sql.NullInt64 `json:"numbackends"` // numbackends
  1363. XactCommit sql.NullInt64 `json:"xact_commit"` // xact_commit
  1364. XactRollback sql.NullInt64 `json:"xact_rollback"` // xact_rollback
  1365. BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
  1366. BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
  1367. TupReturned sql.NullInt64 `json:"tup_returned"` // tup_returned
  1368. TupFetched sql.NullInt64 `json:"tup_fetched"` // tup_fetched
  1369. TupInserted sql.NullInt64 `json:"tup_inserted"` // tup_inserted
  1370. TupUpdated sql.NullInt64 `json:"tup_updated"` // tup_updated
  1371. TupDeleted sql.NullInt64 `json:"tup_deleted"` // tup_deleted
  1372. Conflicts sql.NullInt64 `json:"conflicts"` // conflicts
  1373. TempFiles sql.NullInt64 `json:"temp_files"` // temp_files
  1374. TempBytes sql.NullInt64 `json:"temp_bytes"` // temp_bytes
  1375. Deadlocks sql.NullInt64 `json:"deadlocks"` // deadlocks
  1376. ChecksumFailures sql.NullInt64 `json:"checksum_failures"` // checksum_failures
  1377. ChecksumLastFailure sql.NullTime `json:"checksum_last_failure"` // checksum_last_failure
  1378. BlkReadTime sql.NullFloat64 `json:"blk_read_time"` // blk_read_time
  1379. BlkWriteTime sql.NullFloat64 `json:"blk_write_time"` // blk_write_time
  1380. StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
  1381. }
  1382. // PgStatDatabaseConflict represents a row from 'pg_catalog.pg_stat_database_conflicts'.
  1383. type PgStatDatabaseConflict struct {
  1384. Datid pgtypes.NullOid `json:"datid"` // datid
  1385. Datname sql.NullString `json:"datname"` // datname
  1386. ConflTablespace sql.NullInt64 `json:"confl_tablespace"` // confl_tablespace
  1387. ConflLock sql.NullInt64 `json:"confl_lock"` // confl_lock
  1388. ConflSnapshot sql.NullInt64 `json:"confl_snapshot"` // confl_snapshot
  1389. ConflBufferpin sql.NullInt64 `json:"confl_bufferpin"` // confl_bufferpin
  1390. ConflDeadlock sql.NullInt64 `json:"confl_deadlock"` // confl_deadlock
  1391. }
  1392. // PgStatGssapi represents a row from 'pg_catalog.pg_stat_gssapi'.
  1393. type PgStatGssapi struct {
  1394. Pid sql.NullInt64 `json:"pid"` // pid
  1395. GssAuthenticated sql.NullBool `json:"gss_authenticated"` // gss_authenticated
  1396. Principal sql.NullString `json:"principal"` // principal
  1397. Encrypted sql.NullBool `json:"encrypted"` // encrypted
  1398. }
  1399. // PgStatProgressAnalyze represents a row from 'pg_catalog.pg_stat_progress_analyze'.
  1400. type PgStatProgressAnalyze struct {
  1401. Pid sql.NullInt64 `json:"pid"` // pid
  1402. Datid pgtypes.NullOid `json:"datid"` // datid
  1403. Datname sql.NullString `json:"datname"` // datname
  1404. Relid pgtypes.NullOid `json:"relid"` // relid
  1405. Phase sql.NullString `json:"phase"` // phase
  1406. SampleBlksTotal sql.NullInt64 `json:"sample_blks_total"` // sample_blks_total
  1407. SampleBlksScanned sql.NullInt64 `json:"sample_blks_scanned"` // sample_blks_scanned
  1408. ExtStatsTotal sql.NullInt64 `json:"ext_stats_total"` // ext_stats_total
  1409. ExtStatsComputed sql.NullInt64 `json:"ext_stats_computed"` // ext_stats_computed
  1410. ChildTablesTotal sql.NullInt64 `json:"child_tables_total"` // child_tables_total
  1411. ChildTablesDone sql.NullInt64 `json:"child_tables_done"` // child_tables_done
  1412. CurrentChildTableRelid pgtypes.NullOid `json:"current_child_table_relid"` // current_child_table_relid
  1413. }
  1414. // PgStatProgressBasebackup represents a row from 'pg_catalog.pg_stat_progress_basebackup'.
  1415. type PgStatProgressBasebackup struct {
  1416. Pid sql.NullInt64 `json:"pid"` // pid
  1417. Phase sql.NullString `json:"phase"` // phase
  1418. BackupTotal sql.NullInt64 `json:"backup_total"` // backup_total
  1419. BackupStreamed sql.NullInt64 `json:"backup_streamed"` // backup_streamed
  1420. TablespacesTotal sql.NullInt64 `json:"tablespaces_total"` // tablespaces_total
  1421. TablespacesStreamed sql.NullInt64 `json:"tablespaces_streamed"` // tablespaces_streamed
  1422. }
  1423. // PgStatProgressCluster represents a row from 'pg_catalog.pg_stat_progress_cluster'.
  1424. type PgStatProgressCluster struct {
  1425. Pid sql.NullInt64 `json:"pid"` // pid
  1426. Datid pgtypes.NullOid `json:"datid"` // datid
  1427. Datname sql.NullString `json:"datname"` // datname
  1428. Relid pgtypes.NullOid `json:"relid"` // relid
  1429. Command sql.NullString `json:"command"` // command
  1430. Phase sql.NullString `json:"phase"` // phase
  1431. ClusterIndexRelid pgtypes.NullOid `json:"cluster_index_relid"` // cluster_index_relid
  1432. HeapTuplesScanned sql.NullInt64 `json:"heap_tuples_scanned"` // heap_tuples_scanned
  1433. HeapTuplesWritten sql.NullInt64 `json:"heap_tuples_written"` // heap_tuples_written
  1434. HeapBlksTotal sql.NullInt64 `json:"heap_blks_total"` // heap_blks_total
  1435. HeapBlksScanned sql.NullInt64 `json:"heap_blks_scanned"` // heap_blks_scanned
  1436. IndexRebuildCount sql.NullInt64 `json:"index_rebuild_count"` // index_rebuild_count
  1437. }
  1438. // PgStatProgressCreateIndex represents a row from 'pg_catalog.pg_stat_progress_create_index'.
  1439. type PgStatProgressCreateIndex struct {
  1440. Pid sql.NullInt64 `json:"pid"` // pid
  1441. Datid pgtypes.NullOid `json:"datid"` // datid
  1442. Datname sql.NullString `json:"datname"` // datname
  1443. Relid pgtypes.NullOid `json:"relid"` // relid
  1444. IndexRelid pgtypes.NullOid `json:"index_relid"` // index_relid
  1445. Command sql.NullString `json:"command"` // command
  1446. Phase sql.NullString `json:"phase"` // phase
  1447. LockersTotal sql.NullInt64 `json:"lockers_total"` // lockers_total
  1448. LockersDone sql.NullInt64 `json:"lockers_done"` // lockers_done
  1449. CurrentLockerPid sql.NullInt64 `json:"current_locker_pid"` // current_locker_pid
  1450. BlocksTotal sql.NullInt64 `json:"blocks_total"` // blocks_total
  1451. BlocksDone sql.NullInt64 `json:"blocks_done"` // blocks_done
  1452. TuplesTotal sql.NullInt64 `json:"tuples_total"` // tuples_total
  1453. TuplesDone sql.NullInt64 `json:"tuples_done"` // tuples_done
  1454. PartitionsTotal sql.NullInt64 `json:"partitions_total"` // partitions_total
  1455. PartitionsDone sql.NullInt64 `json:"partitions_done"` // partitions_done
  1456. }
  1457. // PgStatProgressVacuum represents a row from 'pg_catalog.pg_stat_progress_vacuum'.
  1458. type PgStatProgressVacuum struct {
  1459. Pid sql.NullInt64 `json:"pid"` // pid
  1460. Datid pgtypes.NullOid `json:"datid"` // datid
  1461. Datname sql.NullString `json:"datname"` // datname
  1462. Relid pgtypes.NullOid `json:"relid"` // relid
  1463. Phase sql.NullString `json:"phase"` // phase
  1464. HeapBlksTotal sql.NullInt64 `json:"heap_blks_total"` // heap_blks_total
  1465. HeapBlksScanned sql.NullInt64 `json:"heap_blks_scanned"` // heap_blks_scanned
  1466. HeapBlksVacuumed sql.NullInt64 `json:"heap_blks_vacuumed"` // heap_blks_vacuumed
  1467. IndexVacuumCount sql.NullInt64 `json:"index_vacuum_count"` // index_vacuum_count
  1468. MaxDeadTuples sql.NullInt64 `json:"max_dead_tuples"` // max_dead_tuples
  1469. NumDeadTuples sql.NullInt64 `json:"num_dead_tuples"` // num_dead_tuples
  1470. }
  1471. // PgStatReplication represents a row from 'pg_catalog.pg_stat_replication'.
  1472. type PgStatReplication struct {
  1473. Pid sql.NullInt64 `json:"pid"` // pid
  1474. Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
  1475. Usename sql.NullString `json:"usename"` // usename
  1476. ApplicationName sql.NullString `json:"application_name"` // application_name
  1477. ClientAddr sql.NullString `json:"client_addr"` // client_addr
  1478. ClientHostname sql.NullString `json:"client_hostname"` // client_hostname
  1479. ClientPort sql.NullInt64 `json:"client_port"` // client_port
  1480. BackendStart sql.NullTime `json:"backend_start"` // backend_start
  1481. BackendXmin pgtypes.NullXid `json:"backend_xmin"` // backend_xmin
  1482. State sql.NullString `json:"state"` // state
  1483. SentLsn pgtypes.NullPgLsn `json:"sent_lsn"` // sent_lsn
  1484. WriteLsn pgtypes.NullPgLsn `json:"write_lsn"` // write_lsn
  1485. FlushLsn pgtypes.NullPgLsn `json:"flush_lsn"` // flush_lsn
  1486. ReplayLsn pgtypes.NullPgLsn `json:"replay_lsn"` // replay_lsn
  1487. WriteLag []byte `json:"write_lag"` // write_lag
  1488. FlushLag []byte `json:"flush_lag"` // flush_lag
  1489. ReplayLag []byte `json:"replay_lag"` // replay_lag
  1490. SyncPriority sql.NullInt64 `json:"sync_priority"` // sync_priority
  1491. SyncState sql.NullString `json:"sync_state"` // sync_state
  1492. ReplyTime sql.NullTime `json:"reply_time"` // reply_time
  1493. }
  1494. // PgStatSlru represents a row from 'pg_catalog.pg_stat_slru'.
  1495. type PgStatSlru struct {
  1496. Name sql.NullString `json:"name"` // name
  1497. BlksZeroed sql.NullInt64 `json:"blks_zeroed"` // blks_zeroed
  1498. BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
  1499. BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
  1500. BlksWritten sql.NullInt64 `json:"blks_written"` // blks_written
  1501. BlksExists sql.NullInt64 `json:"blks_exists"` // blks_exists
  1502. Flushes sql.NullInt64 `json:"flushes"` // flushes
  1503. Truncates sql.NullInt64 `json:"truncates"` // truncates
  1504. StatsReset sql.NullTime `json:"stats_reset"` // stats_reset
  1505. }
  1506. // PgStatSsl represents a row from 'pg_catalog.pg_stat_ssl'.
  1507. type PgStatSsl struct {
  1508. Pid sql.NullInt64 `json:"pid"` // pid
  1509. Ssl sql.NullBool `json:"ssl"` // ssl
  1510. Version sql.NullString `json:"version"` // version
  1511. Cipher sql.NullString `json:"cipher"` // cipher
  1512. Bits sql.NullInt64 `json:"bits"` // bits
  1513. Compression sql.NullBool `json:"compression"` // compression
  1514. ClientDn sql.NullString `json:"client_dn"` // client_dn
  1515. ClientSerial sql.NullFloat64 `json:"client_serial"` // client_serial
  1516. IssuerDn sql.NullString `json:"issuer_dn"` // issuer_dn
  1517. }
  1518. // PgStatSubscription represents a row from 'pg_catalog.pg_stat_subscription'.
  1519. type PgStatSubscription struct {
  1520. Subid pgtypes.NullOid `json:"subid"` // subid
  1521. Subname sql.NullString `json:"subname"` // subname
  1522. Pid sql.NullInt64 `json:"pid"` // pid
  1523. Relid pgtypes.NullOid `json:"relid"` // relid
  1524. ReceivedLsn pgtypes.NullPgLsn `json:"received_lsn"` // received_lsn
  1525. LastMsgSendTime sql.NullTime `json:"last_msg_send_time"` // last_msg_send_time
  1526. LastMsgReceiptTime sql.NullTime `json:"last_msg_receipt_time"` // last_msg_receipt_time
  1527. LatestEndLsn pgtypes.NullPgLsn `json:"latest_end_lsn"` // latest_end_lsn
  1528. LatestEndTime sql.NullTime `json:"latest_end_time"` // latest_end_time
  1529. }
  1530. // PgStatSysIndex represents a row from 'pg_catalog.pg_stat_sys_indexes'.
  1531. type PgStatSysIndex struct {
  1532. Relid pgtypes.NullOid `json:"relid"` // relid
  1533. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1534. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1535. Relname sql.NullString `json:"relname"` // relname
  1536. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1537. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1538. IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
  1539. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1540. }
  1541. // PgStatSysTable represents a row from 'pg_catalog.pg_stat_sys_tables'.
  1542. type PgStatSysTable struct {
  1543. Relid pgtypes.NullOid `json:"relid"` // relid
  1544. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1545. Relname sql.NullString `json:"relname"` // relname
  1546. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1547. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1548. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1549. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1550. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1551. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1552. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1553. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1554. NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
  1555. NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
  1556. NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
  1557. NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
  1558. LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
  1559. LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
  1560. LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
  1561. LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
  1562. VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
  1563. AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
  1564. AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
  1565. AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
  1566. }
  1567. // PgStatUserFunction represents a row from 'pg_catalog.pg_stat_user_functions'.
  1568. type PgStatUserFunction struct {
  1569. Funcid pgtypes.NullOid `json:"funcid"` // funcid
  1570. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1571. Funcname sql.NullString `json:"funcname"` // funcname
  1572. Calls sql.NullInt64 `json:"calls"` // calls
  1573. TotalTime sql.NullFloat64 `json:"total_time"` // total_time
  1574. SelfTime sql.NullFloat64 `json:"self_time"` // self_time
  1575. }
  1576. // PgStatUserIndex represents a row from 'pg_catalog.pg_stat_user_indexes'.
  1577. type PgStatUserIndex struct {
  1578. Relid pgtypes.NullOid `json:"relid"` // relid
  1579. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1580. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1581. Relname sql.NullString `json:"relname"` // relname
  1582. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1583. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1584. IdxTupRead sql.NullInt64 `json:"idx_tup_read"` // idx_tup_read
  1585. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1586. }
  1587. // PgStatUserTable represents a row from 'pg_catalog.pg_stat_user_tables'.
  1588. type PgStatUserTable struct {
  1589. Relid pgtypes.NullOid `json:"relid"` // relid
  1590. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1591. Relname sql.NullString `json:"relname"` // relname
  1592. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1593. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1594. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1595. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1596. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1597. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1598. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1599. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1600. NLiveTup sql.NullInt64 `json:"n_live_tup"` // n_live_tup
  1601. NDeadTup sql.NullInt64 `json:"n_dead_tup"` // n_dead_tup
  1602. NModSinceAnalyze sql.NullInt64 `json:"n_mod_since_analyze"` // n_mod_since_analyze
  1603. NInsSinceVacuum sql.NullInt64 `json:"n_ins_since_vacuum"` // n_ins_since_vacuum
  1604. LastVacuum sql.NullTime `json:"last_vacuum"` // last_vacuum
  1605. LastAutovacuum sql.NullTime `json:"last_autovacuum"` // last_autovacuum
  1606. LastAnalyze sql.NullTime `json:"last_analyze"` // last_analyze
  1607. LastAutoanalyze sql.NullTime `json:"last_autoanalyze"` // last_autoanalyze
  1608. VacuumCount sql.NullInt64 `json:"vacuum_count"` // vacuum_count
  1609. AutovacuumCount sql.NullInt64 `json:"autovacuum_count"` // autovacuum_count
  1610. AnalyzeCount sql.NullInt64 `json:"analyze_count"` // analyze_count
  1611. AutoanalyzeCount sql.NullInt64 `json:"autoanalyze_count"` // autoanalyze_count
  1612. }
  1613. // PgStatWalReceiver represents a row from 'pg_catalog.pg_stat_wal_receiver'.
  1614. type PgStatWalReceiver struct {
  1615. Pid sql.NullInt64 `json:"pid"` // pid
  1616. Status sql.NullString `json:"status"` // status
  1617. ReceiveStartLsn pgtypes.NullPgLsn `json:"receive_start_lsn"` // receive_start_lsn
  1618. ReceiveStartTli sql.NullInt64 `json:"receive_start_tli"` // receive_start_tli
  1619. WrittenLsn pgtypes.NullPgLsn `json:"written_lsn"` // written_lsn
  1620. FlushedLsn pgtypes.NullPgLsn `json:"flushed_lsn"` // flushed_lsn
  1621. ReceivedTli sql.NullInt64 `json:"received_tli"` // received_tli
  1622. LastMsgSendTime sql.NullTime `json:"last_msg_send_time"` // last_msg_send_time
  1623. LastMsgReceiptTime sql.NullTime `json:"last_msg_receipt_time"` // last_msg_receipt_time
  1624. LatestEndLsn pgtypes.NullPgLsn `json:"latest_end_lsn"` // latest_end_lsn
  1625. LatestEndTime sql.NullTime `json:"latest_end_time"` // latest_end_time
  1626. SlotName sql.NullString `json:"slot_name"` // slot_name
  1627. SenderHost sql.NullString `json:"sender_host"` // sender_host
  1628. SenderPort sql.NullInt64 `json:"sender_port"` // sender_port
  1629. Conninfo sql.NullString `json:"conninfo"` // conninfo
  1630. }
  1631. // PgStatXactAllTable represents a row from 'pg_catalog.pg_stat_xact_all_tables'.
  1632. type PgStatXactAllTable struct {
  1633. Relid pgtypes.NullOid `json:"relid"` // relid
  1634. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1635. Relname sql.NullString `json:"relname"` // relname
  1636. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1637. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1638. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1639. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1640. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1641. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1642. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1643. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1644. }
  1645. // PgStatXactSysTable represents a row from 'pg_catalog.pg_stat_xact_sys_tables'.
  1646. type PgStatXactSysTable struct {
  1647. Relid pgtypes.NullOid `json:"relid"` // relid
  1648. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1649. Relname sql.NullString `json:"relname"` // relname
  1650. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1651. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1652. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1653. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1654. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1655. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1656. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1657. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1658. }
  1659. // PgStatXactUserFunction represents a row from 'pg_catalog.pg_stat_xact_user_functions'.
  1660. type PgStatXactUserFunction struct {
  1661. Funcid pgtypes.NullOid `json:"funcid"` // funcid
  1662. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1663. Funcname sql.NullString `json:"funcname"` // funcname
  1664. Calls sql.NullInt64 `json:"calls"` // calls
  1665. TotalTime sql.NullFloat64 `json:"total_time"` // total_time
  1666. SelfTime sql.NullFloat64 `json:"self_time"` // self_time
  1667. }
  1668. // PgStatXactUserTable represents a row from 'pg_catalog.pg_stat_xact_user_tables'.
  1669. type PgStatXactUserTable struct {
  1670. Relid pgtypes.NullOid `json:"relid"` // relid
  1671. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1672. Relname sql.NullString `json:"relname"` // relname
  1673. SeqScan sql.NullInt64 `json:"seq_scan"` // seq_scan
  1674. SeqTupRead sql.NullInt64 `json:"seq_tup_read"` // seq_tup_read
  1675. IdxScan sql.NullInt64 `json:"idx_scan"` // idx_scan
  1676. IdxTupFetch sql.NullInt64 `json:"idx_tup_fetch"` // idx_tup_fetch
  1677. NTupIns sql.NullInt64 `json:"n_tup_ins"` // n_tup_ins
  1678. NTupUpd sql.NullInt64 `json:"n_tup_upd"` // n_tup_upd
  1679. NTupDel sql.NullInt64 `json:"n_tup_del"` // n_tup_del
  1680. NTupHotUpd sql.NullInt64 `json:"n_tup_hot_upd"` // n_tup_hot_upd
  1681. }
  1682. // PgStatioAllIndex represents a row from 'pg_catalog.pg_statio_all_indexes'.
  1683. type PgStatioAllIndex struct {
  1684. Relid pgtypes.NullOid `json:"relid"` // relid
  1685. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1686. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1687. Relname sql.NullString `json:"relname"` // relname
  1688. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1689. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1690. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1691. }
  1692. // PgStatioAllSequence represents a row from 'pg_catalog.pg_statio_all_sequences'.
  1693. type PgStatioAllSequence struct {
  1694. Relid pgtypes.NullOid `json:"relid"` // relid
  1695. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1696. Relname sql.NullString `json:"relname"` // relname
  1697. BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
  1698. BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
  1699. }
  1700. // PgStatioAllTable represents a row from 'pg_catalog.pg_statio_all_tables'.
  1701. type PgStatioAllTable struct {
  1702. Relid pgtypes.NullOid `json:"relid"` // relid
  1703. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1704. Relname sql.NullString `json:"relname"` // relname
  1705. HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
  1706. HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
  1707. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1708. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1709. ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
  1710. ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
  1711. TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
  1712. TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
  1713. }
  1714. // PgStatioSysIndex represents a row from 'pg_catalog.pg_statio_sys_indexes'.
  1715. type PgStatioSysIndex struct {
  1716. Relid pgtypes.NullOid `json:"relid"` // relid
  1717. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1718. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1719. Relname sql.NullString `json:"relname"` // relname
  1720. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1721. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1722. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1723. }
  1724. // PgStatioSysSequence represents a row from 'pg_catalog.pg_statio_sys_sequences'.
  1725. type PgStatioSysSequence struct {
  1726. Relid pgtypes.NullOid `json:"relid"` // relid
  1727. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1728. Relname sql.NullString `json:"relname"` // relname
  1729. BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
  1730. BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
  1731. }
  1732. // PgStatioSysTable represents a row from 'pg_catalog.pg_statio_sys_tables'.
  1733. type PgStatioSysTable struct {
  1734. Relid pgtypes.NullOid `json:"relid"` // relid
  1735. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1736. Relname sql.NullString `json:"relname"` // relname
  1737. HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
  1738. HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
  1739. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1740. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1741. ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
  1742. ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
  1743. TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
  1744. TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
  1745. }
  1746. // PgStatioUserIndex represents a row from 'pg_catalog.pg_statio_user_indexes'.
  1747. type PgStatioUserIndex struct {
  1748. Relid pgtypes.NullOid `json:"relid"` // relid
  1749. Indexrelid pgtypes.NullOid `json:"indexrelid"` // indexrelid
  1750. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1751. Relname sql.NullString `json:"relname"` // relname
  1752. Indexrelname sql.NullString `json:"indexrelname"` // indexrelname
  1753. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1754. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1755. }
  1756. // PgStatioUserSequence represents a row from 'pg_catalog.pg_statio_user_sequences'.
  1757. type PgStatioUserSequence struct {
  1758. Relid pgtypes.NullOid `json:"relid"` // relid
  1759. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1760. Relname sql.NullString `json:"relname"` // relname
  1761. BlksRead sql.NullInt64 `json:"blks_read"` // blks_read
  1762. BlksHit sql.NullInt64 `json:"blks_hit"` // blks_hit
  1763. }
  1764. // PgStatioUserTable represents a row from 'pg_catalog.pg_statio_user_tables'.
  1765. type PgStatioUserTable struct {
  1766. Relid pgtypes.NullOid `json:"relid"` // relid
  1767. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1768. Relname sql.NullString `json:"relname"` // relname
  1769. HeapBlksRead sql.NullInt64 `json:"heap_blks_read"` // heap_blks_read
  1770. HeapBlksHit sql.NullInt64 `json:"heap_blks_hit"` // heap_blks_hit
  1771. IdxBlksRead sql.NullInt64 `json:"idx_blks_read"` // idx_blks_read
  1772. IdxBlksHit sql.NullInt64 `json:"idx_blks_hit"` // idx_blks_hit
  1773. ToastBlksRead sql.NullInt64 `json:"toast_blks_read"` // toast_blks_read
  1774. ToastBlksHit sql.NullInt64 `json:"toast_blks_hit"` // toast_blks_hit
  1775. TidxBlksRead sql.NullInt64 `json:"tidx_blks_read"` // tidx_blks_read
  1776. TidxBlksHit sql.NullInt64 `json:"tidx_blks_hit"` // tidx_blks_hit
  1777. }
  1778. // PgStatistic represents a row from 'pg_catalog.pg_statistic'.
  1779. type PgStatistic struct {
  1780. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1781. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1782. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1783. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1784. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1785. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1786. Starelid pgtypes.Oid `json:"starelid"` // starelid
  1787. Staattnum int16 `json:"staattnum"` // staattnum
  1788. Stainherit bool `json:"stainherit"` // stainherit
  1789. Stanullfrac float32 `json:"stanullfrac"` // stanullfrac
  1790. Stawidth int `json:"stawidth"` // stawidth
  1791. Stadistinct float32 `json:"stadistinct"` // stadistinct
  1792. Stakind1 int16 `json:"stakind1"` // stakind1
  1793. Stakind2 int16 `json:"stakind2"` // stakind2
  1794. Stakind3 int16 `json:"stakind3"` // stakind3
  1795. Stakind4 int16 `json:"stakind4"` // stakind4
  1796. Stakind5 int16 `json:"stakind5"` // stakind5
  1797. Staop1 pgtypes.Oid `json:"staop1"` // staop1
  1798. Staop2 pgtypes.Oid `json:"staop2"` // staop2
  1799. Staop3 pgtypes.Oid `json:"staop3"` // staop3
  1800. Staop4 pgtypes.Oid `json:"staop4"` // staop4
  1801. Staop5 pgtypes.Oid `json:"staop5"` // staop5
  1802. Stacoll1 pgtypes.Oid `json:"stacoll1"` // stacoll1
  1803. Stacoll2 pgtypes.Oid `json:"stacoll2"` // stacoll2
  1804. Stacoll3 pgtypes.Oid `json:"stacoll3"` // stacoll3
  1805. Stacoll4 pgtypes.Oid `json:"stacoll4"` // stacoll4
  1806. Stacoll5 pgtypes.Oid `json:"stacoll5"` // stacoll5
  1807. Stanumbers1 []sql.NullFloat64 `json:"stanumbers1"` // stanumbers1
  1808. Stanumbers2 []sql.NullFloat64 `json:"stanumbers2"` // stanumbers2
  1809. Stanumbers3 []sql.NullFloat64 `json:"stanumbers3"` // stanumbers3
  1810. Stanumbers4 []sql.NullFloat64 `json:"stanumbers4"` // stanumbers4
  1811. Stanumbers5 []sql.NullFloat64 `json:"stanumbers5"` // stanumbers5
  1812. Stavalues1 pgtypes.NullAnyarray `json:"stavalues1"` // stavalues1
  1813. Stavalues2 pgtypes.NullAnyarray `json:"stavalues2"` // stavalues2
  1814. Stavalues3 pgtypes.NullAnyarray `json:"stavalues3"` // stavalues3
  1815. Stavalues4 pgtypes.NullAnyarray `json:"stavalues4"` // stavalues4
  1816. Stavalues5 pgtypes.NullAnyarray `json:"stavalues5"` // stavalues5
  1817. }
  1818. // PgStatisticExt represents a row from 'pg_catalog.pg_statistic_ext'.
  1819. type PgStatisticExt struct {
  1820. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1821. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1822. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1823. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1824. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1825. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1826. Oid pgtypes.Oid `json:"oid"` // oid
  1827. Stxrelid pgtypes.Oid `json:"stxrelid"` // stxrelid
  1828. Stxname string `json:"stxname"` // stxname
  1829. Stxnamespace pgtypes.Oid `json:"stxnamespace"` // stxnamespace
  1830. Stxowner pgtypes.Oid `json:"stxowner"` // stxowner
  1831. Stxstattarget int `json:"stxstattarget"` // stxstattarget
  1832. Stxkeys pgtypes.Int2vector `json:"stxkeys"` // stxkeys
  1833. Stxkind []pgtypes.Char `json:"stxkind"` // stxkind
  1834. }
  1835. // PgStatisticExtDatum represents a row from 'pg_catalog.pg_statistic_ext_data'.
  1836. type PgStatisticExtDatum struct {
  1837. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1838. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1839. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1840. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1841. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1842. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1843. Stxoid pgtypes.Oid `json:"stxoid"` // stxoid
  1844. Stxdndistinct pgtypes.NullPgNdistinct `json:"stxdndistinct"` // stxdndistinct
  1845. Stxddependencies pgtypes.NullPgDependencies `json:"stxddependencies"` // stxddependencies
  1846. Stxdmcv pgtypes.NullPgMcvList `json:"stxdmcv"` // stxdmcv
  1847. }
  1848. // PgStatsExt represents a row from 'pg_catalog.pg_stats_ext'.
  1849. type PgStatsExt struct {
  1850. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1851. Tablename sql.NullString `json:"tablename"` // tablename
  1852. StatisticsSchemaname sql.NullString `json:"statistics_schemaname"` // statistics_schemaname
  1853. StatisticsName sql.NullString `json:"statistics_name"` // statistics_name
  1854. StatisticsOwner sql.NullString `json:"statistics_owner"` // statistics_owner
  1855. Attnames []sql.NullString `json:"attnames"` // attnames
  1856. Kinds []pgtypes.NullChar `json:"kinds"` // kinds
  1857. NDistinct pgtypes.NullPgNdistinct `json:"n_distinct"` // n_distinct
  1858. Dependencies pgtypes.NullPgDependencies `json:"dependencies"` // dependencies
  1859. MostCommonVals []sql.NullString `json:"most_common_vals"` // most_common_vals
  1860. MostCommonValNulls []sql.NullBool `json:"most_common_val_nulls"` // most_common_val_nulls
  1861. MostCommonFreqs []sql.NullFloat64 `json:"most_common_freqs"` // most_common_freqs
  1862. MostCommonBaseFreqs []sql.NullFloat64 `json:"most_common_base_freqs"` // most_common_base_freqs
  1863. }
  1864. // PgSubscription represents a row from 'pg_catalog.pg_subscription'.
  1865. type PgSubscription struct {
  1866. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1867. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1868. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1869. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1870. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1871. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1872. Oid pgtypes.Oid `json:"oid"` // oid
  1873. Subdbid pgtypes.Oid `json:"subdbid"` // subdbid
  1874. Subname string `json:"subname"` // subname
  1875. Subowner pgtypes.Oid `json:"subowner"` // subowner
  1876. Subenabled bool `json:"subenabled"` // subenabled
  1877. Subconninfo string `json:"subconninfo"` // subconninfo
  1878. Subslotname sql.NullString `json:"subslotname"` // subslotname
  1879. Subsynccommit string `json:"subsynccommit"` // subsynccommit
  1880. Subpublications StringSlice `json:"subpublications"` // subpublications
  1881. }
  1882. // PgSubscriptionRel represents a row from 'pg_catalog.pg_subscription_rel'.
  1883. type PgSubscriptionRel struct {
  1884. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1885. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1886. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1887. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1888. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1889. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1890. Srsubid pgtypes.Oid `json:"srsubid"` // srsubid
  1891. Srrelid pgtypes.Oid `json:"srrelid"` // srrelid
  1892. Srsubstate pgtypes.Char `json:"srsubstate"` // srsubstate
  1893. Srsublsn pgtypes.NullPgLsn `json:"srsublsn"` // srsublsn
  1894. }
  1895. // PgTable represents a row from 'pg_catalog.pg_tables'.
  1896. type PgTable struct {
  1897. Schemaname sql.NullString `json:"schemaname"` // schemaname
  1898. Tablename sql.NullString `json:"tablename"` // tablename
  1899. Tableowner sql.NullString `json:"tableowner"` // tableowner
  1900. Tablespace sql.NullString `json:"tablespace"` // tablespace
  1901. Hasindexes sql.NullBool `json:"hasindexes"` // hasindexes
  1902. Hasrules sql.NullBool `json:"hasrules"` // hasrules
  1903. Hastriggers sql.NullBool `json:"hastriggers"` // hastriggers
  1904. Rowsecurity sql.NullBool `json:"rowsecurity"` // rowsecurity
  1905. }
  1906. // PgTablespace represents a row from 'pg_catalog.pg_tablespace'.
  1907. type PgTablespace struct {
  1908. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1909. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1910. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1911. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1912. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1913. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1914. Oid pgtypes.Oid `json:"oid"` // oid
  1915. Spcname string `json:"spcname"` // spcname
  1916. Spcowner pgtypes.Oid `json:"spcowner"` // spcowner
  1917. Spcacl []pgtypes.NullAclitem `json:"spcacl"` // spcacl
  1918. Spcoptions []sql.NullString `json:"spcoptions"` // spcoptions
  1919. }
  1920. // PgTimezoneAbbrev represents a row from 'pg_catalog.pg_timezone_abbrevs'.
  1921. type PgTimezoneAbbrev struct {
  1922. Abbrev sql.NullString `json:"abbrev"` // abbrev
  1923. UTCOffset []byte `json:"utc_offset"` // utc_offset
  1924. IsDst sql.NullBool `json:"is_dst"` // is_dst
  1925. }
  1926. // PgTimezoneName represents a row from 'pg_catalog.pg_timezone_names'.
  1927. type PgTimezoneName struct {
  1928. Name sql.NullString `json:"name"` // name
  1929. Abbrev sql.NullString `json:"abbrev"` // abbrev
  1930. UTCOffset []byte `json:"utc_offset"` // utc_offset
  1931. IsDst sql.NullBool `json:"is_dst"` // is_dst
  1932. }
  1933. // PgTransform represents a row from 'pg_catalog.pg_transform'.
  1934. type PgTransform struct {
  1935. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1936. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1937. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1938. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1939. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1940. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1941. Oid pgtypes.Oid `json:"oid"` // oid
  1942. Trftype pgtypes.Oid `json:"trftype"` // trftype
  1943. Trflang pgtypes.Oid `json:"trflang"` // trflang
  1944. Trffromsql pgtypes.Regproc `json:"trffromsql"` // trffromsql
  1945. Trftosql pgtypes.Regproc `json:"trftosql"` // trftosql
  1946. }
  1947. // PgTrigger represents a row from 'pg_catalog.pg_trigger'.
  1948. type PgTrigger struct {
  1949. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1950. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1951. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1952. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1953. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1954. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1955. Oid pgtypes.Oid `json:"oid"` // oid
  1956. Tgrelid pgtypes.Oid `json:"tgrelid"` // tgrelid
  1957. Tgparentid pgtypes.Oid `json:"tgparentid"` // tgparentid
  1958. Tgname string `json:"tgname"` // tgname
  1959. Tgfoid pgtypes.Oid `json:"tgfoid"` // tgfoid
  1960. Tgtype int16 `json:"tgtype"` // tgtype
  1961. Tgenabled pgtypes.Char `json:"tgenabled"` // tgenabled
  1962. Tgisinternal bool `json:"tgisinternal"` // tgisinternal
  1963. Tgconstrrelid pgtypes.Oid `json:"tgconstrrelid"` // tgconstrrelid
  1964. Tgconstrindid pgtypes.Oid `json:"tgconstrindid"` // tgconstrindid
  1965. Tgconstraint pgtypes.Oid `json:"tgconstraint"` // tgconstraint
  1966. Tgdeferrable bool `json:"tgdeferrable"` // tgdeferrable
  1967. Tginitdeferred bool `json:"tginitdeferred"` // tginitdeferred
  1968. Tgnargs int16 `json:"tgnargs"` // tgnargs
  1969. Tgattr pgtypes.Int2vector `json:"tgattr"` // tgattr
  1970. Tgargs []byte `json:"tgargs"` // tgargs
  1971. Tgqual pgtypes.NullPgNodeTree `json:"tgqual"` // tgqual
  1972. Tgoldtable sql.NullString `json:"tgoldtable"` // tgoldtable
  1973. Tgnewtable sql.NullString `json:"tgnewtable"` // tgnewtable
  1974. }
  1975. // PgTsConfig represents a row from 'pg_catalog.pg_ts_config'.
  1976. type PgTsConfig struct {
  1977. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1978. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1979. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1980. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1981. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1982. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1983. Oid pgtypes.Oid `json:"oid"` // oid
  1984. Cfgname string `json:"cfgname"` // cfgname
  1985. Cfgnamespace pgtypes.Oid `json:"cfgnamespace"` // cfgnamespace
  1986. Cfgowner pgtypes.Oid `json:"cfgowner"` // cfgowner
  1987. Cfgparser pgtypes.Oid `json:"cfgparser"` // cfgparser
  1988. }
  1989. // PgTsConfigMap represents a row from 'pg_catalog.pg_ts_config_map'.
  1990. type PgTsConfigMap struct {
  1991. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  1992. Cmax pgtypes.Cid `json:"cmax"` // cmax
  1993. Xmax pgtypes.Xid `json:"xmax"` // xmax
  1994. Cmin pgtypes.Cid `json:"cmin"` // cmin
  1995. Xmin pgtypes.Xid `json:"xmin"` // xmin
  1996. Ctid pgtypes.Tid `json:"ctid"` // ctid
  1997. Mapcfg pgtypes.Oid `json:"mapcfg"` // mapcfg
  1998. Maptokentype int `json:"maptokentype"` // maptokentype
  1999. Mapseqno int `json:"mapseqno"` // mapseqno
  2000. Mapdict pgtypes.Oid `json:"mapdict"` // mapdict
  2001. }
  2002. // PgTsDict represents a row from 'pg_catalog.pg_ts_dict'.
  2003. type PgTsDict struct {
  2004. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  2005. Cmax pgtypes.Cid `json:"cmax"` // cmax
  2006. Xmax pgtypes.Xid `json:"xmax"` // xmax
  2007. Cmin pgtypes.Cid `json:"cmin"` // cmin
  2008. Xmin pgtypes.Xid `json:"xmin"` // xmin
  2009. Ctid pgtypes.Tid `json:"ctid"` // ctid
  2010. Oid pgtypes.Oid `json:"oid"` // oid
  2011. Dictname string `json:"dictname"` // dictname
  2012. Dictnamespace pgtypes.Oid `json:"dictnamespace"` // dictnamespace
  2013. Dictowner pgtypes.Oid `json:"dictowner"` // dictowner
  2014. Dicttemplate pgtypes.Oid `json:"dicttemplate"` // dicttemplate
  2015. Dictinitoption sql.NullString `json:"dictinitoption"` // dictinitoption
  2016. }
  2017. // PgTsParser represents a row from 'pg_catalog.pg_ts_parser'.
  2018. type PgTsParser struct {
  2019. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  2020. Cmax pgtypes.Cid `json:"cmax"` // cmax
  2021. Xmax pgtypes.Xid `json:"xmax"` // xmax
  2022. Cmin pgtypes.Cid `json:"cmin"` // cmin
  2023. Xmin pgtypes.Xid `json:"xmin"` // xmin
  2024. Ctid pgtypes.Tid `json:"ctid"` // ctid
  2025. Oid pgtypes.Oid `json:"oid"` // oid
  2026. Prsname string `json:"prsname"` // prsname
  2027. Prsnamespace pgtypes.Oid `json:"prsnamespace"` // prsnamespace
  2028. Prsstart pgtypes.Regproc `json:"prsstart"` // prsstart
  2029. Prstoken pgtypes.Regproc `json:"prstoken"` // prstoken
  2030. Prsend pgtypes.Regproc `json:"prsend"` // prsend
  2031. Prsheadline pgtypes.Regproc `json:"prsheadline"` // prsheadline
  2032. Prslextype pgtypes.Regproc `json:"prslextype"` // prslextype
  2033. }
  2034. // PgTsTemplate represents a row from 'pg_catalog.pg_ts_template'.
  2035. type PgTsTemplate struct {
  2036. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  2037. Cmax pgtypes.Cid `json:"cmax"` // cmax
  2038. Xmax pgtypes.Xid `json:"xmax"` // xmax
  2039. Cmin pgtypes.Cid `json:"cmin"` // cmin
  2040. Xmin pgtypes.Xid `json:"xmin"` // xmin
  2041. Ctid pgtypes.Tid `json:"ctid"` // ctid
  2042. Oid pgtypes.Oid `json:"oid"` // oid
  2043. Tmplname string `json:"tmplname"` // tmplname
  2044. Tmplnamespace pgtypes.Oid `json:"tmplnamespace"` // tmplnamespace
  2045. Tmplinit pgtypes.Regproc `json:"tmplinit"` // tmplinit
  2046. Tmpllexize pgtypes.Regproc `json:"tmpllexize"` // tmpllexize
  2047. }
  2048. // PgType represents a row from 'pg_catalog.pg_type'.
  2049. type PgType struct {
  2050. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  2051. Cmax pgtypes.Cid `json:"cmax"` // cmax
  2052. Xmax pgtypes.Xid `json:"xmax"` // xmax
  2053. Cmin pgtypes.Cid `json:"cmin"` // cmin
  2054. Xmin pgtypes.Xid `json:"xmin"` // xmin
  2055. Ctid pgtypes.Tid `json:"ctid"` // ctid
  2056. Oid pgtypes.Oid `json:"oid"` // oid
  2057. Typname string `json:"typname"` // typname
  2058. Typnamespace pgtypes.Oid `json:"typnamespace"` // typnamespace
  2059. Typowner pgtypes.Oid `json:"typowner"` // typowner
  2060. Typlen int16 `json:"typlen"` // typlen
  2061. Typbyval bool `json:"typbyval"` // typbyval
  2062. Typtype pgtypes.Char `json:"typtype"` // typtype
  2063. Typcategory pgtypes.Char `json:"typcategory"` // typcategory
  2064. Typispreferred bool `json:"typispreferred"` // typispreferred
  2065. Typisdefined bool `json:"typisdefined"` // typisdefined
  2066. Typdelim pgtypes.Char `json:"typdelim"` // typdelim
  2067. Typrelid pgtypes.Oid `json:"typrelid"` // typrelid
  2068. Typelem pgtypes.Oid `json:"typelem"` // typelem
  2069. Typarray pgtypes.Oid `json:"typarray"` // typarray
  2070. Typinput pgtypes.Regproc `json:"typinput"` // typinput
  2071. Typoutput pgtypes.Regproc `json:"typoutput"` // typoutput
  2072. Typreceive pgtypes.Regproc `json:"typreceive"` // typreceive
  2073. Typsend pgtypes.Regproc `json:"typsend"` // typsend
  2074. Typmodin pgtypes.Regproc `json:"typmodin"` // typmodin
  2075. Typmodout pgtypes.Regproc `json:"typmodout"` // typmodout
  2076. Typanalyze pgtypes.Regproc `json:"typanalyze"` // typanalyze
  2077. Typalign pgtypes.Char `json:"typalign"` // typalign
  2078. Typstorage pgtypes.Char `json:"typstorage"` // typstorage
  2079. Typnotnull bool `json:"typnotnull"` // typnotnull
  2080. Typbasetype pgtypes.Oid `json:"typbasetype"` // typbasetype
  2081. Typtypmod int `json:"typtypmod"` // typtypmod
  2082. Typndims int `json:"typndims"` // typndims
  2083. Typcollation pgtypes.Oid `json:"typcollation"` // typcollation
  2084. Typdefaultbin pgtypes.NullPgNodeTree `json:"typdefaultbin"` // typdefaultbin
  2085. Typdefault sql.NullString `json:"typdefault"` // typdefault
  2086. Typacl []pgtypes.NullAclitem `json:"typacl"` // typacl
  2087. }
  2088. // PgUser represents a row from 'pg_catalog.pg_user'.
  2089. type PgUser struct {
  2090. Usename sql.NullString `json:"usename"` // usename
  2091. Usesysid pgtypes.NullOid `json:"usesysid"` // usesysid
  2092. Usecreatedb sql.NullBool `json:"usecreatedb"` // usecreatedb
  2093. Usesuper sql.NullBool `json:"usesuper"` // usesuper
  2094. Userepl sql.NullBool `json:"userepl"` // userepl
  2095. Usebypassrls sql.NullBool `json:"usebypassrls"` // usebypassrls
  2096. Passwd sql.NullString `json:"passwd"` // passwd
  2097. Valuntil sql.NullTime `json:"valuntil"` // valuntil
  2098. Useconfig []sql.NullString `json:"useconfig"` // useconfig
  2099. }
  2100. // PgUserMapping represents a row from 'pg_catalog.pg_user_mapping'.
  2101. type PgUserMapping struct {
  2102. Tableoid pgtypes.Oid `json:"tableoid"` // tableoid
  2103. Cmax pgtypes.Cid `json:"cmax"` // cmax
  2104. Xmax pgtypes.Xid `json:"xmax"` // xmax
  2105. Cmin pgtypes.Cid `json:"cmin"` // cmin
  2106. Xmin pgtypes.Xid `json:"xmin"` // xmin
  2107. Ctid pgtypes.Tid `json:"ctid"` // ctid
  2108. Oid pgtypes.Oid `json:"oid"` // oid
  2109. Umuser pgtypes.Oid `json:"umuser"` // umuser
  2110. Umserver pgtypes.Oid `json:"umserver"` // umserver
  2111. Umoptions []sql.NullString `json:"umoptions"` // umoptions
  2112. }
  2113. // PgUserMapping represents a row from 'pg_catalog.pg_user_mappings'.
  2114. type PgUserMapping struct {
  2115. Umid pgtypes.NullOid `json:"umid"` // umid
  2116. Srvid pgtypes.NullOid `json:"srvid"` // srvid
  2117. Srvname sql.NullString `json:"srvname"` // srvname
  2118. Umuser pgtypes.NullOid `json:"umuser"` // umuser
  2119. Usename sql.NullString `json:"usename"` // usename
  2120. Umoptions []sql.NullString `json:"umoptions"` // umoptions
  2121. }
  2122. // PgView represents a row from 'pg_catalog.pg_views'.
  2123. type PgView struct {
  2124. Schemaname sql.NullString `json:"schemaname"` // schemaname
  2125. Viewname sql.NullString `json:"viewname"` // viewname
  2126. Viewowner sql.NullString `json:"viewowner"` // viewowner
  2127. Definition sql.NullString `json:"definition"` // definition
  2128. }
  2129. // PgAggregateByAggfnoid retrieves a row from 'pg_catalog.pg_aggregate' as a PgAggregate.
  2130. //
  2131. // Generated from index 'pg_aggregate_fnoid_index'.
  2132. func PgAggregateByAggfnoid(ctx context.Context, db DB, aggfnoid pgtypes.Regproc) (*PgAggregate, error) {
  2133. // query
  2134. const sqlstr = `SELECT ` +
  2135. `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 ` +
  2136. `FROM pg_catalog.pg_aggregate ` +
  2137. `WHERE aggfnoid = $1`
  2138. // run
  2139. logf(sqlstr, aggfnoid)
  2140. pa := PgAggregate{}
  2141. 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 {
  2142. return nil, logerror(err)
  2143. }
  2144. return &pa, nil
  2145. }
  2146. // PgAmByAmname retrieves a row from 'pg_catalog.pg_am' as a PgAm.
  2147. //
  2148. // Generated from index 'pg_am_name_index'.
  2149. func PgAmByAmname(ctx context.Context, db DB, amname string) (*PgAm, error) {
  2150. // query
  2151. const sqlstr = `SELECT ` +
  2152. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amname, amhandler, amtype ` +
  2153. `FROM pg_catalog.pg_am ` +
  2154. `WHERE amname = $1`
  2155. // run
  2156. logf(sqlstr, amname)
  2157. pa := PgAm{}
  2158. 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 {
  2159. return nil, logerror(err)
  2160. }
  2161. return &pa, nil
  2162. }
  2163. // PgAmByOid retrieves a row from 'pg_catalog.pg_am' as a PgAm.
  2164. //
  2165. // Generated from index 'pg_am_oid_index'.
  2166. func PgAmByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAm, error) {
  2167. // query
  2168. const sqlstr = `SELECT ` +
  2169. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amname, amhandler, amtype ` +
  2170. `FROM pg_catalog.pg_am ` +
  2171. `WHERE oid = $1`
  2172. // run
  2173. logf(sqlstr, oid)
  2174. pa := PgAm{}
  2175. 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 {
  2176. return nil, logerror(err)
  2177. }
  2178. return &pa, nil
  2179. }
  2180. // PgAmopByAmopfamilyAmoplefttypeAmoprighttypeAmopstrategy retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
  2181. //
  2182. // Generated from index 'pg_amop_fam_strat_index'.
  2183. func PgAmopByAmopfamilyAmoplefttypeAmoprighttypeAmopstrategy(ctx context.Context, db DB, amopfamily, amoplefttype, amoprighttype pgtypes.Oid, amopstrategy int16) (*PgAmop, error) {
  2184. // query
  2185. const sqlstr = `SELECT ` +
  2186. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
  2187. `FROM pg_catalog.pg_amop ` +
  2188. `WHERE amopfamily = $1 AND amoplefttype = $2 AND amoprighttype = $3 AND amopstrategy = $4`
  2189. // run
  2190. logf(sqlstr, amopfamily, amoplefttype, amoprighttype, amopstrategy)
  2191. pa := PgAmop{}
  2192. 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 {
  2193. return nil, logerror(err)
  2194. }
  2195. return &pa, nil
  2196. }
  2197. // PgAmopByOid retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
  2198. //
  2199. // Generated from index 'pg_amop_oid_index'.
  2200. func PgAmopByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAmop, error) {
  2201. // query
  2202. const sqlstr = `SELECT ` +
  2203. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
  2204. `FROM pg_catalog.pg_amop ` +
  2205. `WHERE oid = $1`
  2206. // run
  2207. logf(sqlstr, oid)
  2208. pa := PgAmop{}
  2209. 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 {
  2210. return nil, logerror(err)
  2211. }
  2212. return &pa, nil
  2213. }
  2214. // PgAmopByAmopoprAmoppurposeAmopfamily retrieves a row from 'pg_catalog.pg_amop' as a PgAmop.
  2215. //
  2216. // Generated from index 'pg_amop_opr_fam_index'.
  2217. func PgAmopByAmopoprAmoppurposeAmopfamily(ctx context.Context, db DB, amopopr pgtypes.Oid, amoppurpose pgtypes.Char, amopfamily pgtypes.Oid) (*PgAmop, error) {
  2218. // query
  2219. const sqlstr = `SELECT ` +
  2220. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily ` +
  2221. `FROM pg_catalog.pg_amop ` +
  2222. `WHERE amopopr = $1 AND amoppurpose = $2 AND amopfamily = $3`
  2223. // run
  2224. logf(sqlstr, amopopr, amoppurpose, amopfamily)
  2225. pa := PgAmop{}
  2226. 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 {
  2227. return nil, logerror(err)
  2228. }
  2229. return &pa, nil
  2230. }
  2231. // PgAmprocByAmprocfamilyAmproclefttypeAmprocrighttypeAmprocnum retrieves a row from 'pg_catalog.pg_amproc' as a PgAmproc.
  2232. //
  2233. // Generated from index 'pg_amproc_fam_proc_index'.
  2234. func PgAmprocByAmprocfamilyAmproclefttypeAmprocrighttypeAmprocnum(ctx context.Context, db DB, amprocfamily, amproclefttype, amprocrighttype pgtypes.Oid, amprocnum int16) (*PgAmproc, error) {
  2235. // query
  2236. const sqlstr = `SELECT ` +
  2237. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amprocfamily, amproclefttype, amprocrighttype, amprocnum, amproc ` +
  2238. `FROM pg_catalog.pg_amproc ` +
  2239. `WHERE amprocfamily = $1 AND amproclefttype = $2 AND amprocrighttype = $3 AND amprocnum = $4`
  2240. // run
  2241. logf(sqlstr, amprocfamily, amproclefttype, amprocrighttype, amprocnum)
  2242. pa := PgAmproc{}
  2243. 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 {
  2244. return nil, logerror(err)
  2245. }
  2246. return &pa, nil
  2247. }
  2248. // PgAmprocByOid retrieves a row from 'pg_catalog.pg_amproc' as a PgAmproc.
  2249. //
  2250. // Generated from index 'pg_amproc_oid_index'.
  2251. func PgAmprocByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAmproc, error) {
  2252. // query
  2253. const sqlstr = `SELECT ` +
  2254. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, amprocfamily, amproclefttype, amprocrighttype, amprocnum, amproc ` +
  2255. `FROM pg_catalog.pg_amproc ` +
  2256. `WHERE oid = $1`
  2257. // run
  2258. logf(sqlstr, oid)
  2259. pa := PgAmproc{}
  2260. 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 {
  2261. return nil, logerror(err)
  2262. }
  2263. return &pa, nil
  2264. }
  2265. // PgAttrdefByAdrelidAdnum retrieves a row from 'pg_catalog.pg_attrdef' as a PgAttrdef.
  2266. //
  2267. // Generated from index 'pg_attrdef_adrelid_adnum_index'.
  2268. func PgAttrdefByAdrelidAdnum(ctx context.Context, db DB, adrelid pgtypes.Oid, adnum int16) (*PgAttrdef, error) {
  2269. // query
  2270. const sqlstr = `SELECT ` +
  2271. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, adrelid, adnum, adbin ` +
  2272. `FROM pg_catalog.pg_attrdef ` +
  2273. `WHERE adrelid = $1 AND adnum = $2`
  2274. // run
  2275. logf(sqlstr, adrelid, adnum)
  2276. pa := PgAttrdef{}
  2277. 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 {
  2278. return nil, logerror(err)
  2279. }
  2280. return &pa, nil
  2281. }
  2282. // PgAttrdefByOid retrieves a row from 'pg_catalog.pg_attrdef' as a PgAttrdef.
  2283. //
  2284. // Generated from index 'pg_attrdef_oid_index'.
  2285. func PgAttrdefByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAttrdef, error) {
  2286. // query
  2287. const sqlstr = `SELECT ` +
  2288. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, adrelid, adnum, adbin ` +
  2289. `FROM pg_catalog.pg_attrdef ` +
  2290. `WHERE oid = $1`
  2291. // run
  2292. logf(sqlstr, oid)
  2293. pa := PgAttrdef{}
  2294. 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 {
  2295. return nil, logerror(err)
  2296. }
  2297. return &pa, nil
  2298. }
  2299. // PgAttributeByAttrelidAttname retrieves a row from 'pg_catalog.pg_attribute' as a PgAttribute.
  2300. //
  2301. // Generated from index 'pg_attribute_relid_attnam_index'.
  2302. func PgAttributeByAttrelidAttname(ctx context.Context, db DB, attrelid pgtypes.Oid, attname string) (*PgAttribute, error) {
  2303. // query
  2304. const sqlstr = `SELECT ` +
  2305. `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 ` +
  2306. `FROM pg_catalog.pg_attribute ` +
  2307. `WHERE attrelid = $1 AND attname = $2`
  2308. // run
  2309. logf(sqlstr, attrelid, attname)
  2310. pa := PgAttribute{}
  2311. 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 {
  2312. return nil, logerror(err)
  2313. }
  2314. return &pa, nil
  2315. }
  2316. // PgAttributeByAttrelidAttnum retrieves a row from 'pg_catalog.pg_attribute' as a PgAttribute.
  2317. //
  2318. // Generated from index 'pg_attribute_relid_attnum_index'.
  2319. func PgAttributeByAttrelidAttnum(ctx context.Context, db DB, attrelid pgtypes.Oid, attnum int16) (*PgAttribute, error) {
  2320. // query
  2321. const sqlstr = `SELECT ` +
  2322. `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 ` +
  2323. `FROM pg_catalog.pg_attribute ` +
  2324. `WHERE attrelid = $1 AND attnum = $2`
  2325. // run
  2326. logf(sqlstr, attrelid, attnum)
  2327. pa := PgAttribute{}
  2328. 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 {
  2329. return nil, logerror(err)
  2330. }
  2331. return &pa, nil
  2332. }
  2333. // PgAuthMemberByMemberRoleid retrieves a row from 'pg_catalog.pg_auth_members' as a PgAuthMember.
  2334. //
  2335. // Generated from index 'pg_auth_members_member_role_index'.
  2336. func PgAuthMemberByMemberRoleid(ctx context.Context, db DB, member, roleid pgtypes.Oid) (*PgAuthMember, error) {
  2337. // query
  2338. const sqlstr = `SELECT ` +
  2339. `tableoid, cmax, xmax, cmin, xmin, ctid, roleid, member, grantor, admin_option ` +
  2340. `FROM pg_catalog.pg_auth_members ` +
  2341. `WHERE member = $1 AND roleid = $2`
  2342. // run
  2343. logf(sqlstr, member, roleid)
  2344. pam := PgAuthMember{}
  2345. 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 {
  2346. return nil, logerror(err)
  2347. }
  2348. return &pam, nil
  2349. }
  2350. // PgAuthMemberByRoleidMember retrieves a row from 'pg_catalog.pg_auth_members' as a PgAuthMember.
  2351. //
  2352. // Generated from index 'pg_auth_members_role_member_index'.
  2353. func PgAuthMemberByRoleidMember(ctx context.Context, db DB, roleid, member pgtypes.Oid) (*PgAuthMember, error) {
  2354. // query
  2355. const sqlstr = `SELECT ` +
  2356. `tableoid, cmax, xmax, cmin, xmin, ctid, roleid, member, grantor, admin_option ` +
  2357. `FROM pg_catalog.pg_auth_members ` +
  2358. `WHERE roleid = $1 AND member = $2`
  2359. // run
  2360. logf(sqlstr, roleid, member)
  2361. pam := PgAuthMember{}
  2362. 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 {
  2363. return nil, logerror(err)
  2364. }
  2365. return &pam, nil
  2366. }
  2367. // PgAuthidByOid retrieves a row from 'pg_catalog.pg_authid' as a PgAuthid.
  2368. //
  2369. // Generated from index 'pg_authid_oid_index'.
  2370. func PgAuthidByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgAuthid, error) {
  2371. // query
  2372. const sqlstr = `SELECT ` +
  2373. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolreplication, rolbypassrls, rolconnlimit, rolpassword, rolvaliduntil ` +
  2374. `FROM pg_catalog.pg_authid ` +
  2375. `WHERE oid = $1`
  2376. // run
  2377. logf(sqlstr, oid)
  2378. pa := PgAuthid{}
  2379. 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 {
  2380. return nil, logerror(err)
  2381. }
  2382. return &pa, nil
  2383. }
  2384. // PgAuthidByRolname retrieves a row from 'pg_catalog.pg_authid' as a PgAuthid.
  2385. //
  2386. // Generated from index 'pg_authid_rolname_index'.
  2387. func PgAuthidByRolname(ctx context.Context, db DB, rolname string) (*PgAuthid, error) {
  2388. // query
  2389. const sqlstr = `SELECT ` +
  2390. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolreplication, rolbypassrls, rolconnlimit, rolpassword, rolvaliduntil ` +
  2391. `FROM pg_catalog.pg_authid ` +
  2392. `WHERE rolname = $1`
  2393. // run
  2394. logf(sqlstr, rolname)
  2395. pa := PgAuthid{}
  2396. 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 {
  2397. return nil, logerror(err)
  2398. }
  2399. return &pa, nil
  2400. }
  2401. // PgCastByOid retrieves a row from 'pg_catalog.pg_cast' as a PgCast.
  2402. //
  2403. // Generated from index 'pg_cast_oid_index'.
  2404. func PgCastByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgCast, error) {
  2405. // query
  2406. const sqlstr = `SELECT ` +
  2407. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, castsource, casttarget, castfunc, castcontext, castmethod ` +
  2408. `FROM pg_catalog.pg_cast ` +
  2409. `WHERE oid = $1`
  2410. // run
  2411. logf(sqlstr, oid)
  2412. pc := PgCast{}
  2413. 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 {
  2414. return nil, logerror(err)
  2415. }
  2416. return &pc, nil
  2417. }
  2418. // PgCastByCastsourceCasttarget retrieves a row from 'pg_catalog.pg_cast' as a PgCast.
  2419. //
  2420. // Generated from index 'pg_cast_source_target_index'.
  2421. func PgCastByCastsourceCasttarget(ctx context.Context, db DB, castsource, casttarget pgtypes.Oid) (*PgCast, error) {
  2422. // query
  2423. const sqlstr = `SELECT ` +
  2424. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, castsource, casttarget, castfunc, castcontext, castmethod ` +
  2425. `FROM pg_catalog.pg_cast ` +
  2426. `WHERE castsource = $1 AND casttarget = $2`
  2427. // run
  2428. logf(sqlstr, castsource, casttarget)
  2429. pc := PgCast{}
  2430. 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 {
  2431. return nil, logerror(err)
  2432. }
  2433. return &pc, nil
  2434. }
  2435. // PgClassByOid retrieves a row from 'pg_catalog.pg_class' as a PgClass.
  2436. //
  2437. // Generated from index 'pg_class_oid_index'.
  2438. func PgClassByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgClass, error) {
  2439. // query
  2440. const sqlstr = `SELECT ` +
  2441. `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 ` +
  2442. `FROM pg_catalog.pg_class ` +
  2443. `WHERE oid = $1`
  2444. // run
  2445. logf(sqlstr, oid)
  2446. pc := PgClass{}
  2447. 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 {
  2448. return nil, logerror(err)
  2449. }
  2450. return &pc, nil
  2451. }
  2452. // PgClassByRelnameRelnamespace retrieves a row from 'pg_catalog.pg_class' as a PgClass.
  2453. //
  2454. // Generated from index 'pg_class_relname_nsp_index'.
  2455. func PgClassByRelnameRelnamespace(ctx context.Context, db DB, relname string, relnamespace pgtypes.Oid) (*PgClass, error) {
  2456. // query
  2457. const sqlstr = `SELECT ` +
  2458. `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 ` +
  2459. `FROM pg_catalog.pg_class ` +
  2460. `WHERE relname = $1 AND relnamespace = $2`
  2461. // run
  2462. logf(sqlstr, relname, relnamespace)
  2463. pc := PgClass{}
  2464. 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 {
  2465. return nil, logerror(err)
  2466. }
  2467. return &pc, nil
  2468. }
  2469. // PgClassByReltablespaceRelfilenode retrieves a row from 'pg_catalog.pg_class' as a PgClass.
  2470. //
  2471. // Generated from index 'pg_class_tblspc_relfilenode_index'.
  2472. func PgClassByReltablespaceRelfilenode(ctx context.Context, db DB, reltablespace, relfilenode pgtypes.Oid) ([]*PgClass, error) {
  2473. // query
  2474. const sqlstr = `SELECT ` +
  2475. `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 ` +
  2476. `FROM pg_catalog.pg_class ` +
  2477. `WHERE reltablespace = $1 AND relfilenode = $2`
  2478. // run
  2479. logf(sqlstr, reltablespace, relfilenode)
  2480. rows, err := db.QueryContext(ctx, sqlstr, reltablespace, relfilenode)
  2481. if err != nil {
  2482. return nil, logerror(err)
  2483. }
  2484. defer rows.Close()
  2485. // process
  2486. var res []*PgClass
  2487. for rows.Next() {
  2488. pc := PgClass{}
  2489. // scan
  2490. 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 {
  2491. return nil, logerror(err)
  2492. }
  2493. res = append(res, &pc)
  2494. }
  2495. if err := rows.Err(); err != nil {
  2496. return nil, logerror(err)
  2497. }
  2498. return res, nil
  2499. }
  2500. // PgCollationByCollnameCollencodingCollnamespace retrieves a row from 'pg_catalog.pg_collation' as a PgCollation.
  2501. //
  2502. // Generated from index 'pg_collation_name_enc_nsp_index'.
  2503. func PgCollationByCollnameCollencodingCollnamespace(ctx context.Context, db DB, collname string, collencoding int, collnamespace pgtypes.Oid) (*PgCollation, error) {
  2504. // query
  2505. const sqlstr = `SELECT ` +
  2506. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, collname, collnamespace, collowner, collprovider, collisdeterministic, collencoding, collcollate, collctype, collversion ` +
  2507. `FROM pg_catalog.pg_collation ` +
  2508. `WHERE collname = $1 AND collencoding = $2 AND collnamespace = $3`
  2509. // run
  2510. logf(sqlstr, collname, collencoding, collnamespace)
  2511. pc := PgCollation{}
  2512. 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 {
  2513. return nil, logerror(err)
  2514. }
  2515. return &pc, nil
  2516. }
  2517. // PgCollationByOid retrieves a row from 'pg_catalog.pg_collation' as a PgCollation.
  2518. //
  2519. // Generated from index 'pg_collation_oid_index'.
  2520. func PgCollationByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgCollation, error) {
  2521. // query
  2522. const sqlstr = `SELECT ` +
  2523. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, collname, collnamespace, collowner, collprovider, collisdeterministic, collencoding, collcollate, collctype, collversion ` +
  2524. `FROM pg_catalog.pg_collation ` +
  2525. `WHERE oid = $1`
  2526. // run
  2527. logf(sqlstr, oid)
  2528. pc := PgCollation{}
  2529. 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 {
  2530. return nil, logerror(err)
  2531. }
  2532. return &pc, nil
  2533. }
  2534. // PgConstraintByConnameConnamespace retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
  2535. //
  2536. // Generated from index 'pg_constraint_conname_nsp_index'.
  2537. func PgConstraintByConnameConnamespace(ctx context.Context, db DB, conname string, connamespace pgtypes.Oid) ([]*PgConstraint, error) {
  2538. // query
  2539. const sqlstr = `SELECT ` +
  2540. `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 ` +
  2541. `FROM pg_catalog.pg_constraint ` +
  2542. `WHERE conname = $1 AND connamespace = $2`
  2543. // run
  2544. logf(sqlstr, conname, connamespace)
  2545. rows, err := db.QueryContext(ctx, sqlstr, conname, connamespace)
  2546. if err != nil {
  2547. return nil, logerror(err)
  2548. }
  2549. defer rows.Close()
  2550. // process
  2551. var res []*PgConstraint
  2552. for rows.Next() {
  2553. pc := PgConstraint{}
  2554. // scan
  2555. 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 {
  2556. return nil, logerror(err)
  2557. }
  2558. res = append(res, &pc)
  2559. }
  2560. if err := rows.Err(); err != nil {
  2561. return nil, logerror(err)
  2562. }
  2563. return res, nil
  2564. }
  2565. // PgConstraintByConparentid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
  2566. //
  2567. // Generated from index 'pg_constraint_conparentid_index'.
  2568. func PgConstraintByConparentid(ctx context.Context, db DB, conparentid pgtypes.Oid) ([]*PgConstraint, error) {
  2569. // query
  2570. const sqlstr = `SELECT ` +
  2571. `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 ` +
  2572. `FROM pg_catalog.pg_constraint ` +
  2573. `WHERE conparentid = $1`
  2574. // run
  2575. logf(sqlstr, conparentid)
  2576. rows, err := db.QueryContext(ctx, sqlstr, conparentid)
  2577. if err != nil {
  2578. return nil, logerror(err)
  2579. }
  2580. defer rows.Close()
  2581. // process
  2582. var res []*PgConstraint
  2583. for rows.Next() {
  2584. pc := PgConstraint{}
  2585. // scan
  2586. 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 {
  2587. return nil, logerror(err)
  2588. }
  2589. res = append(res, &pc)
  2590. }
  2591. if err := rows.Err(); err != nil {
  2592. return nil, logerror(err)
  2593. }
  2594. return res, nil
  2595. }
  2596. // PgConstraintByConrelidContypidConname retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
  2597. //
  2598. // Generated from index 'pg_constraint_conrelid_contypid_conname_index'.
  2599. func PgConstraintByConrelidContypidConname(ctx context.Context, db DB, conrelid, contypid pgtypes.Oid, conname string) (*PgConstraint, error) {
  2600. // query
  2601. const sqlstr = `SELECT ` +
  2602. `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 ` +
  2603. `FROM pg_catalog.pg_constraint ` +
  2604. `WHERE conrelid = $1 AND contypid = $2 AND conname = $3`
  2605. // run
  2606. logf(sqlstr, conrelid, contypid, conname)
  2607. pc := PgConstraint{}
  2608. 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 {
  2609. return nil, logerror(err)
  2610. }
  2611. return &pc, nil
  2612. }
  2613. // PgConstraintByContypid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
  2614. //
  2615. // Generated from index 'pg_constraint_contypid_index'.
  2616. func PgConstraintByContypid(ctx context.Context, db DB, contypid pgtypes.Oid) ([]*PgConstraint, error) {
  2617. // query
  2618. const sqlstr = `SELECT ` +
  2619. `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 ` +
  2620. `FROM pg_catalog.pg_constraint ` +
  2621. `WHERE contypid = $1`
  2622. // run
  2623. logf(sqlstr, contypid)
  2624. rows, err := db.QueryContext(ctx, sqlstr, contypid)
  2625. if err != nil {
  2626. return nil, logerror(err)
  2627. }
  2628. defer rows.Close()
  2629. // process
  2630. var res []*PgConstraint
  2631. for rows.Next() {
  2632. pc := PgConstraint{}
  2633. // scan
  2634. 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 {
  2635. return nil, logerror(err)
  2636. }
  2637. res = append(res, &pc)
  2638. }
  2639. if err := rows.Err(); err != nil {
  2640. return nil, logerror(err)
  2641. }
  2642. return res, nil
  2643. }
  2644. // PgConstraintByOid retrieves a row from 'pg_catalog.pg_constraint' as a PgConstraint.
  2645. //
  2646. // Generated from index 'pg_constraint_oid_index'.
  2647. func PgConstraintByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgConstraint, error) {
  2648. // query
  2649. const sqlstr = `SELECT ` +
  2650. `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 ` +
  2651. `FROM pg_catalog.pg_constraint ` +
  2652. `WHERE oid = $1`
  2653. // run
  2654. logf(sqlstr, oid)
  2655. pc := PgConstraint{}
  2656. 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 {
  2657. return nil, logerror(err)
  2658. }
  2659. return &pc, nil
  2660. }
  2661. // PgConversionByConnamespaceConforencodingContoencodingOid retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
  2662. //
  2663. // Generated from index 'pg_conversion_default_index'.
  2664. func PgConversionByConnamespaceConforencodingContoencodingOid(ctx context.Context, db DB, connamespace pgtypes.Oid, conforencoding, contoencoding int, oid pgtypes.Oid) (*PgConversion, error) {
  2665. // query
  2666. const sqlstr = `SELECT ` +
  2667. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
  2668. `FROM pg_catalog.pg_conversion ` +
  2669. `WHERE connamespace = $1 AND conforencoding = $2 AND contoencoding = $3 AND oid = $4`
  2670. // run
  2671. logf(sqlstr, connamespace, conforencoding, contoencoding, oid)
  2672. pc := PgConversion{}
  2673. 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 {
  2674. return nil, logerror(err)
  2675. }
  2676. return &pc, nil
  2677. }
  2678. // PgConversionByConnameConnamespace retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
  2679. //
  2680. // Generated from index 'pg_conversion_name_nsp_index'.
  2681. func PgConversionByConnameConnamespace(ctx context.Context, db DB, conname string, connamespace pgtypes.Oid) (*PgConversion, error) {
  2682. // query
  2683. const sqlstr = `SELECT ` +
  2684. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
  2685. `FROM pg_catalog.pg_conversion ` +
  2686. `WHERE conname = $1 AND connamespace = $2`
  2687. // run
  2688. logf(sqlstr, conname, connamespace)
  2689. pc := PgConversion{}
  2690. 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 {
  2691. return nil, logerror(err)
  2692. }
  2693. return &pc, nil
  2694. }
  2695. // PgConversionByOid retrieves a row from 'pg_catalog.pg_conversion' as a PgConversion.
  2696. //
  2697. // Generated from index 'pg_conversion_oid_index'.
  2698. func PgConversionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgConversion, error) {
  2699. // query
  2700. const sqlstr = `SELECT ` +
  2701. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault ` +
  2702. `FROM pg_catalog.pg_conversion ` +
  2703. `WHERE oid = $1`
  2704. // run
  2705. logf(sqlstr, oid)
  2706. pc := PgConversion{}
  2707. 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 {
  2708. return nil, logerror(err)
  2709. }
  2710. return &pc, nil
  2711. }
  2712. // PgDatabaseByDatname retrieves a row from 'pg_catalog.pg_database' as a PgDatabase.
  2713. //
  2714. // Generated from index 'pg_database_datname_index'.
  2715. func PgDatabaseByDatname(ctx context.Context, db DB, datname string) (*PgDatabase, error) {
  2716. // query
  2717. const sqlstr = `SELECT ` +
  2718. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, datname, datdba, encoding, datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl ` +
  2719. `FROM pg_catalog.pg_database ` +
  2720. `WHERE datname = $1`
  2721. // run
  2722. logf(sqlstr, datname)
  2723. pd := PgDatabase{}
  2724. 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 {
  2725. return nil, logerror(err)
  2726. }
  2727. return &pd, nil
  2728. }
  2729. // PgDatabaseByOid retrieves a row from 'pg_catalog.pg_database' as a PgDatabase.
  2730. //
  2731. // Generated from index 'pg_database_oid_index'.
  2732. func PgDatabaseByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgDatabase, error) {
  2733. // query
  2734. const sqlstr = `SELECT ` +
  2735. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, datname, datdba, encoding, datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl ` +
  2736. `FROM pg_catalog.pg_database ` +
  2737. `WHERE oid = $1`
  2738. // run
  2739. logf(sqlstr, oid)
  2740. pd := PgDatabase{}
  2741. 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 {
  2742. return nil, logerror(err)
  2743. }
  2744. return &pd, nil
  2745. }
  2746. // PgDbRoleSettingBySetdatabaseSetrole retrieves a row from 'pg_catalog.pg_db_role_setting' as a PgDbRoleSetting.
  2747. //
  2748. // Generated from index 'pg_db_role_setting_databaseid_rol_index'.
  2749. func PgDbRoleSettingBySetdatabaseSetrole(ctx context.Context, db DB, setdatabase, setrole pgtypes.Oid) (*PgDbRoleSetting, error) {
  2750. // query
  2751. const sqlstr = `SELECT ` +
  2752. `tableoid, cmax, xmax, cmin, xmin, ctid, setdatabase, setrole, setconfig ` +
  2753. `FROM pg_catalog.pg_db_role_setting ` +
  2754. `WHERE setdatabase = $1 AND setrole = $2`
  2755. // run
  2756. logf(sqlstr, setdatabase, setrole)
  2757. pdrs := PgDbRoleSetting{}
  2758. 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 {
  2759. return nil, logerror(err)
  2760. }
  2761. return &pdrs, nil
  2762. }
  2763. // PgDefaultACLByOid retrieves a row from 'pg_catalog.pg_default_acl' as a PgDefaultACL.
  2764. //
  2765. // Generated from index 'pg_default_acl_oid_index'.
  2766. func PgDefaultACLByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgDefaultACL, error) {
  2767. // query
  2768. const sqlstr = `SELECT ` +
  2769. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, defaclrole, defaclnamespace, defaclobjtype, defaclacl ` +
  2770. `FROM pg_catalog.pg_default_acl ` +
  2771. `WHERE oid = $1`
  2772. // run
  2773. logf(sqlstr, oid)
  2774. pda := PgDefaultACL{}
  2775. 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 {
  2776. return nil, logerror(err)
  2777. }
  2778. return &pda, nil
  2779. }
  2780. // PgDefaultACLByDefaclroleDefaclnamespaceDefaclobjtype retrieves a row from 'pg_catalog.pg_default_acl' as a PgDefaultACL.
  2781. //
  2782. // Generated from index 'pg_default_acl_role_nsp_obj_index'.
  2783. func PgDefaultACLByDefaclroleDefaclnamespaceDefaclobjtype(ctx context.Context, db DB, defaclrole, defaclnamespace pgtypes.Oid, defaclobjtype pgtypes.Char) (*PgDefaultACL, error) {
  2784. // query
  2785. const sqlstr = `SELECT ` +
  2786. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, defaclrole, defaclnamespace, defaclobjtype, defaclacl ` +
  2787. `FROM pg_catalog.pg_default_acl ` +
  2788. `WHERE defaclrole = $1 AND defaclnamespace = $2 AND defaclobjtype = $3`
  2789. // run
  2790. logf(sqlstr, defaclrole, defaclnamespace, defaclobjtype)
  2791. pda := PgDefaultACL{}
  2792. 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 {
  2793. return nil, logerror(err)
  2794. }
  2795. return &pda, nil
  2796. }
  2797. // PgDependByClassidObjidObjsubid retrieves a row from 'pg_catalog.pg_depend' as a PgDepend.
  2798. //
  2799. // Generated from index 'pg_depend_depender_index'.
  2800. func PgDependByClassidObjidObjsubid(ctx context.Context, db DB, classid, objid pgtypes.Oid, objsubid int) ([]*PgDepend, error) {
  2801. // query
  2802. const sqlstr = `SELECT ` +
  2803. `tableoid, cmax, xmax, cmin, xmin, ctid, classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype ` +
  2804. `FROM pg_catalog.pg_depend ` +
  2805. `WHERE classid = $1 AND objid = $2 AND objsubid = $3`
  2806. // run
  2807. logf(sqlstr, classid, objid, objsubid)
  2808. rows, err := db.QueryContext(ctx, sqlstr, classid, objid, objsubid)
  2809. if err != nil {
  2810. return nil, logerror(err)
  2811. }
  2812. defer rows.Close()
  2813. // process
  2814. var res []*PgDepend
  2815. for rows.Next() {
  2816. pd := PgDepend{}
  2817. // scan
  2818. 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 {
  2819. return nil, logerror(err)
  2820. }
  2821. res = append(res, &pd)
  2822. }
  2823. if err := rows.Err(); err != nil {
  2824. return nil, logerror(err)
  2825. }
  2826. return res, nil
  2827. }
  2828. // PgDependByRefclassidRefobjidRefobjsubid retrieves a row from 'pg_catalog.pg_depend' as a PgDepend.
  2829. //
  2830. // Generated from index 'pg_depend_reference_index'.
  2831. func PgDependByRefclassidRefobjidRefobjsubid(ctx context.Context, db DB, refclassid, refobjid pgtypes.Oid, refobjsubid int) ([]*PgDepend, error) {
  2832. // query
  2833. const sqlstr = `SELECT ` +
  2834. `tableoid, cmax, xmax, cmin, xmin, ctid, classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype ` +
  2835. `FROM pg_catalog.pg_depend ` +
  2836. `WHERE refclassid = $1 AND refobjid = $2 AND refobjsubid = $3`
  2837. // run
  2838. logf(sqlstr, refclassid, refobjid, refobjsubid)
  2839. rows, err := db.QueryContext(ctx, sqlstr, refclassid, refobjid, refobjsubid)
  2840. if err != nil {
  2841. return nil, logerror(err)
  2842. }
  2843. defer rows.Close()
  2844. // process
  2845. var res []*PgDepend
  2846. for rows.Next() {
  2847. pd := PgDepend{}
  2848. // scan
  2849. 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 {
  2850. return nil, logerror(err)
  2851. }
  2852. res = append(res, &pd)
  2853. }
  2854. if err := rows.Err(); err != nil {
  2855. return nil, logerror(err)
  2856. }
  2857. return res, nil
  2858. }
  2859. // PgDescriptionByObjoidClassoidObjsubid retrieves a row from 'pg_catalog.pg_description' as a PgDescription.
  2860. //
  2861. // Generated from index 'pg_description_o_c_o_index'.
  2862. func PgDescriptionByObjoidClassoidObjsubid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int) (*PgDescription, error) {
  2863. // query
  2864. const sqlstr = `SELECT ` +
  2865. `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, description ` +
  2866. `FROM pg_catalog.pg_description ` +
  2867. `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3`
  2868. // run
  2869. logf(sqlstr, objoid, classoid, objsubid)
  2870. pd := PgDescription{}
  2871. 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 {
  2872. return nil, logerror(err)
  2873. }
  2874. return &pd, nil
  2875. }
  2876. // PgEnumByOid retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
  2877. //
  2878. // Generated from index 'pg_enum_oid_index'.
  2879. func PgEnumByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgEnum, error) {
  2880. // query
  2881. const sqlstr = `SELECT ` +
  2882. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
  2883. `FROM pg_catalog.pg_enum ` +
  2884. `WHERE oid = $1`
  2885. // run
  2886. logf(sqlstr, oid)
  2887. pe := PgEnum{}
  2888. 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 {
  2889. return nil, logerror(err)
  2890. }
  2891. return &pe, nil
  2892. }
  2893. // PgEnumByEnumtypidEnumlabel retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
  2894. //
  2895. // Generated from index 'pg_enum_typid_label_index'.
  2896. func PgEnumByEnumtypidEnumlabel(ctx context.Context, db DB, enumtypid pgtypes.Oid, enumlabel string) (*PgEnum, error) {
  2897. // query
  2898. const sqlstr = `SELECT ` +
  2899. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
  2900. `FROM pg_catalog.pg_enum ` +
  2901. `WHERE enumtypid = $1 AND enumlabel = $2`
  2902. // run
  2903. logf(sqlstr, enumtypid, enumlabel)
  2904. pe := PgEnum{}
  2905. 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 {
  2906. return nil, logerror(err)
  2907. }
  2908. return &pe, nil
  2909. }
  2910. // PgEnumByEnumtypidEnumsortorder retrieves a row from 'pg_catalog.pg_enum' as a PgEnum.
  2911. //
  2912. // Generated from index 'pg_enum_typid_sortorder_index'.
  2913. func PgEnumByEnumtypidEnumsortorder(ctx context.Context, db DB, enumtypid pgtypes.Oid, enumsortorder float32) (*PgEnum, error) {
  2914. // query
  2915. const sqlstr = `SELECT ` +
  2916. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, enumtypid, enumsortorder, enumlabel ` +
  2917. `FROM pg_catalog.pg_enum ` +
  2918. `WHERE enumtypid = $1 AND enumsortorder = $2`
  2919. // run
  2920. logf(sqlstr, enumtypid, enumsortorder)
  2921. pe := PgEnum{}
  2922. 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 {
  2923. return nil, logerror(err)
  2924. }
  2925. return &pe, nil
  2926. }
  2927. // PgEventTriggerByEvtname retrieves a row from 'pg_catalog.pg_event_trigger' as a PgEventTrigger.
  2928. //
  2929. // Generated from index 'pg_event_trigger_evtname_index'.
  2930. func PgEventTriggerByEvtname(ctx context.Context, db DB, evtname string) (*PgEventTrigger, error) {
  2931. // query
  2932. const sqlstr = `SELECT ` +
  2933. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, evtname, evtevent, evtowner, evtfoid, evtenabled, evttags ` +
  2934. `FROM pg_catalog.pg_event_trigger ` +
  2935. `WHERE evtname = $1`
  2936. // run
  2937. logf(sqlstr, evtname)
  2938. pet := PgEventTrigger{}
  2939. 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 {
  2940. return nil, logerror(err)
  2941. }
  2942. return &pet, nil
  2943. }
  2944. // PgEventTriggerByOid retrieves a row from 'pg_catalog.pg_event_trigger' as a PgEventTrigger.
  2945. //
  2946. // Generated from index 'pg_event_trigger_oid_index'.
  2947. func PgEventTriggerByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgEventTrigger, error) {
  2948. // query
  2949. const sqlstr = `SELECT ` +
  2950. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, evtname, evtevent, evtowner, evtfoid, evtenabled, evttags ` +
  2951. `FROM pg_catalog.pg_event_trigger ` +
  2952. `WHERE oid = $1`
  2953. // run
  2954. logf(sqlstr, oid)
  2955. pet := PgEventTrigger{}
  2956. 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 {
  2957. return nil, logerror(err)
  2958. }
  2959. return &pet, nil
  2960. }
  2961. // PgExtensionByExtname retrieves a row from 'pg_catalog.pg_extension' as a PgExtension.
  2962. //
  2963. // Generated from index 'pg_extension_name_index'.
  2964. func PgExtensionByExtname(ctx context.Context, db DB, extname string) (*PgExtension, error) {
  2965. // query
  2966. const sqlstr = `SELECT ` +
  2967. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition ` +
  2968. `FROM pg_catalog.pg_extension ` +
  2969. `WHERE extname = $1`
  2970. // run
  2971. logf(sqlstr, extname)
  2972. pe := PgExtension{}
  2973. 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 {
  2974. return nil, logerror(err)
  2975. }
  2976. return &pe, nil
  2977. }
  2978. // PgExtensionByOid retrieves a row from 'pg_catalog.pg_extension' as a PgExtension.
  2979. //
  2980. // Generated from index 'pg_extension_oid_index'.
  2981. func PgExtensionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgExtension, error) {
  2982. // query
  2983. const sqlstr = `SELECT ` +
  2984. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition ` +
  2985. `FROM pg_catalog.pg_extension ` +
  2986. `WHERE oid = $1`
  2987. // run
  2988. logf(sqlstr, oid)
  2989. pe := PgExtension{}
  2990. 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 {
  2991. return nil, logerror(err)
  2992. }
  2993. return &pe, nil
  2994. }
  2995. // PgForeignDataWrapperByFdwname retrieves a row from 'pg_catalog.pg_foreign_data_wrapper' as a PgForeignDataWrapper.
  2996. //
  2997. // Generated from index 'pg_foreign_data_wrapper_name_index'.
  2998. func PgForeignDataWrapperByFdwname(ctx context.Context, db DB, fdwname string) (*PgForeignDataWrapper, error) {
  2999. // query
  3000. const sqlstr = `SELECT ` +
  3001. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, fdwname, fdwowner, fdwhandler, fdwvalidator, fdwacl, fdwoptions ` +
  3002. `FROM pg_catalog.pg_foreign_data_wrapper ` +
  3003. `WHERE fdwname = $1`
  3004. // run
  3005. logf(sqlstr, fdwname)
  3006. pfdw := PgForeignDataWrapper{}
  3007. 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 {
  3008. return nil, logerror(err)
  3009. }
  3010. return &pfdw, nil
  3011. }
  3012. // PgForeignDataWrapperByOid retrieves a row from 'pg_catalog.pg_foreign_data_wrapper' as a PgForeignDataWrapper.
  3013. //
  3014. // Generated from index 'pg_foreign_data_wrapper_oid_index'.
  3015. func PgForeignDataWrapperByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgForeignDataWrapper, error) {
  3016. // query
  3017. const sqlstr = `SELECT ` +
  3018. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, fdwname, fdwowner, fdwhandler, fdwvalidator, fdwacl, fdwoptions ` +
  3019. `FROM pg_catalog.pg_foreign_data_wrapper ` +
  3020. `WHERE oid = $1`
  3021. // run
  3022. logf(sqlstr, oid)
  3023. pfdw := PgForeignDataWrapper{}
  3024. 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 {
  3025. return nil, logerror(err)
  3026. }
  3027. return &pfdw, nil
  3028. }
  3029. // PgForeignServerBySrvname retrieves a row from 'pg_catalog.pg_foreign_server' as a PgForeignServer.
  3030. //
  3031. // Generated from index 'pg_foreign_server_name_index'.
  3032. func PgForeignServerBySrvname(ctx context.Context, db DB, srvname string) (*PgForeignServer, error) {
  3033. // query
  3034. const sqlstr = `SELECT ` +
  3035. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, srvname, srvowner, srvfdw, srvtype, srvversion, srvacl, srvoptions ` +
  3036. `FROM pg_catalog.pg_foreign_server ` +
  3037. `WHERE srvname = $1`
  3038. // run
  3039. logf(sqlstr, srvname)
  3040. pfs := PgForeignServer{}
  3041. 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 {
  3042. return nil, logerror(err)
  3043. }
  3044. return &pfs, nil
  3045. }
  3046. // PgForeignServerByOid retrieves a row from 'pg_catalog.pg_foreign_server' as a PgForeignServer.
  3047. //
  3048. // Generated from index 'pg_foreign_server_oid_index'.
  3049. func PgForeignServerByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgForeignServer, error) {
  3050. // query
  3051. const sqlstr = `SELECT ` +
  3052. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, srvname, srvowner, srvfdw, srvtype, srvversion, srvacl, srvoptions ` +
  3053. `FROM pg_catalog.pg_foreign_server ` +
  3054. `WHERE oid = $1`
  3055. // run
  3056. logf(sqlstr, oid)
  3057. pfs := PgForeignServer{}
  3058. 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 {
  3059. return nil, logerror(err)
  3060. }
  3061. return &pfs, nil
  3062. }
  3063. // PgForeignTableByFtrelid retrieves a row from 'pg_catalog.pg_foreign_table' as a PgForeignTable.
  3064. //
  3065. // Generated from index 'pg_foreign_table_relid_index'.
  3066. func PgForeignTableByFtrelid(ctx context.Context, db DB, ftrelid pgtypes.Oid) (*PgForeignTable, error) {
  3067. // query
  3068. const sqlstr = `SELECT ` +
  3069. `tableoid, cmax, xmax, cmin, xmin, ctid, ftrelid, ftserver, ftoptions ` +
  3070. `FROM pg_catalog.pg_foreign_table ` +
  3071. `WHERE ftrelid = $1`
  3072. // run
  3073. logf(sqlstr, ftrelid)
  3074. pft := PgForeignTable{}
  3075. 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 {
  3076. return nil, logerror(err)
  3077. }
  3078. return &pft, nil
  3079. }
  3080. // PgIndexByIndexrelid retrieves a row from 'pg_catalog.pg_index' as a PgIndex.
  3081. //
  3082. // Generated from index 'pg_index_indexrelid_index'.
  3083. func PgIndexByIndexrelid(ctx context.Context, db DB, indexrelid pgtypes.Oid) (*PgIndex, error) {
  3084. // query
  3085. const sqlstr = `SELECT ` +
  3086. `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 ` +
  3087. `FROM pg_catalog.pg_index ` +
  3088. `WHERE indexrelid = $1`
  3089. // run
  3090. logf(sqlstr, indexrelid)
  3091. pi := PgIndex{}
  3092. 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 {
  3093. return nil, logerror(err)
  3094. }
  3095. return &pi, nil
  3096. }
  3097. // PgIndexByIndrelid retrieves a row from 'pg_catalog.pg_index' as a PgIndex.
  3098. //
  3099. // Generated from index 'pg_index_indrelid_index'.
  3100. func PgIndexByIndrelid(ctx context.Context, db DB, indrelid pgtypes.Oid) ([]*PgIndex, error) {
  3101. // query
  3102. const sqlstr = `SELECT ` +
  3103. `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 ` +
  3104. `FROM pg_catalog.pg_index ` +
  3105. `WHERE indrelid = $1`
  3106. // run
  3107. logf(sqlstr, indrelid)
  3108. rows, err := db.QueryContext(ctx, sqlstr, indrelid)
  3109. if err != nil {
  3110. return nil, logerror(err)
  3111. }
  3112. defer rows.Close()
  3113. // process
  3114. var res []*PgIndex
  3115. for rows.Next() {
  3116. pi := PgIndex{}
  3117. // scan
  3118. 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 {
  3119. return nil, logerror(err)
  3120. }
  3121. res = append(res, &pi)
  3122. }
  3123. if err := rows.Err(); err != nil {
  3124. return nil, logerror(err)
  3125. }
  3126. return res, nil
  3127. }
  3128. // PgInheritsByInhparent retrieves a row from 'pg_catalog.pg_inherits' as a PgInherit.
  3129. //
  3130. // Generated from index 'pg_inherits_parent_index'.
  3131. func PgInheritsByInhparent(ctx context.Context, db DB, inhparent pgtypes.Oid) ([]*PgInherit, error) {
  3132. // query
  3133. const sqlstr = `SELECT ` +
  3134. `tableoid, cmax, xmax, cmin, xmin, ctid, inhrelid, inhparent, inhseqno ` +
  3135. `FROM pg_catalog.pg_inherits ` +
  3136. `WHERE inhparent = $1`
  3137. // run
  3138. logf(sqlstr, inhparent)
  3139. rows, err := db.QueryContext(ctx, sqlstr, inhparent)
  3140. if err != nil {
  3141. return nil, logerror(err)
  3142. }
  3143. defer rows.Close()
  3144. // process
  3145. var res []*PgInherit
  3146. for rows.Next() {
  3147. pi := PgInherit{}
  3148. // scan
  3149. if err := rows.Scan(&pi.Tableoid, &pi.Cmax, &pi.Xmax, &pi.Cmin, &pi.Xmin, &pi.Ctid, &pi.Inhrelid, &pi.Inhparent, &pi.Inhseqno); err != nil {
  3150. return nil, logerror(err)
  3151. }
  3152. res = append(res, &pi)
  3153. }
  3154. if err := rows.Err(); err != nil {
  3155. return nil, logerror(err)
  3156. }
  3157. return res, nil
  3158. }
  3159. // PgInheritByInhrelidInhseqno retrieves a row from 'pg_catalog.pg_inherits' as a PgInherit.
  3160. //
  3161. // Generated from index 'pg_inherits_relid_seqno_index'.
  3162. func PgInheritByInhrelidInhseqno(ctx context.Context, db DB, inhrelid pgtypes.Oid, inhseqno int) (*PgInherit, error) {
  3163. // query
  3164. const sqlstr = `SELECT ` +
  3165. `tableoid, cmax, xmax, cmin, xmin, ctid, inhrelid, inhparent, inhseqno ` +
  3166. `FROM pg_catalog.pg_inherits ` +
  3167. `WHERE inhrelid = $1 AND inhseqno = $2`
  3168. // run
  3169. logf(sqlstr, inhrelid, inhseqno)
  3170. pi := PgInherit{}
  3171. 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 {
  3172. return nil, logerror(err)
  3173. }
  3174. return &pi, nil
  3175. }
  3176. // PgInitPrivByObjoidClassoidObjsubid retrieves a row from 'pg_catalog.pg_init_privs' as a PgInitPriv.
  3177. //
  3178. // Generated from index 'pg_init_privs_o_c_o_index'.
  3179. func PgInitPrivByObjoidClassoidObjsubid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int) (*PgInitPriv, error) {
  3180. // query
  3181. const sqlstr = `SELECT ` +
  3182. `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, privtype, initprivs ` +
  3183. `FROM pg_catalog.pg_init_privs ` +
  3184. `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3`
  3185. // run
  3186. logf(sqlstr, objoid, classoid, objsubid)
  3187. pip := PgInitPriv{}
  3188. 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 {
  3189. return nil, logerror(err)
  3190. }
  3191. return &pip, nil
  3192. }
  3193. // PgLanguageByLanname retrieves a row from 'pg_catalog.pg_language' as a PgLanguage.
  3194. //
  3195. // Generated from index 'pg_language_name_index'.
  3196. func PgLanguageByLanname(ctx context.Context, db DB, lanname string) (*PgLanguage, error) {
  3197. // query
  3198. const sqlstr = `SELECT ` +
  3199. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lanname, lanowner, lanispl, lanpltrusted, lanplcallfoid, laninline, lanvalidator, lanacl ` +
  3200. `FROM pg_catalog.pg_language ` +
  3201. `WHERE lanname = $1`
  3202. // run
  3203. logf(sqlstr, lanname)
  3204. pl := PgLanguage{}
  3205. 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 {
  3206. return nil, logerror(err)
  3207. }
  3208. return &pl, nil
  3209. }
  3210. // PgLanguageByOid retrieves a row from 'pg_catalog.pg_language' as a PgLanguage.
  3211. //
  3212. // Generated from index 'pg_language_oid_index'.
  3213. func PgLanguageByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgLanguage, error) {
  3214. // query
  3215. const sqlstr = `SELECT ` +
  3216. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lanname, lanowner, lanispl, lanpltrusted, lanplcallfoid, laninline, lanvalidator, lanacl ` +
  3217. `FROM pg_catalog.pg_language ` +
  3218. `WHERE oid = $1`
  3219. // run
  3220. logf(sqlstr, oid)
  3221. pl := PgLanguage{}
  3222. 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 {
  3223. return nil, logerror(err)
  3224. }
  3225. return &pl, nil
  3226. }
  3227. // PgLargeobjectByLoidPageno retrieves a row from 'pg_catalog.pg_largeobject' as a PgLargeobject.
  3228. //
  3229. // Generated from index 'pg_largeobject_loid_pn_index'.
  3230. func PgLargeobjectByLoidPageno(ctx context.Context, db DB, loid pgtypes.Oid, pageno int) (*PgLargeobject, error) {
  3231. // query
  3232. const sqlstr = `SELECT ` +
  3233. `tableoid, cmax, xmax, cmin, xmin, ctid, loid, pageno, data ` +
  3234. `FROM pg_catalog.pg_largeobject ` +
  3235. `WHERE loid = $1 AND pageno = $2`
  3236. // run
  3237. logf(sqlstr, loid, pageno)
  3238. pl := PgLargeobject{}
  3239. 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 {
  3240. return nil, logerror(err)
  3241. }
  3242. return &pl, nil
  3243. }
  3244. // PgLargeobjectMetadatumByOid retrieves a row from 'pg_catalog.pg_largeobject_metadata' as a PgLargeobjectMetadatum.
  3245. //
  3246. // Generated from index 'pg_largeobject_metadata_oid_index'.
  3247. func PgLargeobjectMetadatumByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgLargeobjectMetadatum, error) {
  3248. // query
  3249. const sqlstr = `SELECT ` +
  3250. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, lomowner, lomacl ` +
  3251. `FROM pg_catalog.pg_largeobject_metadata ` +
  3252. `WHERE oid = $1`
  3253. // run
  3254. logf(sqlstr, oid)
  3255. plm := PgLargeobjectMetadatum{}
  3256. 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 {
  3257. return nil, logerror(err)
  3258. }
  3259. return &plm, nil
  3260. }
  3261. // PgNamespaceByNspname retrieves a row from 'pg_catalog.pg_namespace' as a PgNamespace.
  3262. //
  3263. // Generated from index 'pg_namespace_nspname_index'.
  3264. func PgNamespaceByNspname(ctx context.Context, db DB, nspname string) (*PgNamespace, error) {
  3265. // query
  3266. const sqlstr = `SELECT ` +
  3267. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, nspname, nspowner, nspacl ` +
  3268. `FROM pg_catalog.pg_namespace ` +
  3269. `WHERE nspname = $1`
  3270. // run
  3271. logf(sqlstr, nspname)
  3272. pn := PgNamespace{}
  3273. 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 {
  3274. return nil, logerror(err)
  3275. }
  3276. return &pn, nil
  3277. }
  3278. // PgNamespaceByOid retrieves a row from 'pg_catalog.pg_namespace' as a PgNamespace.
  3279. //
  3280. // Generated from index 'pg_namespace_oid_index'.
  3281. func PgNamespaceByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgNamespace, error) {
  3282. // query
  3283. const sqlstr = `SELECT ` +
  3284. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, nspname, nspowner, nspacl ` +
  3285. `FROM pg_catalog.pg_namespace ` +
  3286. `WHERE oid = $1`
  3287. // run
  3288. logf(sqlstr, oid)
  3289. pn := PgNamespace{}
  3290. 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 {
  3291. return nil, logerror(err)
  3292. }
  3293. return &pn, nil
  3294. }
  3295. // PgOpclassByOpcmethodOpcnameOpcnamespace retrieves a row from 'pg_catalog.pg_opclass' as a PgOpclass.
  3296. //
  3297. // Generated from index 'pg_opclass_am_name_nsp_index'.
  3298. func PgOpclassByOpcmethodOpcnameOpcnamespace(ctx context.Context, db DB, opcmethod pgtypes.Oid, opcname string, opcnamespace pgtypes.Oid) (*PgOpclass, error) {
  3299. // query
  3300. const sqlstr = `SELECT ` +
  3301. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opcmethod, opcname, opcnamespace, opcowner, opcfamily, opcintype, opcdefault, opckeytype ` +
  3302. `FROM pg_catalog.pg_opclass ` +
  3303. `WHERE opcmethod = $1 AND opcname = $2 AND opcnamespace = $3`
  3304. // run
  3305. logf(sqlstr, opcmethod, opcname, opcnamespace)
  3306. po := PgOpclass{}
  3307. 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 {
  3308. return nil, logerror(err)
  3309. }
  3310. return &po, nil
  3311. }
  3312. // PgOpclassByOid retrieves a row from 'pg_catalog.pg_opclass' as a PgOpclass.
  3313. //
  3314. // Generated from index 'pg_opclass_oid_index'.
  3315. func PgOpclassByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOpclass, error) {
  3316. // query
  3317. const sqlstr = `SELECT ` +
  3318. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opcmethod, opcname, opcnamespace, opcowner, opcfamily, opcintype, opcdefault, opckeytype ` +
  3319. `FROM pg_catalog.pg_opclass ` +
  3320. `WHERE oid = $1`
  3321. // run
  3322. logf(sqlstr, oid)
  3323. po := PgOpclass{}
  3324. 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 {
  3325. return nil, logerror(err)
  3326. }
  3327. return &po, nil
  3328. }
  3329. // PgOperatorByOid retrieves a row from 'pg_catalog.pg_operator' as a PgOperator.
  3330. //
  3331. // Generated from index 'pg_operator_oid_index'.
  3332. func PgOperatorByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOperator, error) {
  3333. // query
  3334. const sqlstr = `SELECT ` +
  3335. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, oprname, oprnamespace, oprowner, oprkind, oprcanmerge, oprcanhash, oprleft, oprright, oprresult, oprcom, oprnegate, oprcode, oprrest, oprjoin ` +
  3336. `FROM pg_catalog.pg_operator ` +
  3337. `WHERE oid = $1`
  3338. // run
  3339. logf(sqlstr, oid)
  3340. po := PgOperator{}
  3341. 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 {
  3342. return nil, logerror(err)
  3343. }
  3344. return &po, nil
  3345. }
  3346. // PgOperatorByOprnameOprleftOprrightOprnamespace retrieves a row from 'pg_catalog.pg_operator' as a PgOperator.
  3347. //
  3348. // Generated from index 'pg_operator_oprname_l_r_n_index'.
  3349. func PgOperatorByOprnameOprleftOprrightOprnamespace(ctx context.Context, db DB, oprname string, oprleft, oprright, oprnamespace pgtypes.Oid) (*PgOperator, error) {
  3350. // query
  3351. const sqlstr = `SELECT ` +
  3352. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, oprname, oprnamespace, oprowner, oprkind, oprcanmerge, oprcanhash, oprleft, oprright, oprresult, oprcom, oprnegate, oprcode, oprrest, oprjoin ` +
  3353. `FROM pg_catalog.pg_operator ` +
  3354. `WHERE oprname = $1 AND oprleft = $2 AND oprright = $3 AND oprnamespace = $4`
  3355. // run
  3356. logf(sqlstr, oprname, oprleft, oprright, oprnamespace)
  3357. po := PgOperator{}
  3358. 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 {
  3359. return nil, logerror(err)
  3360. }
  3361. return &po, nil
  3362. }
  3363. // PgOpfamilyByOpfmethodOpfnameOpfnamespace retrieves a row from 'pg_catalog.pg_opfamily' as a PgOpfamily.
  3364. //
  3365. // Generated from index 'pg_opfamily_am_name_nsp_index'.
  3366. func PgOpfamilyByOpfmethodOpfnameOpfnamespace(ctx context.Context, db DB, opfmethod pgtypes.Oid, opfname string, opfnamespace pgtypes.Oid) (*PgOpfamily, error) {
  3367. // query
  3368. const sqlstr = `SELECT ` +
  3369. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opfmethod, opfname, opfnamespace, opfowner ` +
  3370. `FROM pg_catalog.pg_opfamily ` +
  3371. `WHERE opfmethod = $1 AND opfname = $2 AND opfnamespace = $3`
  3372. // run
  3373. logf(sqlstr, opfmethod, opfname, opfnamespace)
  3374. po := PgOpfamily{}
  3375. 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 {
  3376. return nil, logerror(err)
  3377. }
  3378. return &po, nil
  3379. }
  3380. // PgOpfamilyByOid retrieves a row from 'pg_catalog.pg_opfamily' as a PgOpfamily.
  3381. //
  3382. // Generated from index 'pg_opfamily_oid_index'.
  3383. func PgOpfamilyByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgOpfamily, error) {
  3384. // query
  3385. const sqlstr = `SELECT ` +
  3386. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, opfmethod, opfname, opfnamespace, opfowner ` +
  3387. `FROM pg_catalog.pg_opfamily ` +
  3388. `WHERE oid = $1`
  3389. // run
  3390. logf(sqlstr, oid)
  3391. po := PgOpfamily{}
  3392. 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 {
  3393. return nil, logerror(err)
  3394. }
  3395. return &po, nil
  3396. }
  3397. // PgPartitionedTableByPartrelid retrieves a row from 'pg_catalog.pg_partitioned_table' as a PgPartitionedTable.
  3398. //
  3399. // Generated from index 'pg_partitioned_table_partrelid_index'.
  3400. func PgPartitionedTableByPartrelid(ctx context.Context, db DB, partrelid pgtypes.Oid) (*PgPartitionedTable, error) {
  3401. // query
  3402. const sqlstr = `SELECT ` +
  3403. `tableoid, cmax, xmax, cmin, xmin, ctid, partrelid, partstrat, partnatts, partdefid, partattrs, partclass, partcollation, partexprs ` +
  3404. `FROM pg_catalog.pg_partitioned_table ` +
  3405. `WHERE partrelid = $1`
  3406. // run
  3407. logf(sqlstr, partrelid)
  3408. ppt := PgPartitionedTable{}
  3409. 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 {
  3410. return nil, logerror(err)
  3411. }
  3412. return &ppt, nil
  3413. }
  3414. // PgPolicyByOid retrieves a row from 'pg_catalog.pg_policy' as a PgPolicy.
  3415. //
  3416. // Generated from index 'pg_policy_oid_index'.
  3417. func PgPolicyByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPolicy, error) {
  3418. // query
  3419. const sqlstr = `SELECT ` +
  3420. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, polname, polrelid, polcmd, polpermissive, polroles, polqual, polwithcheck ` +
  3421. `FROM pg_catalog.pg_policy ` +
  3422. `WHERE oid = $1`
  3423. // run
  3424. logf(sqlstr, oid)
  3425. pp := PgPolicy{}
  3426. 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 {
  3427. return nil, logerror(err)
  3428. }
  3429. return &pp, nil
  3430. }
  3431. // PgPolicyByPolrelidPolname retrieves a row from 'pg_catalog.pg_policy' as a PgPolicy.
  3432. //
  3433. // Generated from index 'pg_policy_polrelid_polname_index'.
  3434. func PgPolicyByPolrelidPolname(ctx context.Context, db DB, polrelid pgtypes.Oid, polname string) (*PgPolicy, error) {
  3435. // query
  3436. const sqlstr = `SELECT ` +
  3437. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, polname, polrelid, polcmd, polpermissive, polroles, polqual, polwithcheck ` +
  3438. `FROM pg_catalog.pg_policy ` +
  3439. `WHERE polrelid = $1 AND polname = $2`
  3440. // run
  3441. logf(sqlstr, polrelid, polname)
  3442. pp := PgPolicy{}
  3443. 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 {
  3444. return nil, logerror(err)
  3445. }
  3446. return &pp, nil
  3447. }
  3448. // PgProcByOid retrieves a row from 'pg_catalog.pg_proc' as a PgProc.
  3449. //
  3450. // Generated from index 'pg_proc_oid_index'.
  3451. func PgProcByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgProc, error) {
  3452. // query
  3453. const sqlstr = `SELECT ` +
  3454. `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 ` +
  3455. `FROM pg_catalog.pg_proc ` +
  3456. `WHERE oid = $1`
  3457. // run
  3458. logf(sqlstr, oid)
  3459. pp := PgProc{}
  3460. 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 {
  3461. return nil, logerror(err)
  3462. }
  3463. return &pp, nil
  3464. }
  3465. // PgProcByPronameProargtypesPronamespace retrieves a row from 'pg_catalog.pg_proc' as a PgProc.
  3466. //
  3467. // Generated from index 'pg_proc_proname_args_nsp_index'.
  3468. func PgProcByPronameProargtypesPronamespace(ctx context.Context, db DB, proname string, proargtypes pgtypes.Oidvector, pronamespace pgtypes.Oid) (*PgProc, error) {
  3469. // query
  3470. const sqlstr = `SELECT ` +
  3471. `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 ` +
  3472. `FROM pg_catalog.pg_proc ` +
  3473. `WHERE proname = $1 AND proargtypes = $2 AND pronamespace = $3`
  3474. // run
  3475. logf(sqlstr, proname, proargtypes, pronamespace)
  3476. pp := PgProc{}
  3477. 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 {
  3478. return nil, logerror(err)
  3479. }
  3480. return &pp, nil
  3481. }
  3482. // PgPublicationByOid retrieves a row from 'pg_catalog.pg_publication' as a PgPublication.
  3483. //
  3484. // Generated from index 'pg_publication_oid_index'.
  3485. func PgPublicationByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPublication, error) {
  3486. // query
  3487. const sqlstr = `SELECT ` +
  3488. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, pubname, pubowner, puballtables, pubinsert, pubupdate, pubdelete, pubtruncate, pubviaroot ` +
  3489. `FROM pg_catalog.pg_publication ` +
  3490. `WHERE oid = $1`
  3491. // run
  3492. logf(sqlstr, oid)
  3493. pp := PgPublication{}
  3494. 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 {
  3495. return nil, logerror(err)
  3496. }
  3497. return &pp, nil
  3498. }
  3499. // PgPublicationByPubname retrieves a row from 'pg_catalog.pg_publication' as a PgPublication.
  3500. //
  3501. // Generated from index 'pg_publication_pubname_index'.
  3502. func PgPublicationByPubname(ctx context.Context, db DB, pubname string) (*PgPublication, error) {
  3503. // query
  3504. const sqlstr = `SELECT ` +
  3505. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, pubname, pubowner, puballtables, pubinsert, pubupdate, pubdelete, pubtruncate, pubviaroot ` +
  3506. `FROM pg_catalog.pg_publication ` +
  3507. `WHERE pubname = $1`
  3508. // run
  3509. logf(sqlstr, pubname)
  3510. pp := PgPublication{}
  3511. 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 {
  3512. return nil, logerror(err)
  3513. }
  3514. return &pp, nil
  3515. }
  3516. // PgPublicationRelByOid retrieves a row from 'pg_catalog.pg_publication_rel' as a PgPublicationRel.
  3517. //
  3518. // Generated from index 'pg_publication_rel_oid_index'.
  3519. func PgPublicationRelByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgPublicationRel, error) {
  3520. // query
  3521. const sqlstr = `SELECT ` +
  3522. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, prpubid, prrelid ` +
  3523. `FROM pg_catalog.pg_publication_rel ` +
  3524. `WHERE oid = $1`
  3525. // run
  3526. logf(sqlstr, oid)
  3527. ppr := PgPublicationRel{}
  3528. 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 {
  3529. return nil, logerror(err)
  3530. }
  3531. return &ppr, nil
  3532. }
  3533. // PgPublicationRelByPrrelidPrpubid retrieves a row from 'pg_catalog.pg_publication_rel' as a PgPublicationRel.
  3534. //
  3535. // Generated from index 'pg_publication_rel_prrelid_prpubid_index'.
  3536. func PgPublicationRelByPrrelidPrpubid(ctx context.Context, db DB, prrelid, prpubid pgtypes.Oid) (*PgPublicationRel, error) {
  3537. // query
  3538. const sqlstr = `SELECT ` +
  3539. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, prpubid, prrelid ` +
  3540. `FROM pg_catalog.pg_publication_rel ` +
  3541. `WHERE prrelid = $1 AND prpubid = $2`
  3542. // run
  3543. logf(sqlstr, prrelid, prpubid)
  3544. ppr := PgPublicationRel{}
  3545. 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 {
  3546. return nil, logerror(err)
  3547. }
  3548. return &ppr, nil
  3549. }
  3550. // PgRangeByRngtypid retrieves a row from 'pg_catalog.pg_range' as a PgRange.
  3551. //
  3552. // Generated from index 'pg_range_rngtypid_index'.
  3553. func PgRangeByRngtypid(ctx context.Context, db DB, rngtypid pgtypes.Oid) (*PgRange, error) {
  3554. // query
  3555. const sqlstr = `SELECT ` +
  3556. `tableoid, cmax, xmax, cmin, xmin, ctid, rngtypid, rngsubtype, rngcollation, rngsubopc, rngcanonical, rngsubdiff ` +
  3557. `FROM pg_catalog.pg_range ` +
  3558. `WHERE rngtypid = $1`
  3559. // run
  3560. logf(sqlstr, rngtypid)
  3561. pr := PgRange{}
  3562. 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 {
  3563. return nil, logerror(err)
  3564. }
  3565. return &pr, nil
  3566. }
  3567. // PgReplicationOriginByRoident retrieves a row from 'pg_catalog.pg_replication_origin' as a PgReplicationOrigin.
  3568. //
  3569. // Generated from index 'pg_replication_origin_roiident_index'.
  3570. func PgReplicationOriginByRoident(ctx context.Context, db DB, roident pgtypes.Oid) (*PgReplicationOrigin, error) {
  3571. // query
  3572. const sqlstr = `SELECT ` +
  3573. `tableoid, cmax, xmax, cmin, xmin, ctid, roident, roname ` +
  3574. `FROM pg_catalog.pg_replication_origin ` +
  3575. `WHERE roident = $1`
  3576. // run
  3577. logf(sqlstr, roident)
  3578. pro := PgReplicationOrigin{}
  3579. 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 {
  3580. return nil, logerror(err)
  3581. }
  3582. return &pro, nil
  3583. }
  3584. // PgReplicationOriginByRoname retrieves a row from 'pg_catalog.pg_replication_origin' as a PgReplicationOrigin.
  3585. //
  3586. // Generated from index 'pg_replication_origin_roname_index'.
  3587. func PgReplicationOriginByRoname(ctx context.Context, db DB, roname string) (*PgReplicationOrigin, error) {
  3588. // query
  3589. const sqlstr = `SELECT ` +
  3590. `tableoid, cmax, xmax, cmin, xmin, ctid, roident, roname ` +
  3591. `FROM pg_catalog.pg_replication_origin ` +
  3592. `WHERE roname = $1`
  3593. // run
  3594. logf(sqlstr, roname)
  3595. pro := PgReplicationOrigin{}
  3596. 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 {
  3597. return nil, logerror(err)
  3598. }
  3599. return &pro, nil
  3600. }
  3601. // PgRewriteByOid retrieves a row from 'pg_catalog.pg_rewrite' as a PgRewrite.
  3602. //
  3603. // Generated from index 'pg_rewrite_oid_index'.
  3604. func PgRewriteByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgRewrite, error) {
  3605. // query
  3606. const sqlstr = `SELECT ` +
  3607. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rulename, ev_class, ev_type, ev_enabled, is_instead, ev_qual, ev_action ` +
  3608. `FROM pg_catalog.pg_rewrite ` +
  3609. `WHERE oid = $1`
  3610. // run
  3611. logf(sqlstr, oid)
  3612. pr := PgRewrite{}
  3613. 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 {
  3614. return nil, logerror(err)
  3615. }
  3616. return &pr, nil
  3617. }
  3618. // PgRewriteByEvClassRulename retrieves a row from 'pg_catalog.pg_rewrite' as a PgRewrite.
  3619. //
  3620. // Generated from index 'pg_rewrite_rel_rulename_index'.
  3621. func PgRewriteByEvClassRulename(ctx context.Context, db DB, evClass pgtypes.Oid, rulename string) (*PgRewrite, error) {
  3622. // query
  3623. const sqlstr = `SELECT ` +
  3624. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, rulename, ev_class, ev_type, ev_enabled, is_instead, ev_qual, ev_action ` +
  3625. `FROM pg_catalog.pg_rewrite ` +
  3626. `WHERE ev_class = $1 AND rulename = $2`
  3627. // run
  3628. logf(sqlstr, evClass, rulename)
  3629. pr := PgRewrite{}
  3630. 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 {
  3631. return nil, logerror(err)
  3632. }
  3633. return &pr, nil
  3634. }
  3635. // PgSeclabelByObjoidClassoidObjsubidProvider retrieves a row from 'pg_catalog.pg_seclabel' as a PgSeclabel.
  3636. //
  3637. // Generated from index 'pg_seclabel_object_index'.
  3638. func PgSeclabelByObjoidClassoidObjsubidProvider(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, objsubid int, provider string) (*PgSeclabel, error) {
  3639. // query
  3640. const sqlstr = `SELECT ` +
  3641. `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, objsubid, provider, label ` +
  3642. `FROM pg_catalog.pg_seclabel ` +
  3643. `WHERE objoid = $1 AND classoid = $2 AND objsubid = $3 AND provider = $4`
  3644. // run
  3645. logf(sqlstr, objoid, classoid, objsubid, provider)
  3646. ps := PgSeclabel{}
  3647. 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 {
  3648. return nil, logerror(err)
  3649. }
  3650. return &ps, nil
  3651. }
  3652. // PgSequenceBySeqrelid retrieves a row from 'pg_catalog.pg_sequence' as a PgSequence.
  3653. //
  3654. // Generated from index 'pg_sequence_seqrelid_index'.
  3655. func PgSequenceBySeqrelid(ctx context.Context, db DB, seqrelid pgtypes.Oid) (*PgSequence, error) {
  3656. // query
  3657. const sqlstr = `SELECT ` +
  3658. `tableoid, cmax, xmax, cmin, xmin, ctid, seqrelid, seqtypid, seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle ` +
  3659. `FROM pg_catalog.pg_sequence ` +
  3660. `WHERE seqrelid = $1`
  3661. // run
  3662. logf(sqlstr, seqrelid)
  3663. ps := PgSequence{}
  3664. 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 {
  3665. return nil, logerror(err)
  3666. }
  3667. return &ps, nil
  3668. }
  3669. // PgShdependByDbidClassidObjidObjsubid retrieves a row from 'pg_catalog.pg_shdepend' as a PgShdepend.
  3670. //
  3671. // Generated from index 'pg_shdepend_depender_index'.
  3672. func PgShdependByDbidClassidObjidObjsubid(ctx context.Context, db DB, dbid, classid, objid pgtypes.Oid, objsubid int) ([]*PgShdepend, error) {
  3673. // query
  3674. const sqlstr = `SELECT ` +
  3675. `tableoid, cmax, xmax, cmin, xmin, ctid, dbid, classid, objid, objsubid, refclassid, refobjid, deptype ` +
  3676. `FROM pg_catalog.pg_shdepend ` +
  3677. `WHERE dbid = $1 AND classid = $2 AND objid = $3 AND objsubid = $4`
  3678. // run
  3679. logf(sqlstr, dbid, classid, objid, objsubid)
  3680. rows, err := db.QueryContext(ctx, sqlstr, dbid, classid, objid, objsubid)
  3681. if err != nil {
  3682. return nil, logerror(err)
  3683. }
  3684. defer rows.Close()
  3685. // process
  3686. var res []*PgShdepend
  3687. for rows.Next() {
  3688. ps := PgShdepend{}
  3689. // scan
  3690. 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 {
  3691. return nil, logerror(err)
  3692. }
  3693. res = append(res, &ps)
  3694. }
  3695. if err := rows.Err(); err != nil {
  3696. return nil, logerror(err)
  3697. }
  3698. return res, nil
  3699. }
  3700. // PgShdependByRefclassidRefobjid retrieves a row from 'pg_catalog.pg_shdepend' as a PgShdepend.
  3701. //
  3702. // Generated from index 'pg_shdepend_reference_index'.
  3703. func PgShdependByRefclassidRefobjid(ctx context.Context, db DB, refclassid, refobjid pgtypes.Oid) ([]*PgShdepend, error) {
  3704. // query
  3705. const sqlstr = `SELECT ` +
  3706. `tableoid, cmax, xmax, cmin, xmin, ctid, dbid, classid, objid, objsubid, refclassid, refobjid, deptype ` +
  3707. `FROM pg_catalog.pg_shdepend ` +
  3708. `WHERE refclassid = $1 AND refobjid = $2`
  3709. // run
  3710. logf(sqlstr, refclassid, refobjid)
  3711. rows, err := db.QueryContext(ctx, sqlstr, refclassid, refobjid)
  3712. if err != nil {
  3713. return nil, logerror(err)
  3714. }
  3715. defer rows.Close()
  3716. // process
  3717. var res []*PgShdepend
  3718. for rows.Next() {
  3719. ps := PgShdepend{}
  3720. // scan
  3721. 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 {
  3722. return nil, logerror(err)
  3723. }
  3724. res = append(res, &ps)
  3725. }
  3726. if err := rows.Err(); err != nil {
  3727. return nil, logerror(err)
  3728. }
  3729. return res, nil
  3730. }
  3731. // PgShdescriptionByObjoidClassoid retrieves a row from 'pg_catalog.pg_shdescription' as a PgShdescription.
  3732. //
  3733. // Generated from index 'pg_shdescription_o_c_index'.
  3734. func PgShdescriptionByObjoidClassoid(ctx context.Context, db DB, objoid, classoid pgtypes.Oid) (*PgShdescription, error) {
  3735. // query
  3736. const sqlstr = `SELECT ` +
  3737. `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, description ` +
  3738. `FROM pg_catalog.pg_shdescription ` +
  3739. `WHERE objoid = $1 AND classoid = $2`
  3740. // run
  3741. logf(sqlstr, objoid, classoid)
  3742. ps := PgShdescription{}
  3743. 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 {
  3744. return nil, logerror(err)
  3745. }
  3746. return &ps, nil
  3747. }
  3748. // PgShseclabelByObjoidClassoidProvider retrieves a row from 'pg_catalog.pg_shseclabel' as a PgShseclabel.
  3749. //
  3750. // Generated from index 'pg_shseclabel_object_index'.
  3751. func PgShseclabelByObjoidClassoidProvider(ctx context.Context, db DB, objoid, classoid pgtypes.Oid, provider string) (*PgShseclabel, error) {
  3752. // query
  3753. const sqlstr = `SELECT ` +
  3754. `tableoid, cmax, xmax, cmin, xmin, ctid, objoid, classoid, provider, label ` +
  3755. `FROM pg_catalog.pg_shseclabel ` +
  3756. `WHERE objoid = $1 AND classoid = $2 AND provider = $3`
  3757. // run
  3758. logf(sqlstr, objoid, classoid, provider)
  3759. ps := PgShseclabel{}
  3760. 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 {
  3761. return nil, logerror(err)
  3762. }
  3763. return &ps, nil
  3764. }
  3765. // PgStatisticByStarelidStaattnumStainherit retrieves a row from 'pg_catalog.pg_statistic' as a PgStatistic.
  3766. //
  3767. // Generated from index 'pg_statistic_relid_att_inh_index'.
  3768. func PgStatisticByStarelidStaattnumStainherit(ctx context.Context, db DB, starelid pgtypes.Oid, staattnum int16, stainherit bool) (*PgStatistic, error) {
  3769. // query
  3770. const sqlstr = `SELECT ` +
  3771. `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 ` +
  3772. `FROM pg_catalog.pg_statistic ` +
  3773. `WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3`
  3774. // run
  3775. logf(sqlstr, starelid, staattnum, stainherit)
  3776. ps := PgStatistic{}
  3777. 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 {
  3778. return nil, logerror(err)
  3779. }
  3780. return &ps, nil
  3781. }
  3782. // PgStatisticExtByStxnameStxnamespace retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
  3783. //
  3784. // Generated from index 'pg_statistic_ext_name_index'.
  3785. func PgStatisticExtByStxnameStxnamespace(ctx context.Context, db DB, stxname string, stxnamespace pgtypes.Oid) (*PgStatisticExt, error) {
  3786. // query
  3787. const sqlstr = `SELECT ` +
  3788. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
  3789. `FROM pg_catalog.pg_statistic_ext ` +
  3790. `WHERE stxname = $1 AND stxnamespace = $2`
  3791. // run
  3792. logf(sqlstr, stxname, stxnamespace)
  3793. pse := PgStatisticExt{}
  3794. 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 {
  3795. return nil, logerror(err)
  3796. }
  3797. return &pse, nil
  3798. }
  3799. // PgStatisticExtByOid retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
  3800. //
  3801. // Generated from index 'pg_statistic_ext_oid_index'.
  3802. func PgStatisticExtByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgStatisticExt, error) {
  3803. // query
  3804. const sqlstr = `SELECT ` +
  3805. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
  3806. `FROM pg_catalog.pg_statistic_ext ` +
  3807. `WHERE oid = $1`
  3808. // run
  3809. logf(sqlstr, oid)
  3810. pse := PgStatisticExt{}
  3811. 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 {
  3812. return nil, logerror(err)
  3813. }
  3814. return &pse, nil
  3815. }
  3816. // PgStatisticExtByStxrelid retrieves a row from 'pg_catalog.pg_statistic_ext' as a PgStatisticExt.
  3817. //
  3818. // Generated from index 'pg_statistic_ext_relid_index'.
  3819. func PgStatisticExtByStxrelid(ctx context.Context, db DB, stxrelid pgtypes.Oid) ([]*PgStatisticExt, error) {
  3820. // query
  3821. const sqlstr = `SELECT ` +
  3822. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, stxrelid, stxname, stxnamespace, stxowner, stxstattarget, stxkeys, stxkind ` +
  3823. `FROM pg_catalog.pg_statistic_ext ` +
  3824. `WHERE stxrelid = $1`
  3825. // run
  3826. logf(sqlstr, stxrelid)
  3827. rows, err := db.QueryContext(ctx, sqlstr, stxrelid)
  3828. if err != nil {
  3829. return nil, logerror(err)
  3830. }
  3831. defer rows.Close()
  3832. // process
  3833. var res []*PgStatisticExt
  3834. for rows.Next() {
  3835. pse := PgStatisticExt{}
  3836. // scan
  3837. 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 {
  3838. return nil, logerror(err)
  3839. }
  3840. res = append(res, &pse)
  3841. }
  3842. if err := rows.Err(); err != nil {
  3843. return nil, logerror(err)
  3844. }
  3845. return res, nil
  3846. }
  3847. // PgStatisticExtDatumByStxoid retrieves a row from 'pg_catalog.pg_statistic_ext_data' as a PgStatisticExtDatum.
  3848. //
  3849. // Generated from index 'pg_statistic_ext_data_stxoid_index'.
  3850. func PgStatisticExtDatumByStxoid(ctx context.Context, db DB, stxoid pgtypes.Oid) (*PgStatisticExtDatum, error) {
  3851. // query
  3852. const sqlstr = `SELECT ` +
  3853. `tableoid, cmax, xmax, cmin, xmin, ctid, stxoid, stxdndistinct, stxddependencies, stxdmcv ` +
  3854. `FROM pg_catalog.pg_statistic_ext_data ` +
  3855. `WHERE stxoid = $1`
  3856. // run
  3857. logf(sqlstr, stxoid)
  3858. psed := PgStatisticExtDatum{}
  3859. 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 {
  3860. return nil, logerror(err)
  3861. }
  3862. return &psed, nil
  3863. }
  3864. // PgSubscriptionByOid retrieves a row from 'pg_catalog.pg_subscription' as a PgSubscription.
  3865. //
  3866. // Generated from index 'pg_subscription_oid_index'.
  3867. func PgSubscriptionByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgSubscription, error) {
  3868. // query
  3869. const sqlstr = `SELECT ` +
  3870. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, subdbid, subname, subowner, subenabled, subconninfo, subslotname, subsynccommit, subpublications ` +
  3871. `FROM pg_catalog.pg_subscription ` +
  3872. `WHERE oid = $1`
  3873. // run
  3874. logf(sqlstr, oid)
  3875. ps := PgSubscription{}
  3876. 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 {
  3877. return nil, logerror(err)
  3878. }
  3879. return &ps, nil
  3880. }
  3881. // PgSubscriptionBySubdbidSubname retrieves a row from 'pg_catalog.pg_subscription' as a PgSubscription.
  3882. //
  3883. // Generated from index 'pg_subscription_subname_index'.
  3884. func PgSubscriptionBySubdbidSubname(ctx context.Context, db DB, subdbid pgtypes.Oid, subname string) (*PgSubscription, error) {
  3885. // query
  3886. const sqlstr = `SELECT ` +
  3887. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, subdbid, subname, subowner, subenabled, subconninfo, subslotname, subsynccommit, subpublications ` +
  3888. `FROM pg_catalog.pg_subscription ` +
  3889. `WHERE subdbid = $1 AND subname = $2`
  3890. // run
  3891. logf(sqlstr, subdbid, subname)
  3892. ps := PgSubscription{}
  3893. 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 {
  3894. return nil, logerror(err)
  3895. }
  3896. return &ps, nil
  3897. }
  3898. // PgSubscriptionRelBySrrelidSrsubid retrieves a row from 'pg_catalog.pg_subscription_rel' as a PgSubscriptionRel.
  3899. //
  3900. // Generated from index 'pg_subscription_rel_srrelid_srsubid_index'.
  3901. func PgSubscriptionRelBySrrelidSrsubid(ctx context.Context, db DB, srrelid, srsubid pgtypes.Oid) (*PgSubscriptionRel, error) {
  3902. // query
  3903. const sqlstr = `SELECT ` +
  3904. `tableoid, cmax, xmax, cmin, xmin, ctid, srsubid, srrelid, srsubstate, srsublsn ` +
  3905. `FROM pg_catalog.pg_subscription_rel ` +
  3906. `WHERE srrelid = $1 AND srsubid = $2`
  3907. // run
  3908. logf(sqlstr, srrelid, srsubid)
  3909. psr := PgSubscriptionRel{}
  3910. 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 {
  3911. return nil, logerror(err)
  3912. }
  3913. return &psr, nil
  3914. }
  3915. // PgTablespaceByOid retrieves a row from 'pg_catalog.pg_tablespace' as a PgTablespace.
  3916. //
  3917. // Generated from index 'pg_tablespace_oid_index'.
  3918. func PgTablespaceByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgTablespace, error) {
  3919. // query
  3920. const sqlstr = `SELECT ` +
  3921. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, spcname, spcowner, spcacl, spcoptions ` +
  3922. `FROM pg_catalog.pg_tablespace ` +
  3923. `WHERE oid = $1`
  3924. // run
  3925. logf(sqlstr, oid)
  3926. pt := PgTablespace{}
  3927. 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 {
  3928. return nil, logerror(err)
  3929. }
  3930. return &pt, nil
  3931. }
  3932. // PgTablespaceBySpcname retrieves a row from 'pg_catalog.pg_tablespace' as a PgTablespace.
  3933. //
  3934. // Generated from index 'pg_tablespace_spcname_index'.
  3935. func PgTablespaceBySpcname(ctx context.Context, db DB, spcname string) (*PgTablespace, error) {
  3936. // query
  3937. const sqlstr = `SELECT ` +
  3938. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, spcname, spcowner, spcacl, spcoptions ` +
  3939. `FROM pg_catalog.pg_tablespace ` +
  3940. `WHERE spcname = $1`
  3941. // run
  3942. logf(sqlstr, spcname)
  3943. pt := PgTablespace{}
  3944. 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 {
  3945. return nil, logerror(err)
  3946. }
  3947. return &pt, nil
  3948. }
  3949. // PgTransformByOid retrieves a row from 'pg_catalog.pg_transform' as a PgTransform.
  3950. //
  3951. // Generated from index 'pg_transform_oid_index'.
  3952. func PgTransformByOid(ctx context.Context, db DB, oid pgtypes.Oid) (*PgTransform, error) {
  3953. // query
  3954. const sqlstr = `SELECT ` +
  3955. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, trftype, trflang, trffromsql, trftosql ` +
  3956. `FROM pg_catalog.pg_transform ` +
  3957. `WHERE oid = $1`
  3958. // run
  3959. logf(sqlstr, oid)
  3960. pt := PgTransform{}
  3961. 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 {
  3962. return nil, logerror(err)
  3963. }
  3964. return &pt, nil
  3965. }
  3966. // PgTransformByTrftypeTrflang retrieves a row from 'pg_catalog.pg_transform' as a PgTransform.
  3967. //
  3968. // Generated from index 'pg_transform_type_lang_index'.
  3969. func PgTransformByTrftypeTrflang(ctx context.Context, db DB, trftype, trflang pgtypes.Oid) (*PgTransform, error) {
  3970. // query
  3971. const sqlstr = `SELECT ` +
  3972. `tableoid, cmax, xmax, cmin, xmin, ctid, oid, trftype, trflang, trffromsql, trftosql ` +
  3973. `FROM pg_catalog.pg_transform ` +
  3974. `WHERE trftype = $1 AND trflang = $2`
  3975. // run
  3976. logf(sqlstr, trftype, trflang)
  3977. pt := PgTransform{}
  3978. if err := db.QueryRowContext(