Received: from mayn.de (qmailr@airbus.mayn.de [194.145.150.13]) by hub.org (8.9.3/8.9.3) with SMTP id RAA12364 for ; Fri, 5 Nov 1999 17:14:27 -0500 (EST) (envelope-from woelfel@mayn.de) Received: (qmail 22395 invoked from network); 5 Nov 1999 22:14:17 -0000 Received: from netppp-022.wuerzburg.dialin.mayn.de (HELO server) (194.145.151.22) by airbus.mayn.de with SMTP; 5 Nov 1999 22:14:17 -0000 From: Klaus Woelfel To: pgsql-sql@postgresql.org Subject: showing the DEFAULT of a field Date: Fri, 5 Nov 1999 23:15:58 +0100 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99110523182005.02127@server> Content-Transfer-Encoding: 8bit Hi, I'm new to psql and used mysql before. With mysql I could get with "show columns from table 'table_name'" a table with the rows "Field", "Type", "NULL", "Key", "Default" and "Extra". But with "\d 'table_name'" in qsql I get only a table with the rows "Field", "Type", and "Length". How can I get the other Information for example the Default or if the field has the primary key? Klaus Woelfel