I386LINUX/util/I386LINUX/doc/postgresql/html/catalog-pg-attrdef.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >pg_attrdef</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="System Catalogs"
  16 HREF="catalogs.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="pg_amproc"
  19 HREF="catalog-pg-amproc.html"><LINK
  20 REL="NEXT"
  21 TITLE="pg_attribute"
  22 HREF="catalog-pg-attribute.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="catalog-pg-amproc.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="catalogs.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 43. System Catalogs</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="catalogs.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="catalog-pg-attribute.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="CATALOG-PG-ATTRDEF"
  96 >43.6. <TT
  97 CLASS="STRUCTNAME"
  98 >pg_attrdef</TT
  99 ></A
 100 ></H1
 101 ><A
 102 NAME="AEN49224"
 103 ></A
 104 ><P
 105 >   The catalog <TT
 106 CLASS="STRUCTNAME"
 107 >pg_attrdef</TT
 108 > stores column default values.  The main information
 109    about columns is stored in <TT
 110 CLASS="STRUCTNAME"
 111 >pg_attribute</TT
 112 >
 113    (see below).  Only columns that explicitly specify a default value
 114    (when the table is created or the column is added) will have an
 115    entry here.
 116   </P
 117 ><DIV
 118 CLASS="TABLE"
 119 ><A
 120 NAME="AEN49229"
 121 ></A
 122 ><P
 123 ><B
 124 >Table 43-6. <TT
 125 CLASS="STRUCTNAME"
 126 >pg_attrdef</TT
 127 > Columns</B
 128 ></P
 129 ><TABLE
 130 BORDER="1"
 131 CLASS="CALSTABLE"
 132 ><COL><COL><COL><COL><THEAD
 133 ><TR
 134 ><TH
 135 >Name</TH
 136 ><TH
 137 >Type</TH
 138 ><TH
 139 >References</TH
 140 ><TH
 141 >Description</TH
 142 ></TR
 143 ></THEAD
 144 ><TBODY
 145 ><TR
 146 ><TD
 147 ><TT
 148 CLASS="STRUCTFIELD"
 149 >adrelid</TT
 150 ></TD
 151 ><TD
 152 ><TT
 153 CLASS="TYPE"
 154 >oid</TT
 155 ></TD
 156 ><TD
 157 ><TT
 158 CLASS="LITERAL"
 159 ><A
 160 HREF="catalog-pg-class.html"
 161 ><TT
 162 CLASS="STRUCTNAME"
 163 >pg_class</TT
 164 ></A
 165 >.oid</TT
 166 ></TD
 167 ><TD
 168 >The table this column belongs to</TD
 169 ></TR
 170 ><TR
 171 ><TD
 172 ><TT
 173 CLASS="STRUCTFIELD"
 174 >adnum</TT
 175 ></TD
 176 ><TD
 177 ><TT
 178 CLASS="TYPE"
 179 >int2</TT
 180 ></TD
 181 ><TD
 182 ><TT
 183 CLASS="LITERAL"
 184 ><A
 185 HREF="catalog-pg-attribute.html"
 186 ><TT
 187 CLASS="STRUCTNAME"
 188 >pg_attribute</TT
 189 ></A
 190 >.attnum</TT
 191 ></TD
 192 ><TD
 193 >The number of the column</TD
 194 ></TR
 195 ><TR
 196 ><TD
 197 ><TT
 198 CLASS="STRUCTFIELD"
 199 >adbin</TT
 200 ></TD
 201 ><TD
 202 ><TT
 203 CLASS="TYPE"
 204 >text</TT
 205 ></TD
 206 ><TD
 207 >&nbsp;</TD
 208 ><TD
 209 >The internal representation of the column default value</TD
 210 ></TR
 211 ><TR
 212 ><TD
 213 ><TT
 214 CLASS="STRUCTFIELD"
 215 >adsrc</TT
 216 ></TD
 217 ><TD
 218 ><TT
 219 CLASS="TYPE"
 220 >text</TT
 221 ></TD
 222 ><TD
 223 >&nbsp;</TD
 224 ><TD
 225 >A human-readable representation of the default value</TD
 226 ></TR
 227 ></TBODY
 228 ></TABLE
 229 ></DIV
 230 ></DIV
 231 ><DIV
 232 CLASS="NAVFOOTER"
 233 ><HR
 234 ALIGN="LEFT"
 235 WIDTH="100%"><TABLE
 236 SUMMARY="Footer navigation table"
 237 WIDTH="100%"
 238 BORDER="0"
 239 CELLPADDING="0"
 240 CELLSPACING="0"
 241 ><TR
 242 ><TD
 243 WIDTH="33%"
 244 ALIGN="left"
 245 VALIGN="top"
 246 ><A
 247 HREF="catalog-pg-amproc.html"
 248 ACCESSKEY="P"
 249 >Prev</A
 250 ></TD
 251 ><TD
 252 WIDTH="34%"
 253 ALIGN="center"
 254 VALIGN="top"
 255 ><A
 256 HREF="index.html"
 257 ACCESSKEY="H"
 258 >Home</A
 259 ></TD
 260 ><TD
 261 WIDTH="33%"
 262 ALIGN="right"
 263 VALIGN="top"
 264 ><A
 265 HREF="catalog-pg-attribute.html"
 266 ACCESSKEY="N"
 267 >Next</A
 268 ></TD
 269 ></TR
 270 ><TR
 271 ><TD
 272 WIDTH="33%"
 273 ALIGN="left"
 274 VALIGN="top"
 275 ><TT
 276 CLASS="STRUCTNAME"
 277 >pg_amproc</TT
 278 ></TD
 279 ><TD
 280 WIDTH="34%"
 281 ALIGN="center"
 282 VALIGN="top"
 283 ><A
 284 HREF="catalogs.html"
 285 ACCESSKEY="U"
 286 >Up</A
 287 ></TD
 288 ><TD
 289 WIDTH="33%"
 290 ALIGN="right"
 291 VALIGN="top"
 292 ><TT
 293 CLASS="STRUCTNAME"
 294 >pg_attribute</TT
 295 ></TD
 296 ></TR
 297 ></TABLE
 298 ></DIV
 299 ></BODY
 300 ></HTML
 301 >