On Tuesday, May 12, 2015, BahramPSQL <
bahramjomezade.gis92@gmail.com> wrote:
I want to run a spatial query from two table!
CREATE TABLE "BorujerdDistCent" as
SELECT
*, st_distance(st_centroid("Lorestan".geometry),"Borujerd".geometry)/1000
as DistFromCntroid
FROM "Borujerd", "Lorestan"
Where "Lorestan"."Shahrestan" = 'بروجرد'
ORDER BY
"Borujerd".abady_name ASC
But i will see this error!
ERROR: column "gid" specified more than once
********** Error **********
ERROR: column "gid" specified more than once
SQL state: 42701
This is not a bug. You need to rewrite the query to avoid two output columns named "gid".
David J.