| From: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to display constraints? |
| Date: | 2001-04-03 00:18:51 |
| Message-ID: | 200104030018.JAA02899@mustang.sdc.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Soma Interesting | 2001-04-03 00:44:56 | Re: compile error |
| Previous Message | Alvaro Herrera | 2001-04-02 23:08:28 | Interval representation? |