/database/layers_prod_updates/008_ger_display_name_update_30062011.sql
http://alageospatialportal.googlecode.com/ · SQL · 8 lines · 5 code · 3 blank · 0 comment · 0 complexity · f0d104e62c2f384b6ae69eca23cb5d3d MD5 · raw file
- \set ON_ERROR_STOP 1
- begin;
- update layers set displayname = description where name in ('ger_slopes_to_summit','ger_kosciuszko_to_coast','ger_k2c_management_regions_oct2009','ger_s2s_priority_area_billabong_creek_v01','ger_s2s_priority_areas_v05');
- update layers set displayname = 'Great Eastern Ranges Initiative Boundary', description = 'Great Eastern Ranges Initiative Boundary' where name = 'ger_geri_boundary_v102_australia';
- commit;