MY_CONS_COLUMNS
MY_CONS_COLUMNS displays information about primary key constraint columns in tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
table_name |
character varying(64) |
Name of a constraint-related table. |
column_name |
character varying(64) |
Name of a constraint-related column. |
constraint_name |
character varying(64) |
Constraint name. |
owner |
character varying(64) |
Constraint creator. |
position |
smallint |
Position of a column in a table. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.