I686LINUX/util/I686LINUX/doc/postgresql/html/infoschema-referential-constraints.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >referential_constraints</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="parameters"
  19 HREF="infoschema-parameters.html"><LINK
  20 REL="NEXT"
  21 TITLE="role_column_grants"
  22 HREF="infoschema-role-column-grants.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-parameters.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-role-column-grants.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-REFERENTIAL-CONSTRAINTS"
  96 >32.20. <TT
  97 CLASS="LITERAL"
  98 >referential_constraints</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >referential_constraints</TT
 105 > contains all
 106    referential (foreign key) constraints in the current database that
 107    belong to a table owned by the current user.
 108   </P
 109 ><DIV
 110 CLASS="TABLE"
 111 ><A
 112 NAME="AEN26822"
 113 ></A
 114 ><P
 115 ><B
 116 >Table 32-18. <TT
 117 CLASS="LITERAL"
 118 >referential_constraints</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 >constraint_catalog</TT
 140 ></TD
 141 ><TD
 142 ><TT
 143 CLASS="LITERAL"
 144 >sql_identifier</TT
 145 ></TD
 146 ><TD
 147 >Name of the database containing the constraint (always the current database)</TD
 148 ></TR
 149 ><TR
 150 ><TD
 151 ><TT
 152 CLASS="LITERAL"
 153 >constraint_schema</TT
 154 ></TD
 155 ><TD
 156 ><TT
 157 CLASS="LITERAL"
 158 >sql_identifier</TT
 159 ></TD
 160 ><TD
 161 >Name of the schema containing the constraint</TD
 162 ></TR
 163 ><TR
 164 ><TD
 165 ><TT
 166 CLASS="LITERAL"
 167 >constraint_name</TT
 168 ></TD
 169 ><TD
 170 ><TT
 171 CLASS="LITERAL"
 172 >sql_identifier</TT
 173 ></TD
 174 ><TD
 175 >Name of the constraint</TD
 176 ></TR
 177 ><TR
 178 ><TD
 179 ><TT
 180 CLASS="LITERAL"
 181 >unique_constraint_catalog</TT
 182 ></TD
 183 ><TD
 184 ><TT
 185 CLASS="LITERAL"
 186 >sql_identifier</TT
 187 ></TD
 188 ><TD
 189 >       Name of the database that contains the unique or primary key
 190        constraint that the foreign key constraint references (always
 191        the current database)
 192       </TD
 193 ></TR
 194 ><TR
 195 ><TD
 196 ><TT
 197 CLASS="LITERAL"
 198 >unique_constraint_schema</TT
 199 ></TD
 200 ><TD
 201 ><TT
 202 CLASS="LITERAL"
 203 >sql_identifier</TT
 204 ></TD
 205 ><TD
 206 >       Name of the schema that contains the unique or primary key
 207        constraint that the foreign key constraint references
 208       </TD
 209 ></TR
 210 ><TR
 211 ><TD
 212 ><TT
 213 CLASS="LITERAL"
 214 >unique_constraint_name</TT
 215 ></TD
 216 ><TD
 217 ><TT
 218 CLASS="LITERAL"
 219 >sql_identifier</TT
 220 ></TD
 221 ><TD
 222 >       Name of the unique or primary key constraint that the foreign
 223        key constraint references
 224       </TD
 225 ></TR
 226 ><TR
 227 ><TD
 228 ><TT
 229 CLASS="LITERAL"
 230 >match_option</TT
 231 ></TD
 232 ><TD
 233 ><TT
 234 CLASS="LITERAL"
 235 >character_data</TT
 236 ></TD
 237 ><TD
 238 >       Match option of the foreign key constraint:
 239        <TT
 240 CLASS="LITERAL"
 241 >FULL</TT
 242 >, <TT
 243 CLASS="LITERAL"
 244 >PARTIAL</TT
 245 >, or
 246        <TT
 247 CLASS="LITERAL"
 248 >NONE</TT
 249 >.
 250       </TD
 251 ></TR
 252 ><TR
 253 ><TD
 254 ><TT
 255 CLASS="LITERAL"
 256 >update_rule</TT
 257 ></TD
 258 ><TD
 259 ><TT
 260 CLASS="LITERAL"
 261 >character_data</TT
 262 ></TD
 263 ><TD
 264 >       Update rule of the foreign key constraint:
 265        <TT
 266 CLASS="LITERAL"
 267 >CASCADE</TT
 268 >, <TT
 269 CLASS="LITERAL"
 270 >SET NULL</TT
 271 >,
 272        <TT
 273 CLASS="LITERAL"
 274 >SET DEFAULT</TT
 275 >, <TT
 276 CLASS="LITERAL"
 277 >RESTRICT</TT
 278 >, or
 279        <TT
 280 CLASS="LITERAL"
 281 >NO ACTION</TT
 282 >.
 283       </TD
 284 ></TR
 285 ><TR
 286 ><TD
 287 ><TT
 288 CLASS="LITERAL"
 289 >delete_rule</TT
 290 ></TD
 291 ><TD
 292 ><TT
 293 CLASS="LITERAL"
 294 >character_data</TT
 295 ></TD
 296 ><TD
 297 >       Delete rule of the foreign key constraint:
 298        <TT
 299 CLASS="LITERAL"
 300 >CASCADE</TT
 301 >, <TT
 302 CLASS="LITERAL"
 303 >SET NULL</TT
 304 >,
 305        <TT
 306 CLASS="LITERAL"
 307 >SET DEFAULT</TT
 308 >, <TT
 309 CLASS="LITERAL"
 310 >RESTRICT</TT
 311 >, or
 312        <TT
 313 CLASS="LITERAL"
 314 >NO ACTION</TT
 315 >.
 316       </TD
 317 ></TR
 318 ></TBODY
 319 ></TABLE
 320 ></DIV
 321 ></DIV
 322 ><DIV
 323 CLASS="NAVFOOTER"
 324 ><HR
 325 ALIGN="LEFT"
 326 WIDTH="100%"><TABLE
 327 SUMMARY="Footer navigation table"
 328 WIDTH="100%"
 329 BORDER="0"
 330 CELLPADDING="0"
 331 CELLSPACING="0"
 332 ><TR
 333 ><TD
 334 WIDTH="33%"
 335 ALIGN="left"
 336 VALIGN="top"
 337 ><A
 338 HREF="infoschema-parameters.html"
 339 ACCESSKEY="P"
 340 >Prev</A
 341 ></TD
 342 ><TD
 343 WIDTH="34%"
 344 ALIGN="center"
 345 VALIGN="top"
 346 ><A
 347 HREF="index.html"
 348 ACCESSKEY="H"
 349 >Home</A
 350 ></TD
 351 ><TD
 352 WIDTH="33%"
 353 ALIGN="right"
 354 VALIGN="top"
 355 ><A
 356 HREF="infoschema-role-column-grants.html"
 357 ACCESSKEY="N"
 358 >Next</A
 359 ></TD
 360 ></TR
 361 ><TR
 362 ><TD
 363 WIDTH="33%"
 364 ALIGN="left"
 365 VALIGN="top"
 366 ><TT
 367 CLASS="LITERAL"
 368 >parameters</TT
 369 ></TD
 370 ><TD
 371 WIDTH="34%"
 372 ALIGN="center"
 373 VALIGN="top"
 374 ><A
 375 HREF="information-schema.html"
 376 ACCESSKEY="U"
 377 >Up</A
 378 ></TD
 379 ><TD
 380 WIDTH="33%"
 381 ALIGN="right"
 382 VALIGN="top"
 383 ><TT
 384 CLASS="LITERAL"
 385 >role_column_grants</TT
 386 ></TD
 387 ></TR
 388 ></TABLE
 389 ></DIV
 390 ></BODY
 391 ></HTML
 392 >