I386LINUX/util/I386LINUX/doc/postgresql/html/infoschema-constraint-table-usage.html

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