Domain Constraints

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Domain Constraints
Date: 2002-11-08 16:50:07
Message-ID: 1036774207.15373.107.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Any thoughts on how to display the domain constraints in psql?

a=# create domain d as integer not null check (value > 4);
CREATE DOMAIN
a=# create domain f as text check (value > 'bob') check (value < 'zip');
CREATE DOMAIN
a=# \dD
List of domains
Schema | Name | Type | Modifier
--------+------+---------+----------
public | d | integer | not null
public | f | text |
(2 rows)

Any thoughts on how to display the check constraints?

--
Rod Taylor

Browse pgsql-hackers by date

  From Date Subject
Next Message Tara Piorkowski 2002-11-08 17:19:16 Re: [GENERAL] PostgreSQL v7.3b5 Packaged for Testing ...
Previous Message Bruce Momjian 2002-11-08 16:49:13 Re: [HACKERS] PostgreSQL supported platform report and a