amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

blacklisted table parameter use LIKE or ILIKE instead of IN

Open ChrisLimbik opened this issue 6 years ago • 1 comments

cannot blacklist / whitelist based on prefix or suffix. for blacklisting a table I would like to be able to add a table prefix% which matches any table name with the matching prefix or %suffix for a matching suffix I.e. use the ILIKE or LIKE or SIMILAR TO clause as opposed to IN for Analyze Vacuum Utility

ChrisLimbik avatar Dec 06 '18 22:12 ChrisLimbik

Yeah this makes sense. We have a regex search on schemas but not on the tables themselves. Happy to take a PR for this or perhaps can look at it over the holidays.

IanMeyers avatar Dec 07 '18 09:12 IanMeyers