Skip to content

Instantly share code, notes, and snippets.

View diegosps's full-sized avatar

Diego Santos diegosps

  • Rio de Janeiro
View GitHub Profile
@diegosps
diegosps / prepara_insumo.sql
Created April 9, 2020 15:28
Transform a geometry table in feasible (smaller) sizes to be processed in chunks and parallel - Postgis
-- FUNCTION: public.prepara_insumo(character varying, character varying)
-- DROP FUNCTION public.prepara_insumo(character varying, character varying);
CREATE OR REPLACE FUNCTION public.prepara_insumo(
tabela character varying,
srid character varying DEFAULT NULL::character varying)
RETURNS void
LANGUAGE 'plpgsql'