sncat README

SAI Supernovae Catalog README

This catalogue is an export version of The SAI Supernovae Catalog, suited to be loaded into the PostgreSQL database for personal usage.

PREREQUISITIES:

  • PostgreSQL version 8.+

Download current version of the Catalogue from this location as sncat-yy-mm-dd.tar.gz.

FILES:

  • README - this file
  • VERSION - contains dates of modification of sn and galaxies tables
  • initdb.sh - creates database, scheme and tables
    • sncat.sql - create base tables
    • references.sql - references tables
    • snproc.sql - stored procedures
    • utils.sql - ra,dec conversion sql functions
  • load.sh - load data
    • galaxies.dump - dump of galaxies table
    • sn.dump - dump of sn table
    • map.dump - dump of map table
    • references.dump - references
    • grant.sql - defines permissions
  • finish.sh - validation script
  • sn_cat-columns.html - description of base columns of sn_cat view.

DOCUMENTATION:

  • sn_cat - the main table (view)
  • sn,galaxies - are the base tables
  • map - is a sn-galaxies mapping
  • other tables are references

INSTALLATION:

  1. Unpack archive sncat-yy-mm-dd.tar.gz
  2. cd sncat-yy-mm-dd
  3. createdb DBNAME
  4. sh initdb.sh DBNAME
  5. sh load.sh DBNAME
  6. sh finish.sh DBNAME

EXAMPLES:

Sample sql-queries you can use:

  • Produce flat-file catalog ordered by supernovae name
psql -c "select * from sn_cat order by