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

     1  --
     2  -- Greenplum Database database dump
     3  --
     4  
     5  SET statement_timeout = 0;
     6  SET client_encoding = 'UTF8';
     7  SET standard_conforming_strings = on;
     8  SET check_function_bodies = false;
     9  SET client_min_messages = warning;
    10  
    11  SET default_with_oids = false;
    12  
    13  
    14  SET search_path = public, pg_catalog;
    15  
    16  SET default_tablespace = '';
    17  
    18  INSERT INTO foo SELECT generate_series(1,40000);
    19  
    20  --
    21  --
    22  
    23  
    24  INSERT INTO holds SELECT generate_series(1,50000);
    25  
    26  --
    27  --
    28  
    29  COPY sales (id, date, amt) FROM stdin;
    30  1	2017-01-01	20.00
    31  3	2017-03-01	20.00
    32  25	2017-05-01	20.00
    33  2	2017-02-01	20.00
    34  4	2017-04-01	20.00
    35  8	2017-08-01	20.00
    36  15	2017-05-01	20.00
    37  5	2017-05-01	20.00
    38  9	2017-09-01	20.00
    39  7	2017-07-01	20.00
    40  11	2017-11-01	20.00
    41  18	2017-08-01	20.00
    42  12	2017-12-01	20.00
    43  \.
    44  
    45  
    46  SET search_path = schema2, pg_catalog;
    47  
    48  --
    49  --
    50  
    51  INSERT INTO foo3 SELECT generate_series(201,300);
    52  
    53  INSERT INTO ao1 SELECT generate_series(1,1000);
    54  
    55  INSERT INTO ao2 SELECT generate_series(1,1000);
    56  
    57  --
    58  --
    59  
    60  COPY returns (id, date, amt) FROM stdin;
    61  2	2017-02-01	20.00
    62  7	2017-07-01	20.00
    63  25	2017-05-01	20.00
    64  15	2017-05-01	20.00
    65  11	2017-11-01	20.00
    66  12	2017-12-01	20.00
    67  \.
    68  
    69  
    70  --
    71  -- Greenplum Database database dump complete
    72  --
    73