Next Previous Up Contents
Next: Crossmatching
Up: Output Modes
Previous: topcat
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