try
#\d tablename, i hope this is what you mean
----- Original Message -----
From: "Ang Tun Chek" <atchek@eware.com.my>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, May 14, 2002 9:49 PM
Subject: [GENERAL] some questions
> hi
> i am new to postresql and i need some help for some sql command
>
> what is the sql command in postresql equal to "describe table"?
>
> what is the sql command to list all tables in the database?
>
> thank you
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>