github.com/tuhaihe/gpbackup@v1.0.3/end_to_end/resources/test_db_ddl.sql (about)

     1  DROP SCHEMA IF EXISTS schemaone CASCADE;
     2  DROP SCHEMA IF EXISTS schematwo CASCADE;
     3  
     4  CREATE SCHEMA schemaone;
     5  CREATE SCHEMA schematwo;
     6  CREATE TABLE schemaone.tableone (i int) DISTRIBUTED BY (i);
     7  CREATE TABLE schemaone.tabletwo (i int) DISTRIBUTED BY (i);
     8  CREATE TABLE schemaone.tablethree (i int) DISTRIBUTED BY (i);
     9  CREATE TABLE schemaone.tablefour (i int) DISTRIBUTED BY (i);
    10  CREATE TABLE schematwo.tableone (i int) DISTRIBUTED BY (i);
    11  CREATE TABLE schematwo.tabletwo (i int) DISTRIBUTED BY (i);
    12  CREATE TABLE schematwo.tablethree (i int) DISTRIBUTED BY (i);
    13  CREATE TABLE schematwo.tablefour (i int) DISTRIBUTED BY (i);
    14  INSERT INTO schemaone.tableone SELECT generate_series(1,1);
    15  INSERT INTO schemaone.tabletwo SELECT generate_series(1,100);
    16  INSERT INTO schemaone.tablethree SELECT generate_series(1,1000);
    17  INSERT INTO schemaone.tablefour SELECT generate_series(1,10000);
    18  INSERT INTO schematwo.tableone SELECT generate_series(1,1);
    19  INSERT INTO schematwo.tabletwo SELECT generate_series(1,100);
    20  INSERT INTO schematwo.tablethree SELECT generate_series(1,1000);
    21  INSERT INTO schematwo.tablefour SELECT generate_series(1,10000);