Re: recording of INDEX creation in tables

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: recording of INDEX creation in tables
Date: 2022-01-22 05:58:45
Message-ID: YeudFalu6yfOJCRP@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2022-01-22 06:11:34 Re: How are md5.h: pg_md5_hash() function and below functions working?
Previous Message Adrian Klaver 2022-01-21 18:56:16 Re: psql and Postgres 7.2