2MASS Point Source Catalog Verification Query

     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  |
-----------+--------------------+--------------------+----------------+-------------+---------------+
 470992970 | 306810325437475788 | 306815556538478936 | 16902776758555 | 32666066948 | 2048692118201 |

  sum_coadd_key  |  sum_coadd  | sum_mp_flg | sum_gal_contam | sum_use_src | sum_dup_src | sum_nopt_mchs |
-----------------+-------------+------------+----------------+-------------+-------------+---------------+
 388758631396659 | 64617139213 |      16048 |         729878 |   464456155 |    79798372 |     369187043 

 sum_phi_opt | sum_dist_edge_ew | sum_dist_edge_ns | sum_err_ang
-------------+------------------+------------------+--------------- 
 64916239773 |      69388217174 |    2670725813652 | 29279563815