/ 
DBIO-PostgreSQL-0.900000
/ DBIO::PostgreSQL::Introspect::Indexes

NAME

DBIO::PostgreSQL::Introspect::Indexes - Introspect PostgreSQL indexes

VERSION

version 0.900000

DESCRIPTION

Fetches index metadata from pg_catalog.pg_index, including access method, uniqueness, primary key flag, validity, the full index definition string from pg_get_indexdef, partial index predicates, and expression index expressions.

METHODS

fetch

my $indexes = DBIO::PostgreSQL::Introspect::Indexes->fetch($dbh, $filter);

Returns a hashref keyed by schema.table. Each value is a hashref keyed by index name. Each index entry has: index_name, access_method, is_unique, is_primary, is_valid, definition (full pg_get_indexdef output), predicate, expressions, columns (ArrayRef of column names, empty for expression-only indexes).

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.