Revision 7 not available (showing current revision instead)

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