RearrangingAirbyteDatabase

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

CREATE SCHEMA config;
CREATE SCHEMA jenkins;
GRANT ALL PRIVILEGES ON SCHEMA config TO airbyte;
GRANT ALL PRIVILEGES ON SCHEMA jenkins TO airbyte;
CREATE TABLE config.d_date AS (SELECT * FROM d_date);
CREATE TABLE jenkins.deploys AS (SELECT * FROM jenkins_data);
SELECT * FROM config.d_date;
-- Drop all tables from schema public.
DO $$
DECLARE
 row record;
BEGIN
 FOR row IN SELECT * FROM pg_tables WHERE schemaname = 'public' 
 LOOP
 EXECUTE 'DROP TABLE public.' || quote_ident(row.tablename) || ' CASCADE';
 END LOOP;
END;
$$;
CREATE TABLE d_date AS (SELECT * FROM config.d_date);
DROP TABLE config.d_date;