NAME

DBIO::PostgreSQL::Introspect::Columns - Introspect PostgreSQL table columns

VERSION

version 0.900000

DESCRIPTION

Fetches column metadata for all tables from pg_catalog.pg_attribute, including data types (via format_type), nullability, default expressions, identity/generated column markers, and enum/composite type names.

METHODS

fetch

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

Returns a hashref keyed by schema.table. Each value is an ArrayRef of column hashrefs ordered by attnum. Each column hashref has keys: column_name, ordinal, data_type, not_null, default_value, identity, generated, comment, type_category, enum_type, composite_type, type_schema.

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.