hdHqE6Uh

1CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
2update trail set guid = uuid_generate_v4();
3ALTER TABLE public.trail
4    ADD COLUMN geom geometry;
5
6
7SELECT json_build_object(
8    'id', id, 
9    'name', name, 
10    'notes', notes, 
11    'offset', "offset", 
12    'colour', colour, 
13    'image', image, 
14    'guid', guid, 
15    'pkuid', pkuid, 
16    'geom', st_astext(geom)) from trail;