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:
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:
- Unpack archive sncat-yy-mm-dd.tar.gz
- cd sncat-yy-mm-dd
- createdb DBNAME
- sh initdb.sh DBNAME
- sh load.sh DBNAME
- 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