psql -ec "DROP TABLE temp_images" wsdb
psql -ec "CREATE TABLE temp_images AS SELECT
	  date,hemis,scan,coadd,ra,decl,s_type,naxis2,disk,f_type,cat,qual
	  FROM image_inventory
	  GROUP BY date,hemis,scan,coadd,ra,decl,s_type,naxis2,disk,f_type,cat,qual
	  ORDER BY date,hemis,scan,coadd,s_type
	 " wsdb
psql -ec "VACUUM ANALYZE temp_images" wsdb
psql -ec "DROP TABLE images" wsdb
psql -ec "CREATE TABLE images AS SELECT * from temp_images ORDER BY f_type desc,cat desc,decl" wsdb
psql -ec "DROP TABLE temp_images" wsdb
psql -ec "SELECT count(*) from images" wsdb
psql -ec "CREATE INDEX images_d_idx on images(decl)" wsdb
psql -ec "CREATE INDEX images_dm_idx ON images(decl) WHERE  (f_type='M') " wsdb
psql -ec "CREATE INDEX images_dmc_idx on images(decl) WHERE (cat='y' AND f_type='M')" wsdb
psql -ec "CREATE INDEX images_dhc_idx on images(decl) WHERE (cat='y' AND f_type='H')" wsdb
psql -ec "ANALYZE IMAGES" wsdb
psql -ec "GRANT SELECT ON images TO PUBLIC" wsdb
pg_dump -cst images wsdb > images_schema
pg_dump -ct images wsdb | gzip -9 > images.tbl.gz
psql -Atc "copy images to stdout" wsdb | gzip -9 > images.gz