diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-05-28 04:27:17 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-05-28 04:27:17 +0000 |
| commit | 32762facf653a56019e5bb02d187883c9ed14f16 (patch) | |
| tree | 4d5ed05a6a84470c529b29f8a2278834a7ebd4cb | |
| parent | d66a404983269c7b086bc7c57a3ea2f3a049b21b (diff) | |
| download | postgresql-32762facf653a56019e5bb02d187883c9ed14f16.tar.gz postgresql-32762facf653a56019e5bb02d187883c9ed14f16.zip | |
Sample output that appears below the table attributes for \d:
Indicies: palm_buy_date_idx
palm_user_date_idx
Primary Key: palm_buyers_pkey
Unique Key: palm_buyers_username
Constraint: "$1" ((sex = 'M'::bpchar) OR (sex = 'F'::bpchar))
Note that check constraint name now shown as well. (Makes it a lot easier
to test inheritance support in ADD/DROP constraint :) )
Attached is a docs change for psql.
Christopher Kings
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index ac58fdb3843..a3b49bc3f6f 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.54 2001/05/27 09:59:28 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.55 2001/05/28 04:27:17 momjian Exp $ Postgres documentation --> @@ -348,7 +348,8 @@ testdb=> (which could be a table, view, index, or sequence), their types, and any special attributes such as <literal>NOT NULL</literal> or defaults, if any. - If the relation is, in fact, a table, any defined indexes are also listed. + If the relation is, in fact, a table, any defined indices, primary keys, unique + constraints and check constraints are also listed. If the relation is a view, the view definition is also shown. </para> |