Mercurial > gemma

view schema/updates/1317/01.migrate_styles.sql @ 5007:799e8248de8d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
First step to move geometry creation for WFS features to loader.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 11 Mar 2020 14:23:52 +0100
parents 4a9a1e323e11
children
line wrap: on
line source

ALTER TABLE sys_admin.published_services ADD COLUMN bin_blob bytea;
UPDATE sys_admin.published_services SET bin_blob = style::text::bytea WHERE style is NOT NULL;
ALTER TABLE sys_admin.published_services DROP COLUMN style;
ALTER TABLE sys_admin.published_services RENAME COLUMN bin_blob TO style;