Re: Equate for "describe table" ?

--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