-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathScript_soluciona_erro_importacao.sql
More file actions
23 lines (23 loc) · 1.12 KB
/
Copy pathScript_soluciona_erro_importacao.sql
File metadata and controls
23 lines (23 loc) · 1.12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
ALTER TABLE public.microdados_ed_basica
ALTER COLUMN "NO_REGIAO" TYPE varchar(512),
ALTER COLUMN "NO_UF" TYPE varchar(512),
ALTER COLUMN "SG_UF" TYPE varchar(512),
ALTER COLUMN "NO_MUNICIPIO" TYPE varchar(512),
ALTER COLUMN "NO_REGIAO_GEOG_INTERM" TYPE varchar(512),
ALTER COLUMN "NO_REGIAO_GEOG_IMED" TYPE varchar(512),
ALTER COLUMN "NO_MESORREGIAO" TYPE varchar(512),
ALTER COLUMN "NO_MICRORREGIAO" TYPE varchar(512),
ALTER COLUMN "NO_ENTIDADE" TYPE varchar(512),
ALTER COLUMN "DS_ENDERECO" TYPE varchar(512),
ALTER COLUMN "NU_ENDERECO" TYPE varchar(512),
ALTER COLUMN "DS_COMPLEMENTO" TYPE varchar(512),
ALTER COLUMN "NO_BAIRRO" TYPE varchar(512),
ALTER COLUMN "DT_ANO_LETIVO_INICIO" TYPE varchar(512),
ALTER COLUMN "DT_ANO_LETIVO_TERMINO" TYPE varchar(512),
ALTER COLUMN "CO_ESCOLA_SEDE_VINCULADA" TYPE varchar(512),
ALTER COLUMN "CO_IES_OFERTANTE" TYPE varchar(512),
ALTER COLUMN "TP_OCUPACAO_GALPAO" TYPE varchar(512),
ALTER COLUMN "TP_INDIGENA_LINGUA" TYPE varchar(512),
ALTER COLUMN "CO_LINGUA_INDIGENA_1" TYPE varchar(512),
ALTER COLUMN "CO_LINGUA_INDIGENA_2" TYPE varchar(512),
ALTER COLUMN "CO_LINGUA_INDIGENA_3" TYPE varchar(512);