Re: [SQL] Porting MySQL's DESCRIBE and ENUM features

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Mark Stosberg <mark(at)summersault(dot)com>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Porting MySQL's DESCRIBE and ENUM features
Date: 1999-11-13 19:41:12
Message-ID: 1496.942522072@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> writes:
> I would myself be interested to see how the check constraints are stored,
> so I can put this into the psql \d command.

You want the rcsrc column of pg_relcheck. See getTables() in pg_dump.c
for an example of retrieving constraint conditions.

IIRC, specialized constraints such as NOT NULL are recorded someplace
else, but you probably know about those already.

regards, tom lane

Browse pgsql-sql by date

  From Date Subject
Next Message Artur Kokoszka 1999-11-13 22:30:35 national characters in plpgsql
Previous Message Peter Eisentraut 1999-11-13 17:04:41 Re: [SQL] Porting MySQL's DESCRIBE and ENUM features