Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
149 lines (147 sloc) 4.65 KB
queries:
-
name: pgsqlPgAggregateTable
query: SELECT aggfnoid::integer, aggtransfn, aggfinalfn, aggsortop, aggtranstype, agginitval FROM pg_aggregate
oid: 1.3.6.1.4.1.27645.1.2.1
indexes: 1
min_column: 1
-
name: pgsqlPgAmTable
query: SELECT oid, * from pg_am
oid: 1.3.6.1.4.1.27645.1.2.2
indexes: 1
min_column: 1
## -
## name: rdbmsDbTable
## query: SELECT oid, '1.3.6.1.4.1', 'PostgreSQL', datname, 'josh@pgsnmpd' FROM pg_database
## oid: 1.3.6.1.2.1.39.1.1
## indexes: 1
## min_column: 1
## -
## name: rdbmsDbInfoTable
## query: SELECT oid, version(), pg_database_size(datname) FROM pg_database
## oid: 1.3.6.1.2.1.39.1.2
## indexes: 1
## min_column: 1
## -
## name: rdbmsDbParamTable
## query: SELECT oid, datname, datconfig FROM pg_database
## oid: 1.3.6.1.2.1.39.1.3
## indexes: 1
## min_column: 1
## -
## name: pg_database
## query: SELECT oid, encoding, datdba, * FROM pg_database
## oid: 1.3.6.1.4.1.27645.1.3.1
## indexes: 1
## min_column: 1
## types:
## -
## colnum: 1
## type: oid
# -
## colnum: 2
## type: string
# -
# name: random
# query: SELECT 1, '1.3.6.1.3.11', 2, floor(100 * random()) union select 2, '1.3.6.1.2.1', floor(random() * 10), 5
# oid: 1.3.6.1.4.1.27645.1.3.2
# indexes: 1
# min_column: 1
# types:
# -
# 1: ASN_INTEGER
# #2: ASN_OBJECT_ID
# 2: ASN_OCTET_STR
# 3: ASN_INTEGER
# -
# name: pg_class
# query: SELECT oid, reltuples, reltoastrelid, 'test string', * FROM pg_class
# oid: 1.3.6.1.4.1.27645.1.3.3
# indexes: 1
# min_column: 1
# -
# name: test
# query: SELECT 'test', 't'::boolean, 14
# oid: 1.3.6.1.4.1.27646.1.1
# indexes: 1
# min_column: 1
# -
# name: easytest
# query: SELECT 1, 'test', 't'::boolean, random() UNION SELECT 2, 'test2', 'f'::boolean, random()
# oid: 1.3.6.1.4.1.27646.1.2
# indexes: 1
# min_column: 1
## -
## name: pgsqlPgAmopTable
## query: SELECT oid, amopfamily, amoplefttype, amoprighttype , amopstrategy , amopreqcheck , amopopr, amopmethod FROM pg_amop LIMIT 4
## oid: 1.3.6.1.4.1.27645.1.2.3
## indexes: 1
## min_column: 1
## -
## name: rdbmsDbTable
## query: SELECT oid, '1.3.6.1.4.1', 'PostgreSQL', datname, 'josh@pgsnmpd' FROM pg_database
## oid: 1.3.6.1.2.1.39.1.1
## indexes: 1
## min_column: 1
## -
## name: rdbmsDbInfoTable
## query: SELECT oid, version(), pg_database_size(datname) FROM pg_database
## oid: 1.3.6.1.2.1.39.1.2
## indexes: 1
## min_column: 1
## -
## name: rdbmsDbParamTable
## query: SELECT oid, datname, datconfig FROM pg_database
## oid: 1.3.6.1.2.1.39.1.3
## indexes: 1
## min_column: 1
## -
## name: pg_database
## query: SELECT oid, encoding, datdba, * FROM pg_database
## oid: 1.3.6.1.4.1.27645.1.3.1
## indexes: 1
## min_column: 1
## types:
## -
## colnum: 1
## type: oid
# -
## colnum: 2
## type: string
# -
# name: random
# query: SELECT 1, '1.3.6.1.3.11', 2, floor(100 * random()) union select 2, '1.3.6.1.2.1', floor(random() * 10), 5
# oid: 1.3.6.1.4.1.27645.1.3.2
# indexes: 1
# min_column: 1
# types:
# -
# 1: ASN_INTEGER
# #2: ASN_OBJECT_ID
# 2: ASN_OCTET_STR
# 3: ASN_INTEGER
# -
# name: pg_class
# query: SELECT oid, reltuples, reltoastrelid, 'test string', * FROM pg_class
# oid: 1.3.6.1.4.1.27645.1.3.3
# indexes: 1
# min_column: 1
# -
# name: test
# query: SELECT 'test', 't'::boolean, 14
# oid: 1.3.6.1.4.1.27646.1.1
# indexes: 1
# min_column: 1
# -
# name: easytest
# query: SELECT 1, 'test', 't'::boolean, random() UNION SELECT 2, 'test2', 'f'::boolean, random()
# oid: 1.3.6.1.4.1.27646.1.2
# indexes: 1
# min_column: 1
## -
## name: pgsqlPgAmopTable
## query: SELECT oid, amopfamily, amoplefttype, amoprighttype , amopstrategy , amopreqcheck , amopopr, amopmethod FROM pg_amop LIMIT 4
## oid: 1.3.6.1.4.1.27645.1.2.3
## indexes: 1
## min_column: 1
Something went wrong with that request. Please try again.