Project

General

Profile

« Previous | Next » 

Revision 14138

schemas/util.sql: added check_constraint view

View differences:

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