summaryrefslogtreecommitdiff
path: root/pgsql_mib_pieces/pg_attrdef.mib
blob: 7a3a71bdfb676caf222a993004cc5556ac5f9c2f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
pgsqlPgAttrdefTable		OBJECT-TYPE
	SYNTAX		SEQUENCE OF pgsqlPgAttrdefEntry
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute (see below). Only columns that explicitly specify a default value (when the table is created or the column is added) will have an entry here."
	::= { pgsqlCatalogTables 5 }

pgsqlPgAttrdefEntry		OBJECT-TYPE
	SYNTAX		PgsqlPgAttrdefEntry
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"pg_attrdef entry"
	INDEX  { pgsnmpdConnID, rdbmsDbIndex, pgsqlPgAttrdefEntryOID }
	::= { pgsqlPgAttrdefTable 1 }

PgsqlPgAttrdefEntry ::=
	SEQUENCE {
		pgsqlPgAttrdefEntryOID		INTEGER,
		pgsqlPgAttrdefAdrelid		INTEGER,
		pgsqlPgAttrdefAdnum		INTEGER,
		pgsqlPgAttrdefAdbin		DisplayString,
		pgsqlPgAttrdefAdsrc		DisplayString
	}

pgsqlPgAttrdefEntryOID			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"OID of this entry"
	::= { pgsqlPgAttrdefEntry 1 }

pgsqlPgAttrdefAdrelid			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The table this column belongs to"
	::= { pgsqlPgAttrdefEntry 2 }

pgsqlPgAttrdefAdnum			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The number of the column"
	::= { pgsqlPgAttrdefEntry 3 }

pgsqlPgAttrdefAdbin			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The internal representation of the column default value"
	::= { pgsqlPgAttrdefEntry 4 }

pgsqlPgAttrdefAdsrc			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"A human-readable representation of the default value"
	::= { pgsqlPgAttrdefEntry 5 }


---------------------------------------