Search Results for "postgresql database"

Q3C is the plugin for PostgreSQL, designed for the work with large astronomical catalogs or any catalogs of objects on the sphere.Q3C allows you to perform fast searches within a circles, ellipses or polygons on the sky and fast cross-matches. The main development happens on https://github.com/segasai/q3c/

Fixed width data files are probably the most annoying data to import into database. This utility allows user to insert user-defined column separators into user-defided positions of flat file table given in fixed-width format. I am using this utility to import astronomical catalogs provided as flat tables at CDS ftp-server into postgresql; Build: $ make all [cc={icc|gcc}] Install: $ make install [prefix=/path/to/your/bin/directory] Example of usage: $ gzip -dc table.dat.gz | fw2csv --stops=4,10,11,20,30,36 -d '|' -header 1 | psql wsdb -c "copy mytable from stdin with csv delimiter '|'" For the list of available options call $ fw2csv --help