Revision 14138
Added by Aaron Marcuse-Kubitza over 10 years ago
util.sql | ||
---|---|---|
5250 | 5250 |
SET search_path = util, pg_catalog; |
5251 | 5251 |
|
5252 | 5252 |
-- |
5253 |
-- Name: check_constraint; Type: VIEW; Schema: util; Owner: - |
|
5254 |
-- |
|
5255 |
|
|
5256 |
CREATE VIEW check_constraint AS |
|
5257 |
SELECT s.table_, |
|
5258 |
s.name, |
|
5259 |
s.def, |
|
5260 |
ROW(ROW(s.table_, (s.name)::text), s.def)::check_constraint_def AS constraint_ |
|
5261 |
FROM ( SELECT (pg_constraint.conrelid)::regclass AS table_, |
|
5262 |
pg_constraint.conname AS name, |
|
5263 |
pg_constraint.consrc AS def |
|
5264 |
FROM pg_constraint |
|
5265 |
WHERE (pg_constraint.contype = 'c'::"char")) s; |
|
5266 |
|
|
5267 |
|
|
5268 |
-- |
|
5253 | 5269 |
-- Name: map; Type: TABLE; Schema: util; Owner: -; Tablespace: |
5254 | 5270 |
-- |
5255 | 5271 |
|
Also available in: Unified diff
schemas/util.sql: added check_constraint view