showing the DEFAULT of a field

From: Klaus Woelfel <woelfel(at)mayn(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: showing the DEFAULT of a field
Date: 1999-11-05 22:15:58
Message-ID: 99110523182005.02127@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message José A. Navarro =?iso-8859-1?Q?Ram=F3n?= 1999-11-06 02:03:20 subscribe pgsql-sql
Previous Message De Moudt Walter 1999-11-05 21:58:19 calulating with money type impossible ?