How to see the definition of an existing table?

From: ke wang <kw68(at)cornell(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to see the definition of an existing table?
Date: 2001-09-15 00:35:11
Message-ID: 5.1.0.14.2.20010914203358.00baabf8@postoffice.mail.cornell.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there any command or query to see the definition of an existing table,
like which is the primary key, which is not null etc.

Thanks!

--Ke

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Lee Harr 2001-09-15 03:12:26 Re: Number the lines
Previous Message Patrik Kudo 2001-09-15 00:11:36 Re: Which SQL query makes it possible to optain the 3 greatest