Re: Table description

On 8/20/07, Livia Santos <liviasilvasantos(at)gmail(dot)com> wrote:
> Hi.
>
> Is there any command that describe a table, such as desc table_name as in
> Oracle?

Yes and no. The psql client has a series of \ commands that can
describe pretty much anything in the db in a pretty print nature and a
minimum of typing. The \ commands are NOT implemented in the backend,
but in the psql client so you can't just hit the db with \d from a
libpq connection to get a list of all tables / views / sequences.

However, you can use psql -E to have psql show you al lthe queries
it's throwing at the backend to get that pretty output, and then you
can take what it's doing and either wrap it in a view for future use,
or run it directly.