vztsjLC2yZnC6yvbvtvg
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
wildcard_drop_tables(text, text)
Parameters
Name
Type
Mode
_schema
text
IN
_parttionbase
text
IN
Definition
DECLARE row record; BEGIN FOR row IN SELECT table_schema, table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema = _schema AND table_name ILIKE (_parttionbase || '%') LOOP EXECUTE 'DROP TABLE ' || quote_ident(row.table_schema) || '.' || quote_ident(row.table_name); RAISE INFO 'Dropped table: %', quote_ident(row.table_schema) || '.' || quote_ident(row.table_name); END LOOP; END;