> 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?
>
> thank you
OK, if you're using psql, you can go '\dt' to see all the tables or '\d
tablename' to see table info, but if you want to query them yourself, you'll
need to query the system catalogs:
http://www.au.postgresql.org/users-lounge/docs/7.2/postgres/catalogs.html
eg. SELECT * FROM pg_tables;
Chris