I386LINUX/util/I386LINUX/doc/postgresql/html/infoschema-tables.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >tables</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="The Information Schema"
  16 HREF="information-schema.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="table_privileges"
  19 HREF="infoschema-table-privileges.html"><LINK
  20 REL="NEXT"
  21 TITLE="triggers"
  22 HREF="infoschema-triggers.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="infoschema-table-privileges.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="information-schema.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 32. The Information Schema</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="information-schema.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="infoschema-triggers.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="INFOSCHEMA-TABLES"
  96 >32.36. <TT
  97 CLASS="LITERAL"
  98 >tables</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >tables</TT
 105 > contains all tables and views
 106    defined in the current database.  Only those tables and views are
 107    shown that the current user has access to (by way of being the
 108    owner or having some privilege).
 109   </P
 110 ><DIV
 111 CLASS="TABLE"
 112 ><A
 113 NAME="AEN28161"
 114 ></A
 115 ><P
 116 ><B
 117 >Table 32-34. <TT
 118 CLASS="LITERAL"
 119 >tables</TT
 120 > Columns</B
 121 ></P
 122 ><TABLE
 123 BORDER="1"
 124 CLASS="CALSTABLE"
 125 ><COL><COL><COL><THEAD
 126 ><TR
 127 ><TH
 128 >Name</TH
 129 ><TH
 130 >Data Type</TH
 131 ><TH
 132 >Description</TH
 133 ></TR
 134 ></THEAD
 135 ><TBODY
 136 ><TR
 137 ><TD
 138 ><TT
 139 CLASS="LITERAL"
 140 >table_catalog</TT
 141 ></TD
 142 ><TD
 143 ><TT
 144 CLASS="TYPE"
 145 >sql_identifier</TT
 146 ></TD
 147 ><TD
 148 >Name of the database that contains the table (always the current database)</TD
 149 ></TR
 150 ><TR
 151 ><TD
 152 ><TT
 153 CLASS="LITERAL"
 154 >table_schema</TT
 155 ></TD
 156 ><TD
 157 ><TT
 158 CLASS="TYPE"
 159 >sql_identifier</TT
 160 ></TD
 161 ><TD
 162 >Name of the schema that contains the table</TD
 163 ></TR
 164 ><TR
 165 ><TD
 166 ><TT
 167 CLASS="LITERAL"
 168 >table_name</TT
 169 ></TD
 170 ><TD
 171 ><TT
 172 CLASS="TYPE"
 173 >sql_identifier</TT
 174 ></TD
 175 ><TD
 176 >Name of the table</TD
 177 ></TR
 178 ><TR
 179 ><TD
 180 ><TT
 181 CLASS="LITERAL"
 182 >table_type</TT
 183 ></TD
 184 ><TD
 185 ><TT
 186 CLASS="TYPE"
 187 >character_data</TT
 188 ></TD
 189 ><TD
 190 >       Type of the table: <TT
 191 CLASS="LITERAL"
 192 >BASE TABLE</TT
 193 > for a
 194        persistent base table (the normal table type),
 195        <TT
 196 CLASS="LITERAL"
 197 >VIEW</TT
 198 > for a view, or <TT
 199 CLASS="LITERAL"
 200 >LOCAL
 201        TEMPORARY</TT
 202 > for a temporary table
 203       </TD
 204 ></TR
 205 ><TR
 206 ><TD
 207 ><TT
 208 CLASS="LITERAL"
 209 >self_referencing_column_name</TT
 210 ></TD
 211 ><TD
 212 ><TT
 213 CLASS="TYPE"
 214 >sql_identifier</TT
 215 ></TD
 216 ><TD
 217 >Applies to a feature not available in PostgreSQL</TD
 218 ></TR
 219 ><TR
 220 ><TD
 221 ><TT
 222 CLASS="LITERAL"
 223 >reference_generation</TT
 224 ></TD
 225 ><TD
 226 ><TT
 227 CLASS="TYPE"
 228 >character_data</TT
 229 ></TD
 230 ><TD
 231 >Applies to a feature not available in PostgreSQL</TD
 232 ></TR
 233 ><TR
 234 ><TD
 235 ><TT
 236 CLASS="LITERAL"
 237 >user_defined_type_catalog</TT
 238 ></TD
 239 ><TD
 240 ><TT
 241 CLASS="TYPE"
 242 >sql_identifier</TT
 243 ></TD
 244 ><TD
 245 >Applies to a feature not available in PostgreSQL</TD
 246 ></TR
 247 ><TR
 248 ><TD
 249 ><TT
 250 CLASS="LITERAL"
 251 >user_defined_type_schema</TT
 252 ></TD
 253 ><TD
 254 ><TT
 255 CLASS="TYPE"
 256 >sql_identifier</TT
 257 ></TD
 258 ><TD
 259 >Applies to a feature not available in PostgreSQL</TD
 260 ></TR
 261 ><TR
 262 ><TD
 263 ><TT
 264 CLASS="LITERAL"
 265 >user_defined_type_name</TT
 266 ></TD
 267 ><TD
 268 ><TT
 269 CLASS="TYPE"
 270 >sql_identifier</TT
 271 ></TD
 272 ><TD
 273 >Applies to a feature not available in PostgreSQL</TD
 274 ></TR
 275 ></TBODY
 276 ></TABLE
 277 ></DIV
 278 ></DIV
 279 ><DIV
 280 CLASS="NAVFOOTER"
 281 ><HR
 282 ALIGN="LEFT"
 283 WIDTH="100%"><TABLE
 284 SUMMARY="Footer navigation table"
 285 WIDTH="100%"
 286 BORDER="0"
 287 CELLPADDING="0"
 288 CELLSPACING="0"
 289 ><TR
 290 ><TD
 291 WIDTH="33%"
 292 ALIGN="left"
 293 VALIGN="top"
 294 ><A
 295 HREF="infoschema-table-privileges.html"
 296 ACCESSKEY="P"
 297 >Prev</A
 298 ></TD
 299 ><TD
 300 WIDTH="34%"
 301 ALIGN="center"
 302 VALIGN="top"
 303 ><A
 304 HREF="index.html"
 305 ACCESSKEY="H"
 306 >Home</A
 307 ></TD
 308 ><TD
 309 WIDTH="33%"
 310 ALIGN="right"
 311 VALIGN="top"
 312 ><A
 313 HREF="infoschema-triggers.html"
 314 ACCESSKEY="N"
 315 >Next</A
 316 ></TD
 317 ></TR
 318 ><TR
 319 ><TD
 320 WIDTH="33%"
 321 ALIGN="left"
 322 VALIGN="top"
 323 ><TT
 324 CLASS="LITERAL"
 325 >table_privileges</TT
 326 ></TD
 327 ><TD
 328 WIDTH="34%"
 329 ALIGN="center"
 330 VALIGN="top"
 331 ><A
 332 HREF="information-schema.html"
 333 ACCESSKEY="U"
 334 >Up</A
 335 ></TD
 336 ><TD
 337 WIDTH="33%"
 338 ALIGN="right"
 339 VALIGN="top"
 340 ><TT
 341 CLASS="LITERAL"
 342 >triggers</TT
 343 ></TD
 344 ></TR
 345 ></TABLE
 346 ></DIV
 347 ></BODY
 348 ></HTML
 349 >