pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
constraint system tables
2+ messages / 2 participants
[nested] [flat]

* constraint system tables
@ 2011-05-09 11:03  mauro russo <m.russo@uniplan.it>
  0 siblings, 1 reply; 2+ messages in thread

From: mauro russo @ 2011-05-09 11:03 UTC (permalink / raw)
  To: pgsql-admin

Dears,

what system table contains constraints declarations/features?

Regards,
Mauro.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: constraint system tables
@ 2011-05-09 11:13  raghu ram <raghuchennuru@gmail.com>
  parent: mauro russo <m.russo@uniplan.it>
  0 siblings, 0 replies; 2+ messages in thread

From: raghu ram @ 2011-05-09 11:13 UTC (permalink / raw)
  To: mauro russo <m.russo@uniplan.it>; +Cc: pgsql-admin

On Mon, May 9, 2011 at 4:33 PM, mauro russo <m.russo@uniplan.it> wrote:

>  Dears,
>
> what system table contains constraints declarations/features?
>
>

Constraints information stored in " pg_constraint" catalog table.  Use
pg_get_constraintdef() to extract the definition of the check constraints.

http://www.postgresql.org/docs/9.0/interactive/catalog-pg-constraint.html

--Raghu Ram



>
>

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2011-05-09 11:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-09 11:03 constraint system tables mauro russo <m.russo@uniplan.it>
2011-05-09 11:13 ` raghu ram <raghuchennuru@gmail.com>

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