std2_27

CREATE TABLE std2_27.sales (
    "date" date NULL,
    region varchar(20) NULL,
    material varchar(20) NULL,
    distr_chan varchar(100) NULL,
    quantity int4 NULL,
    check_nm varchar(100) NOT NULL,
    check_pos varchar(100) NOT NULL
)
WITH (
    appendonly=true,
    orientation=row,
    compresstype=zstd,
    compresslevel=1
)
DISTRIBUTED BY (check_nm, check_pos);

insert into std2_27.sales
select * from gp.sales;

--- SQL Error [42501]: ERROR: permission denied for schema gp