Contents

drop table if exists test_number;

create table test_number (
    id            char(4),
    bool_item     bool,
    smallint_item smallint,
    int_item      int,
    bigint_item   bigint,
    real_item     real,
    double_item   double precision,
    money_item    money,
    numeric_item  numeric(8,3),
    primary key (id)
);

drop table if exists test_string;

create table test_string (
    id            int,
    char_item     char(4),
    varchar_item  varchar(4),
    text_item     text,
    primary key (id)
);

drop table if exists test_timestamp;

create table test_timestamp (
    id             int,
    date_item      date,
    time_item      time,
    timestamp_item timestamp,
    primary key (id)
);

drop table if exists test_json;

create table test_json (
    id             int,
    json_item      json,
    jsonb_item     jsonb,
    primary key (id)
);

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
embulk-output-postgresql-0.8.7	src/test/resources/org/embulk/output/postgresql/test/expect/basic/setup.sql
embulk-output-postgresql-0.8.6	src/test/resources/org/embulk/output/postgresql/test/expect/basic/setup.sql
embulk-output-postgresql-0.8.5	src/test/resources/org/embulk/output/postgresql/test/expect/basic/setup.sql
embulk-output-postgresql-0.8.4	src/test/resources/org/embulk/output/postgresql/test/expect/basic/setup.sql
embulk-output-postgresql-0.8.3	src/test/resources/org/embulk/output/postgresql/test/expect/basic/setup.sql