blob: d926ca36d1672ef6dc09d241f5a8c9b9dab49c99 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!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>
The view <code class="literal">referential_constraints</code> contains all
referential (foreign key) constraints in the current database.
Only those constraints are shown for which the current user has
write access to the referencing table (by way of being the
owner or having some privilege other than <code class="literal">SELECT</code>).
</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">
Column Type
</p>
<p>
Description
</p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">constraint_catalog</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the database containing the constraint (always the current database)
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">constraint_schema</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the schema containing the constraint
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">constraint_name</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the constraint
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">unique_constraint_catalog</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the database that contains the unique or primary key
constraint that the foreign key constraint references (always
the current database)
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">unique_constraint_schema</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the schema that contains the unique or primary key
constraint that the foreign key constraint references
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">unique_constraint_name</code> <code class="type">sql_identifier</code>
</p>
<p>
Name of the unique or primary key constraint that the foreign
key constraint references
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">match_option</code> <code class="type">character_data</code>
</p>
<p>
Match option of the foreign key constraint:
<code class="literal">FULL</code>, <code class="literal">PARTIAL</code>, or
<code class="literal">NONE</code>.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">update_rule</code> <code class="type">character_data</code>
</p>
<p>
Update rule of the foreign key constraint:
<code class="literal">CASCADE</code>, <code class="literal">SET NULL</code>,
<code class="literal">SET DEFAULT</code>, <code class="literal">RESTRICT</code>, or
<code class="literal">NO ACTION</code>.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">delete_rule</code> <code class="type">character_data</code>
</p>
<p>
Delete rule of the foreign key constraint:
<code class="literal">CASCADE</code>, <code class="literal">SET NULL</code>,
<code class="literal">SET DEFAULT</code>, <code class="literal">RESTRICT</code>, or
<code class="literal">NO ACTION</code>.
</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>
|
