Write and upload indicators file to GCP buckets
pip install virtualenv
-- Inspect the generated statements before you actually execute: comment RAISE and uncomment the EXECUTE | |
DO | |
$do$ | |
DECLARE | |
_tbl text; | |
BEGIN | |
FOR _tbl IN | |
SELECT c.oid::regclass::text -- escape identifier and schema-qualify! | |
FROM pg_catalog.pg_class c | |
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace |