Postgres Pro
Downloads
Home   >   mailing lists

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

From Klaus Woelfel
Subject showing the DEFAULT of a field
Date
Msg-id 99110523182005.02127@server
Whole thread Raw
Responses Re: [SQL] showing the DEFAULT of a field
List pgsql-sql
Tree view 
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-sql by date:

Previous
From: De Moudt Walter
Date:
Subject: calulating with money type impossible ?
Next
From: Heiko Wilms
Date:
Subject: pg_dump and "archive = none" ??