NAME

DBIO::PostgreSQL::Introspect::Extensions - Introspect PostgreSQL extensions

VERSION

version 0.900007

DESCRIPTION

Fetches installed PostgreSQL extension metadata from pg_catalog.pg_extension. The built-in plpgsql extension is excluded since it is always present.

METHODS

fetch

my $extensions = DBIO::PostgreSQL::Introspect::Extensions->fetch($dbh);

Returns a hashref keyed by extension name. Each entry has: extension_name, version, schema_name (the schema the extension is installed in -- the one it depends on, so the schema is not dropped while the extension is in it), relocatable, and requires: the names of the installed extensions this one depends on, by name, an empty ArrayRef when there are none. That is what the catalog records (pg_depend, extension on extension, deptype n) -- the requires of the control file as it was resolved at CREATE EXTENSION. DBIO::PostgreSQL::Diff::Extension creates and drops extensions in the order it gives. plpgsql, not in the model, is not listed.

No schema filter is accepted — extensions are database-level objects.

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.