summaryrefslogtreecommitdiff
path: root/pgsql_mib_pieces/pg_attribute.tbldef
diff options
context:
space:
mode:
Diffstat (limited to 'pgsql_mib_pieces/pg_attribute.tbldef')
-rw-r--r--pgsql_mib_pieces/pg_attribute.tbldef18
1 files changed, 18 insertions, 0 deletions
diff --git a/pgsql_mib_pieces/pg_attribute.tbldef b/pgsql_mib_pieces/pg_attribute.tbldef
new file mode 100644
index 0000000..cb98327
--- /dev/null
+++ b/pgsql_mib_pieces/pg_attribute.tbldef
@@ -0,0 +1,18 @@
+pg_attribute "The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row for every column in every table in the database. (There will also be attribute entries for indexes, and indeed all objects that have pg_class entries.) The term attribute is equivalent to column and is used for historical reasons." "pg_attribute entry" pgsqlCatalogTables 6 "pgsnmpdConnID, rdbmsDbIndex, pgsqlPgAttributeAttrelid, pgsqlPgAttributeAttname"
+attrelid INTEGER "The table this column belongs to"
+attname DisplayString "The column name"
+atttypid INTEGER "The data type of this column"
+attstattarget INTEGER "attstattarget controls the level of detail of statistics accumulated for this column by ANALYZE . A zero value indicates that no statistics should be collected. A negative value says to use the system default statistics target. The exact meaning of positive values is data type-dependent. For scalar data types, attstattarget is both the target number of ""most common values"" to collect, and the target number of histogram bins to create"
+attlen INTEGER "A copy of pg_type.typlen of this column's type"
+attnum INTEGER "The number of the column. Ordinary columns are numbered from 1 up. System columns, such as oid , have (arbitrary) negative numbers"
+attndims INTEGER "Number of dimensions, if the column is an array type; otherwise 0. (Presently, the number of dimensions of an array is not enforced, so any nonzero value effectively means ""it's an array"" )"
+attcacheoff INTEGER "Always -1 in storage, but when loaded into a row descriptor in memory this may be updated to cache the offset of the attribute within the row"
+atttypmod INTEGER "atttypmod records type-specific data supplied at table creation time (for example, the maximum length of a varchar column). It is passed to type-specific input functions and length coercion functions. The value will generally be -1 for types that do not need atttypmod"
+attbyval TruthValue "A copy of pg_type.typbyval of this column's type"
+attstorage DisplayString "Normally a copy of pg_type.typstorage of this column's type. For TOAST-able data types, this can be altered after column creation to control storage policy"
+attalign DisplayString "A copy of pg_type.typalign of this column's type"
+attnotnull TruthValue "This represents a not-null constraint. It is possible to change this column to enable or disable the constraint"
+atthasdef TruthValue "This column has a default value, in which case there will be a corresponding entry in the pg_attrdef catalog that actually defines the value"
+attisdropped TruthValue "This column has been dropped and is no longer valid. A dropped column is still physically present in the table, but is ignored by the parser and so cannot be accessed via SQL"
+attislocal INTEGER "This column is defined locally in the relation. Note that a column may be locally defined and inherited simultaneously"
+attinhcount INTEGER "The number of direct ancestors this column has. A column with a nonzero number of ancestors cannot be dropped nor renamed"