This Perl module allows accessing the system catalog in popular databases using the DBI(3) interface. It offers a convenient way to retrieve metadata about the database objects and query execution plans.
To use DBIx::SystemCatalog, users need to create a DBIx::SystemCatalog object and connect to their database using DBI. Once connected, the module provides a range of functions for accessing database objects.
Users can select a schema and fetch all tables and views with types of objects using the functions provided by DBIx::SystemCatalog. Additionally, the module provides the functionality to fetch all columns, primary keys, unique indexes, and indexes for a particular table.
Overall, DBIx::SystemCatalog is a versatile module for accessing system catalog information for a range of databases. The constructor has been implemented with specific modules for efficient use of the DBD driver. This means that users can access faster and better functions, including relationships and types of objects.
Version 0.16: N/A