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.