Re: Equate for "describe table" ? - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: Equate for "describe table" ?
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB03FFFF71@snt452.corp.bcbsm.com
Whole thread Raw
In response to Equate for "describe table" ?  ("john" <servobit@m.r.c>)
List pgsql-general

--howdy:

--i'm assuming you're just getting the table description
via the command line?

database=> \d tablename

            Table "tablename"
 Attribute |       Type        | Modifier
-----------+-------------------+----------
 username  | character varying |
 fullname  | character varying |
 password  | character varying |
 class     | character(1)      |
 function  | character varying |
 email     | character varying |
 options   | character varying |

--HTH

-X

-----Original Message-----
From: john [mailto:servobit@m.r.c]
Sent: Monday, November 05, 2001 12:28 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Equate for "describe table" ?

Hi,

postgres newbie here.

What is the equivalent of "desc" or "describe tablename" in postgres?

Thanks,

John



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: Probably simple answer
Next
From: Tomas Berndtsson
Date:
Subject: Problem with threads in Solaris 8