showing the DEFAULT of a field - Mailing list pgsql-general

From Klaus Woelfel
Subject showing the DEFAULT of a field
Date
Msg-id 99110523204606.02127@server
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Klaus Woelfel
Date:
Subject: showing the DEFAULT of a field
Next
From: "Tsuchiya, Mitsy"
Date:
Subject: Regression test failing at crutial places.