/ 
DBIO-PostgreSQL-0.900000
/ DBIO::PostgreSQL::Introspect::ForeignKeys

NAME

DBIO::PostgreSQL::Introspect::ForeignKeys - Introspect PostgreSQL foreign keys

VERSION

version 0.900000

DESCRIPTION

Fetches PostgreSQL foreign key metadata from pg_catalog.pg_constraint, including ordered local and remote columns plus referential actions and deferrability.

METHODS

fetch

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

Returns a hashref keyed by schema.table. Each value is an ArrayRef of foreign key hashrefs with keys: constraint_name, remote_schema, remote_table, local_columns, remote_columns, on_delete, on_update, and is_deferrable.

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.