codekingpro/portable-devtools

1<?xml version="1.0" encoding="UTF-8" standalone="no"?>2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>37.34. referential_constraints</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="infoschema-parameters.html" title="37.33. parameters" /><link rel="next" href="infoschema-role-column-grants.html" title="37.35. role_column_grants" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">37.34. <code class="literal">referential_constraints</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-parameters.html" title="37.33. parameters">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 37. The Information Schema</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-role-column-grants.html" title="37.35. role_column_grants">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-REFERENTIAL-CONSTRAINTS"><div class="titlepage"><div><div><h2 class="title" style="clear: both">37.34. <code class="literal">referential_constraints</code> <a href="#INFOSCHEMA-REFERENTIAL-CONSTRAINTS" class="id_link">#</a></h2></div></div></div><p>3   The view <code class="literal">referential_constraints</code> contains all4   referential (foreign key) constraints in the current database.5   Only those constraints are shown for which the current user has6   write access to the referencing table (by way of being the7   owner or having some privilege other than <code class="literal">SELECT</code>).8  </p><div class="table" id="id-1.7.6.38.3"><p class="title"><strong>Table 37.32. <code class="structname">referential_constraints</code> Columns</strong></p><div class="table-contents"><table class="table" summary="referential_constraints Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">9       Column Type10      </p>11      <p>12       Description13      </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">14       <code class="structfield">constraint_catalog</code> <code class="type">sql_identifier</code>15      </p>16      <p>17       Name of the database containing the constraint (always the current database)18      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">19       <code class="structfield">constraint_schema</code> <code class="type">sql_identifier</code>20      </p>21      <p>22       Name of the schema containing the constraint23      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">24       <code class="structfield">constraint_name</code> <code class="type">sql_identifier</code>25      </p>26      <p>27       Name of the constraint28      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">29       <code class="structfield">unique_constraint_catalog</code> <code class="type">sql_identifier</code>30      </p>31      <p>32       Name of the database that contains the unique or primary key33       constraint that the foreign key constraint references (always34       the current database)35      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">36       <code class="structfield">unique_constraint_schema</code> <code class="type">sql_identifier</code>37      </p>38      <p>39       Name of the schema that contains the unique or primary key40       constraint that the foreign key constraint references41      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">42       <code class="structfield">unique_constraint_name</code> <code class="type">sql_identifier</code>43      </p>44      <p>45       Name of the unique or primary key constraint that the foreign46       key constraint references47      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">48       <code class="structfield">match_option</code> <code class="type">character_data</code>49      </p>50      <p>51       Match option of the foreign key constraint:52       <code class="literal">FULL</code>, <code class="literal">PARTIAL</code>, or53       <code class="literal">NONE</code>.54      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">55       <code class="structfield">update_rule</code> <code class="type">character_data</code>56      </p>57      <p>58       Update rule of the foreign key constraint:59       <code class="literal">CASCADE</code>, <code class="literal">SET NULL</code>,60       <code class="literal">SET DEFAULT</code>, <code class="literal">RESTRICT</code>, or61       <code class="literal">NO ACTION</code>.62      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">63       <code class="structfield">delete_rule</code> <code class="type">character_data</code>64      </p>65      <p>66       Delete rule of the foreign key constraint:67       <code class="literal">CASCADE</code>, <code class="literal">SET NULL</code>,68       <code class="literal">SET DEFAULT</code>, <code class="literal">RESTRICT</code>, or69       <code class="literal">NO ACTION</code>.70      </p></td></tr></tbody></table></div></div><br class="table-break" /></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="infoschema-parameters.html" title="37.33. parameters">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-role-column-grants.html" title="37.35. role_column_grants">Next</a></td></tr><tr><td width="40%" align="left" valign="top">37.33. <code class="literal">parameters</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 37.35. <code class="literal">role_column_grants</code></td></tr></table></div></body></html>