select count(*) as rows, sum(pts_key::bigint) as sum_pts_key, sum(pxcntr::bigint) as sum_pxcntr, sum(scan_key::bigint) as sum_scan_key, sum(scan::bigint) as sum_scan, sum(ext_key::bigint) as sum_ext_key, sum(coadd_key::bigint) as sum_coadd_key, sum(coadd::bigint) as sum_coadd, sum(mp_flg) as sum_mp_flg, sum(gal_contam) as sum_gal_contam, sum(use_src) as sum_use_src, sum(dup_src) as sum_dup_src, sum(nopt_mchs) as sum_nopt_mchs, sum(phi_opt::bigint) as sum_phi_opt, sum(dist_edge_ew::bigint) as sum_dist_edge_ew, sum(dist_edge_ns::bigint) as sum_dist_edge_ns, sum(err_ang::bigint) as sum_err_ang FROM twomass_psc; rows | sum_pts_key | sum_pxcntr | sum_scan_key | sum_scan | sum_ext_key | sum_coadd_key | sum_coadd | sum_mp_flg | sum_gal_contam | sum_use_src | sum_dup_src | sum_nopt_mchs | sum_phi_opt | sum_dist_edge_ew | sum_dist_edge_ns | sum_err_ang -----------+--------------------+--------------------+----------------+-------------+---------------+-----------------+-------------+------------+----------------+-------------+-------------+---------------+-------------+------------------+------------------+------------- 470992970 | 306810325437475788 | 306815556538478936 | 16902776758555 | 32666066948 | 2048692118201 | 388758631396659 | 64617139213 | 16048 | 729878 | 464456155 | 79798372 | 369187043 | 64916239773 | 69388217174 | 2670725813652 | 29279563815