샘플 테이블 생성하기

 

 

CREATE TABLE public.environmental_tax_account

(

    year character varying(100) COLLATE pg_catalog."default" NOT NULL,

    "industry_code" character varying(100) COLLATE pg_catalog."default" NOT NULL,

    "industry_desc" character varying(100) COLLATE pg_catalog."default" NOT NULL,

    "environmental_base" character varying(100) COLLATE pg_catalog."default" NOT NULL,

    "national_accounts_var" character varying(100) COLLATE pg_catalog."default" NOT NULL,

    units character varying(100) COLLATE pg_catalog."default" NOT NULL,

    magnitute character varying(100) COLLATE pg_catalog."default" NOT NULL,

    source character varying(100) COLLATE pg_catalog."default" NOT NULL,

    "data_value" character varying(100) COLLATE pg_catalog."default" NOT NULL,

    flag character varying(100) COLLATE pg_catalog."default" NOT NULL

)

 

 

 

샘플 데이터는 첨부파일 사용해라(인터넷에서 다운로드 받음)

environmental-tax-account-1999-2018.csv

0.07MB