# DB Comment 달기
COMMENT ON TABLE "data". IS '';
ex)
COMMENT ON TABLE "data".ivs_bml_admb_as_new IS '행정구역경계';
COMMENT ON TABLE "data".ivs_bml_badm_as_new IS '법정읍면동';
COMMENT ON TABLE "data".ivs_bml_hadm_as_new IS '행정읍면동';
COMMENT ON TABLE "data".ivs_etl_elec_as_new IS '선거구경계';
COMMENT ON TABLE "data".ivs_etl_elec_ps_new IS '선거구투표소';
COMMENT ON TABLE "data".ivs_etl_jumin_1yr_as_new IS '인구통계(1세단위건물별)';
COMMENT ON TABLE "data".ivs_etl_park_as_new IS '주정차금지구역';
COMMENT ON TABLE "data".ivs_etl_pkif_as_new IS '공원 정보';
COMMENT ON TABLE "data".ivs_etl_schl_as_new IS '학군경계';
COMMENT ON TABLE "data".ivs_etl_tong_ban_as_new IS '통_반_경계';
COMMENT ON TABLE "data".ivs_etl_wlkr_ls_new IS '걷고싶은길';
COMMENT ON TABLE "data".ivs_rdl_abar_as_new IS '어린이보호구역';
COMMENT ON TABLE "data".ivs_rdl_bycp_as_new IS '자전거도로';
COMMENT ON TABLE "data".ivs_rdl_byst_ps_new IS '자전거보관소';
COMMENT ON TABLE "data".ivs_rdl_cctv_ps_new IS '무인단속카메라';
COMMENT ON TABLE "data".ivs_rdl_lsta_as_new IS '경전철역';
COMMENT ON TABLE "data".ivs_rdl_pakp_as_new IS '주차장';
COMMENT ON TABLE "data".ivs_rdl_pdcr_as_new IS '횡단보도';
COMMENT ON TABLE "data".ivs_rdl_rdar_as_new IS '도로면';
COMMENT ON TABLE "data".ivs_rdl_rfmr_ps_new IS '교통안전시설(점)';
COMMENT ON TABLE "data".ivs_rdl_sclt_ps_new IS '보안등';
COMMENT ON TABLE "data".ivs_rdl_sdhp_as_new IS '과속방지턱';
COMMENT ON TABLE "data".ivs_rdl_stat_ps_new IS '정류장';
COMMENT ON TABLE "data".ivs_rdl_stlt_ps_new IS '가로등';
COMMENT ON TABLE "data".ivs_rdl_tree_ps_new IS '가로수';
COMMENT ON TABLE "data".ivs_rdl_trsn_ps_new IS '신호등';
COMMENT ON TABLE "data".ivs_rdl_uprg_as_new IS '도시계획도(지역)';
COMMENT ON TABLE "data".ivs_rdl_uprj_as_new IS '도시계획도(지구)';
COMMENT ON TABLE "data".ivs_rdl_uprk_as_new IS '도시계획도(구역)';
COMMENT ON TABLE "data".ivs_sv_etl_bsns_as_52_new IS '의정부음악극축제';
COMMENT ON TABLE "data".ivs_sv_tl_spbd_buld_new IS '건물';
COMMENT ON TABLE "data".ivs_swl_manh_ps_new IS '하수맨홀';
COMMENT ON TABLE "data".ivs_wtl_fire_tmp_ps_new IS '소화전(열람용)';
COMMENT ON TABLE "data".ivs_wtl_leak_ps_new IS '누수지점및복구내역';
COMMENT ON TABLE "data".ivs_wtl_manh_ps_new IS '상수맨홀';
<Postgres> DB Comment 달기 쿼리문
2021. 12. 1. 10:18
728x90
728x90