Import foreign keys of parent tables in a specific schema

[sggreener]

I want to import just the foreign keys of tables in a single schema.

I can set up a filter to search for foreign keys using a simple pattern (fk_*) but how do I limit the filter to just those foreign keys whose parent object is in a specific schema?

I'm trying to import foreign keys named "fk_*" only in the "dbo" schema.

The following image shows fks in the ahr schema.

There is no Parent filter object.....

Simon

[sggreener]

Having applied a filter to the import dialog, there is no way to select more than one row in the resulting list.

Could we have the ability to shift-click a selection or have a tick box at the start of each row to allow for multiple selection?

regards
Simon

[rkhaotix]

Hi @sggreener

Currently pgModeler doesn't support filtering directly in parent field. I can improve it in the future.

For now you can filter in the object's signature (schema qualified name). For example, if you need to filter all fks in the tables in schema dbo, just write an expression like this: dbo.*.fk_* or something similar to this and pgModeler will list only fks of tables in schema dbo.

[sggreener]

The problem is that if I use the Constraint Object type it only filters on the name. The name does not include the schema.

Adding in a Schema object only imports that schema object.

Yes, the Parent Object type is not in the list of filterable objects and I can't see if any of the available Object types will do what I want.

I can see all the foreign keys in the filtered list (for a plain Constraint filter) but I can't select specific ones for import.

As it is it looks like I am going to have to manually select the foreign keys for each table in the schema in the full object access dialog. For 150 tables this will be painful.

Simon