Received: from postoffice.mail.cornell.edu (postoffice.mail.cornell.edu [132.236.56.7]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8F0ZF790284 for ; Fri, 14 Sep 2001 20:35:15 -0400 (EDT) (envelope-from kw68@cornell.edu) Received: from 4162d.cornell.edu (dhcp98-126.cs.cornell.edu [128.84.98.126]) by postoffice.mail.cornell.edu (8.9.3/8.9.3) with ESMTP id UAA09748 for ; Fri, 14 Sep 2001 20:35:11 -0400 (EDT) Message-Id: <5.1.0.14.2.20010914203358.00baabf8@postoffice.mail.cornell.edu> X-Sender: kw68@postoffice.mail.cornell.edu (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 14 Sep 2001 20:35:11 -0400 To: pgsql-sql@postgresql.org From: ke wang Subject: How to see the definition of an existing table? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200109/107 X-Sequence-Number: 4772 Is there any command or query to see the definition of an existing table, like which is the primary key, which is not null etc. Thanks! --Ke