describe command

From: Merrill Oveson <merrill(at)actiontarget(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: describe command
Date: 2000-04-10 21:05:36
Message-ID: 38F24220.522B967A@actiontarget.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgresql:

Oracle has a command "describe"

e.g.

"describe cars" or "desc cars"

where cars is the name of the table.

this command describes the attributes of a table.

e.g.

Name Null Type Constraint
------------------------------
VIN char(20) Primary key
Make Not Null varchar(20)
Model varchar(20)

Does Postgresql have anything similar?
I could find the command "describe" anywhere in the documentation.

Merrill

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-04-10 22:10:30 Re: describe command
Previous Message Peter Eisentraut 2000-04-10 20:45:14 Re: recursive queries?