diff options
Diffstat (limited to 'pgsql_mib_pieces/pg_attribute.tbldef')
-rw-r--r-- | pgsql_mib_pieces/pg_attribute.tbldef | 18 |
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" |