Redshift reversengineering of all schemas including encoding option

DbSchema Issues
Post Reply
antonkuiper
Posts: 2
Joined: Mon Jan 15, 2018 11:43 am

Redshift reversengineering of all schemas including encoding option

Post by antonkuiper » Mon Jan 15, 2018 12:19 pm

HI

i face an issue the doing a revers enigineering on Redshift database.
Only on the public schema , it includes the encoding (compressioin technique)
CREATE TABLE "public".t_copa_actuals (
cc_timestamp timestamp encode lzo,
datapakid varchar(6) encode lzo,
record integer encode lzo,
recordmode varchar(1) encode lzo,
curtype varchar(2) encode lzo,
rec_type varchar(1) encode lzo,
"version" varchar(3) encode lzo,
fiscvarnt varchar(2) encode lzo,
fiscper varchar(7) encode lzo,
......

but on the other schema's it doesn't
CREATE TABLE c_dl_hana_common.matsales (
sid_material bigint NOT NULL ,
sid_salesorg smallint NOT NULL ,
salesorg varchar(4) NOT NULL ,
sid_distr_chan smallint NOT NULL ,
distr_chan varchar(2) NOT NULL ,
mat_sales varchar(18) NOT NULL ,
mat_sales_txtmd varchar(120) ,
......


I try to get also the encoding in place for the non public schemas.
How to solve this ??

antonkuiper
Posts: 2
Joined: Mon Jan 15, 2018 11:43 am

Re: Redshift reversengineering of all schemas including encoding option

Post by antonkuiper » Thu Mar 08, 2018 8:59 pm

Hi, Anyone can help me with this ???

Post Reply