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 [EMAIL PROTECTED] Adelaide, South Australia. Voice: 08-8177 1595 Computing & Network solutions. Fax: 08-8177 0133 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html