Insert output of query into another table in postgres?

Question

I'm working in Postgres 9.4. I have two tables:

                                      Table "public.parcel"
    Column    |          Type          |                            Modifiers
 ogc_fid      | integer                | not null default
 wkb_geometry | geometry(Polygon,4326) |
 county       | character varying      |
 parcel_area  | double precision       |

            Table "public.county"
 Column |          Type          | Modifiers
--------+------------------------+-----------
 name   | character(1)           |
 chull  | geometry(Polygon,4326) |
 area   | double precision       |

I would like to find all the unique values of county in parcel, and the total areas of the attached parcels, and then insert them into the county table as name and area respectively.

I know how to do the first half of this:

SELECT county, 
       SUM(parcel_area) AS area 
FROM inspire_parcel 
GROUP BY county;

But what I don't know is how to insert these values into county. Can anyone advise?

I think it's something like:

UPDATE county SET name, area = (SELECT county, SUM(parcel_area) AS area 
FROM inspire_parcel GROUP BY county)

bos · Accepted Answer · 2016-04-26 09:26:39Z

2

You use INSERT INTO. So, something like this:

INSERT INTO county
 SELECT county, SUM(parcel_area) AS area
  FROM inspire_parcel GROUP BY county;

answered Apr 26, 2016 at 9:26

bos

6,5554 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Over a year ago

Thanks. That worked for me when I edited it slightly: INSERT INTO county(name, area)...

Collectives™ on Stack Overflow

Insert output of query into another table in postgres?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related