How to display constraints? - Mailing list pgsql-general

From Stephen Davies
Subject How to display constraints?
Date
Msg-id 200104030018.JAA02899@mustang.sdc.com.au
Whole thread Raw
List pgsql-general
The searchable archives seem to be unavailable today. Could somebody
please tell me how to display the constraints that have been defined
for a given table (or all tables).

Is it possible to dump the original SQL DDL for a database or table?
That is, not just the \d information but the actual SQL create table
etc syntax?

Cheers and thanks,
Stephen Davies

========================================================================
Stephen Davies Consulting                              scldad@sdc.com.au
Adelaide, South Australia.                             Voice: 08-8177 1595
Computing & Network solutions.                         Fax: 08-8177 0133



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Interval representation?
Next
From: Soma Interesting
Date:
Subject: Re: compile error