aggregate query - Mailing list pgsql-sql

I have a table

CREATE TABLE survey_load
( meter_id character(5) NOT NULL, number_of_bays integer NOT NULL, bay_1_use integer, bay_2_use integer, bay_3_use
integer,bay_4_use integer, bay_5_use integer, date date NOT NULL, inspection_id integer NOT NULL DEFAULT,
 
)

How do i present an aggregate query

inspection_id  |  meter_id  |  bay_use
1                 12345        (value of bay_1_use)
1                 12345        (value of bay_2_use)
1                 12345        (value of bay_3_use)
2                 23456        (value of bay_1_use)
2                 23456        (value of bay_2_use)
2                 23456        (value of bay_3_use)
2                 23456        (value of bay_4_use)
2                 23456        (value of bay_5_use)

Thanks