extracting constraints from schema

From: Agnieszka Rutkowska <agr225(at)cse(dot)unsw(dot)EDU(dot)AU>
To: pgsql-sql(at)postgresql(dot)org
Subject: extracting constraints from schema
Date: 2003-01-29 04:25:39
Message-ID: Pine.LNX.4.44.0301291520380.16179-100000@piano07.orchestra.cse.unsw.EDU.AU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I was just wondering whether you happen to know how to extract what the
table and column constraints are using jdbc?
The API provides methods for extracting meta data on the table names,
column names, primary and foreigh keys as well as column types and sizes.
What about extracting constraints such as

salary real CHECK (salary >= 10000)

?
It is possible to obtain the column name 'salary' as well as its types as
being 'real' but how about the CHECK condition?? Can it be done using
jdbc?

Thanks for your time and help
Agnes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2003-01-29 04:39:47 Re: converting microsoft sql server 2000 sql-code for postgresql
Previous Message Tom Lane 2003-01-29 04:08:16 Re: LONG - Question on dealing w/ numerics