search

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.58k stars 200 forks source link

Filter views by pattern #1420

Closed meridsa closed 6 months ago

meridsa commented 6 months ago

Feature Request

I want to be able to filter views using a regex pattern in the same way as I am able to filter tables.

Configuration option could be: schemacrawler.view.pattern.exclude

Possible Alternatives

I have considered filtering the output text using sed or similar utility.

Additional Context

No response

sualeh commented 6 months ago

@meridsa SchemaCrawler treats all table-like objects as tables - these include temporary tables, views, materialized views, etc. SchemaCrawler provides for a single include + exclude regular expression to filter these out by fully qualified name. I do not plan to provide a separate regular expression pair for each type of table-like object.

meridsa commented 6 months ago

Thanks for the response! I'll do that.