Re: Table description

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Livia Santos <liviasilvasantos(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table description
Date: 2007-08-20 15:07:00
Message-ID: 748846.47354.qm@web31805.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Livia Santos <liviasilvasantos(at)gmail(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-20 15:08:23 Re: Table description
Previous Message Scott Marlowe 2007-08-20 15:06:17 Re: ERROR: relation "xxx" already exists but where????