Re: recording of INDEX creation in tables

On Fri, Jan 21, 2022 at 01:38:59PM +0100, Matthias Apitz wrote:
> Does the PostgreSQL (11.4 or 13.1) record somewhere in system tables
> the creation of INDEXes (or other objects)?

Hard to say what you are looking for with such a general question.

Would pg_index or pg_indexes be enough?  There are a bunch of system
catalogs and views, like what's in information_schema, that provide
this information.  If you are looking for a record of the timestamp
when objects have been created, there is no such tracking in Postgres
itself, but you could use an event trigger for this purpose.

Here are some links;
https://www.postgresql.org/docs/devel/catalog-pg-index.html
https://www.postgresql.org/docs/devel/view-pg-indexes.html
https://www.postgresql.org/docs/devel/event-triggers.html
--
Michael