/ 
DBIO-DuckDB-0.900000
/ DBIO::DuckDB::Introspect::Columns

NAME

DBIO::DuckDB::Introspect::Columns - Introspect DuckDB columns

VERSION

version 0.900000

DESCRIPTION

Fetches column metadata via information_schema.columns. Primary-key information is joined in via information_schema.key_column_usage + table_constraints.

METHODS

fetch

my $columns = DBIO::DuckDB::Introspect::Columns->fetch($dbh, $schema, $tables);
my $columns = DBIO::DuckDB::Introspect::Columns->fetch($dbh, $schema, $tables, $catalog);

Given the tables hashref from DBIO::DuckDB::Introspect::Tables, returns a hashref keyed by table name. Each value is an arrayref of column hashrefs in ordinal_position order with keys: column_name, data_type, not_null, default_value, is_pk, pk_position.

When $catalog is defined, AND table_catalog = ? clauses are added to both the columns and primary-key queries.

AUTHOR

DBIO Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors

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