showing the DEFAULT of a field

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

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-general by date

  From Date Subject
Next Message Tsuchiya, Mitsy 1999-11-05 22:19:38 Regression test failing at crutial places.
Previous Message De Moudt Walter 1999-11-05 21:58:19 calulating with money type impossible ?