Next Previous Up Contents
Next: Crossmatching
Up: Output Modes
Previous: topcat

5.4.9 tosql

Usage:

   omode=tosql protocol=<jdbc-protocol> host=<value> database=<db-name>
               newtable=<table-name> user=<username> password=<passwd>

Writes a new table to an SQL database. You need the appropriate JDBC drivers and -Djdcb.drivers set as usual (see Section 3.4).

Additional parameters for this output mode are:

protocol = <jdbc-protocol>
The driver-specific sub-protocol specifier for the JDBC connection. For MySQL's Connector/J driver, this is mysql, and for PostgreSQL's driver it is postgres. For other drivers, you may have to consult the driver documentation.
host = <value>
The host which is acting as a database server.

[Default: localhost]

database = <db-name>
The name of the database on the server into which the new table will be written.
newtable = <table-name>
The name of the new table which will be written to the database. If a table by this name already exists, it may be overwritten.
user = <username>
User name for the SQL connection to the database.

[Default: mbt]

password = <passwd>
Password for the SQL connection to the database.


Next Previous Up Contents
Next: Crossmatching
Up: Output Modes
Previous: topcat

STILTS - Starlink Tables Infrastructure Library Tool Set
Starlink User Note256
STILTS web page: http://www.starlink.ac.uk/stilts/
Author email: m.b.taylor@bristol.ac.uk