//get extent select xmin(extent(the_geom)), ymin(extent(the_geom)), xmax(extent(the_geom)), ymax(extent(the_geom)) from "ba_pa" //distinct with many tables Select distinct on ("domin", "subdom") "domin", "subdom" from dominios order by subdom //update table ponto with IMG_PERFIL UPDATE "PONTO" SET "IMG_PERFIL" = ( SELECT "Tab_IMAGE"."IMG_PERFIL" FROM "Tab_IMAGE" WHERE "Tab_IMAGE"."IDT_PONTO" = "PONTO"."IDT_PONTO")