ALTER TABLE potency ADD COLUMN hectare numeric; UPDATE potency SET hectare = round((st_area(the_geom::geography)/10000)::numeric, 4); SELECT id, name, year FROM industry WHERE (id, year) IN ( SELECT id, MAX(year) FROM industry GROUP BY id ); SELECT id, array_to_string(array_agg(product), ', ') FROM industry GROUP BY id; CREATE TRIGGER refresh_map_industry AFTER INSERT OR UPDATE OR DELETE ON industry FOR EACH STATEMENT EXECUTE PROCEDURE refresh_map_industry(); CREATE FUNCTION refresh_map_industry() RETURNS void AS $$ DROP TABLE map_industry; CREATE TABLE map_industry ...; $$ LANGUAGE SQL; for i in *[\ _[:upper:]]*; do if [ -d "$i" ]; then j=$(echo "$i" | tr ' _' '-' | tr '[A-Z]' '[a-z]') mv "$i" "$j" echo "$j" fi done for i in */*.jpg; do convert "$i" -scale 1024x768\> "$i" && echo "$i" done for i in */*.png; do convert "$i" -scale 1024x768\> "${i%.png}.jpg" && rm "$i" && echo "$i" done