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