pgsql_tweaks is a bundle of functions and views for PostgreSQL
Published on August 15, 2022 by Stefanie Janine Stölting
1 min READ
The extension is also available on PGXN.
In this release some checks for not supported PostgreSQL versions have been removed.
In addition there are now paths for the version and test files generated for the releases. This puts them out of the path of the files containing the functions and views.
In a PostgreSQL related group a question about indexes on foreign keys came up.
The package already contained a view with information about foreign keys, but it did not include a check, whether there is an index created. That has been changed now. I’ve added a column “is_indexed”.
Some other colums have been added too, here:
The examples, that are used in the documentation, are only tested against the latest PostgreSQL version.