擅长:python、mysql、java
<p>你是不是想一下子就做完了?公司名称:</p>
<pre><code>cur.execute ('''
insert into tout.table2 (geom)
select st_setsrid(the_geom::geometry, 2154)
from
tout.area
inner join
public.table1 on
st_contains(area.geom, st_setsrid(table1.the_geom::geometry, 2154))
''')
</code></pre>