Thread: How to display constraints?

How to display constraints?

From
Stephen Davies
Date:
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