Re: recording of INDEX creation in tables

2022-01-22 Thread Matthias Apitz
On Fri, 21 Jan 2022 23:38:44 -0700, David G. Johnston wrote: > On Fri, Jan 21, 2022 at 5:39 AM Matthias Apitz wrote: > >> >> Hello, >> >> Does the PostgreSQL (11.4 or 13.1) record somewhere in system tables >> the creation of INDEXes (or other objects)? >> >> > 13.1? Really? > Sorry, this was a t

Re: recording of INDEX creation in tables

2022-01-21 Thread David G. Johnston
On Fri, Jan 21, 2022 at 5:39 AM Matthias Apitz wrote: > > Hello, > > Does the PostgreSQL (11.4 or 13.1) record somewhere in system tables > the creation of INDEXes (or other objects)? > > 13.1? Really? Features are not point-release dependent so v11 or v13 suffices when trying to figure out whet

Re: recording of INDEX creation in tables

2022-01-21 Thread Michael Paquier
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 ar