On Fri, 9 Jan 2004, Bing Du wrote:
> Greetings,
>
> How can I see the layout of a table in PostgreSQL 7.4? I've checked
> several books and on-line documents, but was not able to figure out how
> PostgreSQL does 'describe <table>' like it's done in other databases.
If in psql, use the \d commands (\? will show you all of them.
However, if you've not got psql to do it, you can look through the
information_schema for anything like that, like so:
select * from information_schema.tables;
and so on.