Re: some questions

On Wed, 15 May 2002, Ang Tun Chek wrote:

> 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?

Well the second of these is:

    SELECT relname FROM pg_class

However, I don't think that's really what you mean. I would suggest that you
what you want to do is connect to your database with psql. Do a \? at the
prompt and take a look at the \d commands. For example \dt will list
tables. Starting psql with the -E switch will show you the queries it
generates to do things like list the tables.

Good luck,


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants