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