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

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >views</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="view_table_usage"
  19 HREF="infoschema-view-table-usage.html"><LINK
  20 REL="NEXT"
  21 TITLE="Server Programming"
  22 HREF="server-programming.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-view-table-usage.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="server-programming.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-VIEWS"
  96 >32.41. <TT
  97 CLASS="LITERAL"
  98 >views</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >views</TT
 105 > contains all views defined in the
 106    current database.  Only those views are shown that the current user
 107    has access to (by way of being the owner or having some privilege).
 108   </P
 109 ><DIV
 110 CLASS="TABLE"
 111 ><A
 112 NAME="AEN28537"
 113 ></A
 114 ><P
 115 ><B
 116 >Table 32-39. <TT
 117 CLASS="LITERAL"
 118 >views</TT
 119 > Columns</B
 120 ></P
 121 ><TABLE
 122 BORDER="1"
 123 CLASS="CALSTABLE"
 124 ><COL><COL><COL><THEAD
 125 ><TR
 126 ><TH
 127 >Name</TH
 128 ><TH
 129 >Data Type</TH
 130 ><TH
 131 >Description</TH
 132 ></TR
 133 ></THEAD
 134 ><TBODY
 135 ><TR
 136 ><TD
 137 ><TT
 138 CLASS="LITERAL"
 139 >table_catalog</TT
 140 ></TD
 141 ><TD
 142 ><TT
 143 CLASS="TYPE"
 144 >sql_identifier</TT
 145 ></TD
 146 ><TD
 147 >Name of the database that contains the view (always the current database)</TD
 148 ></TR
 149 ><TR
 150 ><TD
 151 ><TT
 152 CLASS="LITERAL"
 153 >table_schema</TT
 154 ></TD
 155 ><TD
 156 ><TT
 157 CLASS="TYPE"
 158 >sql_identifier</TT
 159 ></TD
 160 ><TD
 161 >Name of the schema that contains the view</TD
 162 ></TR
 163 ><TR
 164 ><TD
 165 ><TT
 166 CLASS="LITERAL"
 167 >table_name</TT
 168 ></TD
 169 ><TD
 170 ><TT
 171 CLASS="TYPE"
 172 >sql_identifier</TT
 173 ></TD
 174 ><TD
 175 >Name of the view</TD
 176 ></TR
 177 ><TR
 178 ><TD
 179 ><TT
 180 CLASS="LITERAL"
 181 >view definition</TT
 182 ></TD
 183 ><TD
 184 ><TT
 185 CLASS="TYPE"
 186 >character_data</TT
 187 ></TD
 188 ><TD
 189 >       Query expression defining the view (null if the current user is
 190        not the owner of the view)
 191       </TD
 192 ></TR
 193 ><TR
 194 ><TD
 195 ><TT
 196 CLASS="LITERAL"
 197 >check_option</TT
 198 ></TD
 199 ><TD
 200 ><TT
 201 CLASS="TYPE"
 202 >character_data</TT
 203 ></TD
 204 ><TD
 205 >Applies to a feature not available in PostgreSQL</TD
 206 ></TR
 207 ><TR
 208 ><TD
 209 ><TT
 210 CLASS="LITERAL"
 211 >is_updatable</TT
 212 ></TD
 213 ><TD
 214 ><TT
 215 CLASS="TYPE"
 216 >character_data</TT
 217 ></TD
 218 ><TD
 219 >Not yet implemented</TD
 220 ></TR
 221 ><TR
 222 ><TD
 223 ><TT
 224 CLASS="LITERAL"
 225 >is_insertable_into</TT
 226 ></TD
 227 ><TD
 228 ><TT
 229 CLASS="TYPE"
 230 >character_data</TT
 231 ></TD
 232 ><TD
 233 >Not yet implemented</TD
 234 ></TR
 235 ></TBODY
 236 ></TABLE
 237 ></DIV
 238 ></DIV
 239 ><DIV
 240 CLASS="NAVFOOTER"
 241 ><HR
 242 ALIGN="LEFT"
 243 WIDTH="100%"><TABLE
 244 SUMMARY="Footer navigation table"
 245 WIDTH="100%"
 246 BORDER="0"
 247 CELLPADDING="0"
 248 CELLSPACING="0"
 249 ><TR
 250 ><TD
 251 WIDTH="33%"
 252 ALIGN="left"
 253 VALIGN="top"
 254 ><A
 255 HREF="infoschema-view-table-usage.html"
 256 ACCESSKEY="P"
 257 >Prev</A
 258 ></TD
 259 ><TD
 260 WIDTH="34%"
 261 ALIGN="center"
 262 VALIGN="top"
 263 ><A
 264 HREF="index.html"
 265 ACCESSKEY="H"
 266 >Home</A
 267 ></TD
 268 ><TD
 269 WIDTH="33%"
 270 ALIGN="right"
 271 VALIGN="top"
 272 ><A
 273 HREF="server-programming.html"
 274 ACCESSKEY="N"
 275 >Next</A
 276 ></TD
 277 ></TR
 278 ><TR
 279 ><TD
 280 WIDTH="33%"
 281 ALIGN="left"
 282 VALIGN="top"
 283 ><TT
 284 CLASS="LITERAL"
 285 >view_table_usage</TT
 286 ></TD
 287 ><TD
 288 WIDTH="34%"
 289 ALIGN="center"
 290 VALIGN="top"
 291 ><A
 292 HREF="information-schema.html"
 293 ACCESSKEY="U"
 294 >Up</A
 295 ></TD
 296 ><TD
 297 WIDTH="33%"
 298 ALIGN="right"
 299 VALIGN="top"
 300 >Server Programming</TD
 301 ></TR
 302 ></TABLE
 303 ></DIV
 304 ></BODY
 305 ></HTML
 306 >