--- Livia Santos <[EMAIL PROTECTED]> wrote:
> Is there any command that describe a table, such as desc table_name as in
> Oracle?

from the psql user interface, you can use the following command:

\dt
to list all table in the currently set schema

\d [table_name]
the see the table attributes

\d+ [table_name]
to see additional table attributes

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to