sqls.Table.sql Maven / Gradle / Ivy

Go to download
drop table if exists test_table;
create table if not exists test_table
(
    id        bigserial not null
        constraint test_table_pkey
            primary key,
    a_int     bigint,
    a_decimal numeric,
    a_varchar varchar,
    a_text    text,
    a_byte    bytea,
    a_time    timestamp,
    a_date    date,
    a_boolean boolean,
    a_uuid    uuid,
    a_json    jsonb
);

comment on table test_table is 'test table 评论';

alter table test_table
    owner to postgres;

create index if not exists index_test_table
    on test_table (a_text);