Re: query system tables to find columns unique constraint is constraining? - Mailing list pgsql-sql

From Tom Lane
Subject Re: query system tables to find columns unique constraint is constraining?
Date
Msg-id 15686.1022613033@sss.pgh.pa.us
Whole thread Raw
In response to query system tables to find columns unique constraint is constraining?  ("Beth Gatewood" <beth@vizxlabs.com>)
List pgsql-sql
"Beth Gatewood" <beth@vizxlabs.com> writes:
> I have been fiddling around trying to figure out which columns some unique
> constraints are constraining by querying  the system tables.....with zero
> luck.

Look at the pg_index row for the index that's implementing the
constraint.

Rather than messing with the pg_index entry directly, you might want to
use pg_get_indexdef(), which is a helper function for pg_dump:

regression=# create table foo (f1 int, constraint foo_f1 unique (f1));
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'foo_f1' for table 'foo'
CREATE TABLE
regression=# select pg_get_indexdef(oid) from pg_class where relname = 'foo_f1';                 pg_get_indexdef
----------------------------------------------------CREATE UNIQUE INDEX foo_f1 ON foo USING btree (f1)
(1 row)

        regards, tom lane


pgsql-sql by date:

Previous
From: "Beth Gatewood"
Date:
Subject: query system tables to find columns unique constraint is constraining?
Next
From: Gabriel Dovalo Carril
Date:
Subject: Re: Functions with dynamic queries