github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cmd/smithcmp/postgres.toml (about)

     1  initsql = """
     2  DROP TABLE IF EXISTS tab_orig;
     3  
     4  CREATE TABLE tab_orig AS
     5      SELECT
     6          g::INT8 AS _int8,
     7          g::FLOAT8 AS _float8,
     8          '2001-01-01'::DATE + g AS _date,
     9          '2001-01-01'::TIMESTAMP + g * '1 day'::INTERVAL AS _timestamp,
    10          '2001-01-01'::TIMESTAMPTZ + g * '1 day'::INTERVAL AS _timestamptz,
    11          g * '1 day'::INTERVAL AS _interval,
    12          g % 2 = 1 AS _bool,
    13          g::DECIMAL AS _decimal,
    14          g::TEXT AS _string,
    15          g::TEXT::BYTEA AS _bytes,
    16          substring('00000000-0000-0000-0000-' || g::TEXT || '00000000000', 1, 36)::UUID AS _uuid,
    17          '0.0.0.0'::INET + g AS _inet,
    18          g::TEXT::JSONB AS _jsonb
    19      FROM
    20          generate_series(1, 5) AS g;
    21  
    22  DROP TABLE IF EXISTS t;
    23  CREATE TABLE t (x INT, y INT, z INT);
    24  
    25  SET statement_timeout = '9s';
    26  """
    27  smither = "cockroach"
    28  seed = 0
    29  postgres = true
    30  
    31  [databases.cockroach]
    32  addr = "postgresql://root@localhost:26257/postgres?sslmode=disable"
    33  allowmutations = true
    34  initsql = """
    35  DROP DATABASE IF EXISTS postgres;
    36  CREATE DATABASE postgres;
    37  """
    38  
    39  [databases.postgres]
    40  addr = "postgresql://postgres@localhost:5432?sslmode=disable"