- create util schema
CREATE SCHEMA util
- create functions under
functions
- create a demo table
create table util.dropme ( -- can be any name
a text
);
- call the drop method from util
DO $$
BEGIN
perform util.drop_table('util.dropme');
END;
$$;
- see the logs with:
select * from util.logs