Re: what is the equivalent of oracle's DESCRIBE table?

chris markiewicz wrote:
>
> \dt <table name> only seems to list Owner, Relation, and Type.
>
> i am looking for something that returns the same info that is found in a
> CREATE TABLE statement...column names, data types, etc. i haven't seen
> anything like this in the documentation...

Check Chapter 37. Extending SQL: An Overview. This includes a section
on the PostgreSQL system catalogs. It's rather dense, but might get you
going. This subject comes up now and again, so I'm sure there's also
some info in the list archives.

This section also says "The Reference Manual gives a more detailed
explanation of these catalogs and their attributes." Where can one find
this Reference Manual?

--

Ron Peterson
Systems Manager
Wallace Floyd Design Group
273 Summer Street
Boston, MA 02210
617.350.7400 tel
617.350.0051 fax
rpeterson(at)wallacefloyd(dot)com