-- -- toardb/extension/toar_controlled_vocabulary/toar_controlled_vocabulary--0.3.6.sql -- -- [Step to install] -- -- 1. -- -- INSTALL VERSION: '0.3.6' -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION toar_controlled_vocabulary" to load this file. \quit -- Update Countries -- ================ -- Country names UPDATE CN_vocabulary SET enum_display_str='United Republic of Tanzania' WHERE enum_display_str='Tanzania, United Republic of';