Couple quick questions....

Hullo all.

Developing with PostgreSQL for the first time, and just had a few quick
questions:

1)  How are indexes recorded? Is there a system table that stores
sequences/indexes, or are they stored internally?  I would like to be
able to access ALL sequences/indexes in a database just by name, so i
can have a program do maintenance ( i.e. delete them when needed ).

2) I need functionality akin to a "DESC table"  where i can get a query
result ( from an API, not the command line program ) that describes
type, name, etc. about the fields in a table.  I know this one has been
answered here, but i seem to have lost the message i saved about it.

Thanks very much,
dan