Weeding out unused user created database objects, could I use pg_catalog?
От | Allan Kamau |
---|---|
Тема | Weeding out unused user created database objects, could I use pg_catalog? |
Дата | |
Msg-id | ab1ea6541002120432pf0e099dv3ced6f20b34e1e83@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Weeding out unused user created database objects, could
I use pg_catalog?
|
Список | pgsql-general |
Hi, I have been written several psql functions, tiggers and defined several tables over time for a database application I have been developing. The application has evolved as I have gained better understanding of the solution and so I have written newer psql functions and other database objects inline with this evolution and stopped calling (making use of) the older database objects I had previously written. Now I would like to only keep these database objects that are currently been used by the application. I have dedicted a single database object for use with this application, and I have all the DDL scripts in files which I execute for a clean deployment. If I start with a clean deployment, is there a way I could perhaps query the table(s) in pg_catalog for example to find out the database objects (I have constructed) that have been invoked or used in some way during a complete run of my application. I had a quick look at the pg_catalog but was unable to determine the tables that may contain pieces of this information. If pg_catalog could provide me with this solution, what are the table(s) to query? Allan.
В списке pgsql-general по дате отправления: