sncat README

Last edit

Removed: 2,4d1

< Questions:
< # Do we really need any stored procedures ?
< Seems we don't need sncat view, so I see no reason to have them !

Removed: 10d6

< * You need privilege to install plpgsql language (see ''createlang'')

Changed: 16c12

< * VERSION - timestamp of the catalogue (last modification)

to

> * VERSION - contains dates of modification of sn and galaxies tables

Removed: 39d34

< # createlang plpgsql DBNAME


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