pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedextracting constraints from schema
2+ messages / 2 participants
[nested] [flat]
* extracting constraints from schema
@ 2003-01-29 04:25 Agnieszka Rutkowska <agr225@cse.unsw.EDU.AU>
0 siblings, 1 reply; 2+ messages in thread
From: Agnieszka Rutkowska @ 2003-01-29 04:25 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: extracting constraints from schema
@ 2003-02-02 23:51 Tomasz Myrta <jasiek@klaster.net>
parent: Agnieszka Rutkowska <agr225@cse.unsw.EDU.AU>
0 siblings, 0 replies; 2+ messages in thread
From: Tomasz Myrta @ 2003-02-02 23:51 UTC (permalink / raw)
To: Agnieszka Rutkowska <agr225@cse.unsw.EDU.AU>; +Cc: pgsql-sql
Agnieszka Rutkowska wrote:
> 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
Did you try to extract any information from system table pg_constraint?
contype='C' is a CHECK condition. I think you can parse some additional
information from column consrc. Description of all columns in this table
is in "Chapter 3. System Catalogs 10. pg_constraint" at Postgresql documentation.
Regards,
Tomasz Myrta
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-02 23:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-29 04:25 extracting constraints from schema Agnieszka Rutkowska <agr225@cse.unsw.EDU.AU>
2003-02-02 23:51 ` Tomasz Myrta <jasiek@klaster.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox