select count(*), skupina  from "2014_body_obesk" group by skupina
select sum(st_area(wkb_geometry, true))  from "2014_plochy_obesk" 
select sum(st_length(wkb_geometry, true))  from "2014_linie_obesk" 

select * from (
select count(*) as count from "2014_linie_obesk" group by (wkb_geometry)
) as foo where count > 1


delete from "2015plochy"

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
