KarnerTh
Add an option to exclude tables
Often databases have more tables that you want to include that those that you want to exclude. Having an exclude option could reduce configuration.
Proposal: Add --excludedTables with this behavior
--excludedTables strings tables to exclude. Tables listed in --selectedTables have precedence over exclusion.
This would be handy for me to exclude the partition tables. For the purposes of the schema, it is useful to have just the base table without all partitions. Being able to specify an exclusion flag using SQL wildcards and/or regex would help.
One of my schemas has active/historical separation implemented by partitions in Postgres, so I would like to exclude them like this: --excludedTables = "'%_historical', '%_active'" or some variant thereof.
Right now I use this hack:
db_tables=`echo "\dt" | psql -q --csv postgresql://postgres@localhost:54322/postgres | csvq -f csv --without-header "select Name where (Name not like '%_active' and Name not like '%_historical') order by Name"`
mermerd -c postgresql://postgres@localhost:54322/postgres -o __design__/db_schema_diagram.mmd --schema public --selectedTables `echo $db_tables | tr ' ' ',' `
