Skip to content

Add support for retrieving all constraints via DBI::Postgresql #167

@rabbiveesh

Description

@rabbiveesh

Right now, when generating a schema from your database, we only pull foreign key constraints. It's not that hard to pull the other types of constraints, too (you search the pg_catalog.pg_constraint on different contype where f is fk, x is exclue, u is unique, c is check etc). Then, you can use the pg_get_constraintdef to recover the DDL for generating it, which we SHOULD be able to just parse using the regular parser

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions