How to read asas catalogs into postrgesql "curves" database.
log in on heplx40.
You should have an account in posgtresql too.

psql curves       #start postgresql interface (curves = database name)   
\i /var/www/html/curves/database/create  # remove the previous datebase and create empty tables   
\q  # exit to bashcd

/scratch/pi2/bfpil/catalogs/p040715/      # go to asas catalog directory
/var/www/html/pi0/offline/photometry/cat/flex_stat_cat -nmin 99 | /var/www/html/curves/database/gwiazdy.pl     
# the first command finds all the stars in the asas catalog with the number
# of mesurements at least 99 
# the second one reads stars from the input and inserts them into 
# the database
# while the script is working one can see if stars are really added
# to the database by executing psql and running the following command:
# select count(*) from stars;
# this shows the number of stars in the database

/var/www/html/curves/database/jasnosci.pl 
# this will read stars from the database, execute flex_get_raw for each one,
# read the results and put them into the database.

----------!important!----------------------------------------------------
flex_get_raw can output
multiple measurements in the same row. If you want to use a different
catalog with a different number of measurements in each row you have to do
the following:
Try to run flex_get_raw on a star, find out which columns
correspond to: time, magnitude and error.
put those numbers into
/var/www/html/curves/database/jasnosci.pl, line 29.e.g. 
	$insert->execute($row[0], $pomiar[1], $pomiar[2], $pomiar[7]);will take the

first column (really the first, mumbering starts with one).as the time, the
second as the magnitude and the 7th as the error

----------web inteface:--------------------------------------------------
http://grb.fuw.edu.pl/curves

-------------------------------------------------------------------------
Marek Biskup, 2005.04.12