Free Webmaster Tools and Resources

W3-Tools.com

Search Engine Optimization Domain Names Webmasters Web design

Webmaster Forum Webmaster News Links Directory

Search Engine Spider Simulator Keyword Analyser Tool Keywords Generator

Domain Tools

Domain Name Checker Whois Domain Lookup Domain Typo Generator

Web Utilities

HTTP Header Viewer Link Extractor Mime Types List

HTML Tools

Websafe Color Tool HTML Entity Chart

Documentation

PHP Manual PEAR Manual Smarty Manual PHP-GTK Manual Apache Manual MySQL Manual PostgreSQL Manual

PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL 8.1.3 Documentation
Prev	Fast Backward	Chapter 31. The Information Schema	Fast Forward	Next

31.20. `referential_constraints`

The view referential_constraints contains all referential (foreign key) constraints in the current database that belong to a table owned by the current user.

Table 31-18. referential_constraints Columns

Name	Data Type	Description
`constraint_catalog`	`sql_identifier`	Name of the database containing the constraint (always the current database)
`constraint_schema`	`sql_identifier`	Name of the schema containing the constraint
`constraint_name`	`sql_identifier`	Name of the constraint
`unique_constraint_catalog`	`sql_identifier`	Name of the database that contains the unique or primary key constraint that the foreign key constraint references (always the current database)
`unique_constraint_schema`	`sql_identifier`	Name of the schema that contains the unique or primary key constraint that the foreign key constraint references
`unique_constraint_name`	`sql_identifier`	Name of the unique or primary key constraint that the foreign key constraint references
`match_option`	`character_data`	Match option of the foreign key constraint: `FULL`, `PARTIAL`, or `NONE`.
`update_rule`	`character_data`	Update rule of the foreign key constraint: `CASCADE`, `SET NULL`, `SET DEFAULT`, `RESTRICT`, or `NO ACTION`.
`delete_rule`	`character_data`	Delete rule of the foreign key constraint: `CASCADE`, `SET NULL`, `SET DEFAULT`, `RESTRICT`, or `NO ACTION`.

Prev	Home	Next
`parameters`	Up	`role_column_grants`

Newsletter

Join to our newsletter and receive news and updates about our site.
Your name:
E-mail address:
Action:

Hosted by

Search

			Links

Copyright © 2006. by w3-tools.com. All rights reserved