/usr/share/doc/stilts/sun256/mode-tosql.html is in stilts-doc 3.1.2-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>tosql</title>
</head>
<body>
<hr>
<a href="match.html">Next</a> <a href="mode-topcat.html">Previous</a> <a href="outModes.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="match.html">Crossmatching</a><br>
<b>Up: </b><a href="outModes.html">Output Modes</a><br>
<b>Previous: </b><a href="mode-topcat.html">topcat</a><br>
<hr>
<h4><a name="mode-tosql">6.4.10 <code>tosql</code></a></h4>
<p><strong>Usage:</strong>
<pre> omode=tosql protocol=<jdbc-protocol> host=<value> db=<db-name>
dbtable=<table-name> write=create|dropcreate|append
user=<username> password=<passwd>
</pre></p>
<p>Writes a new table to an SQL database.
You need the appropriate JDBC drivers and
<code>-Djdbc.drivers</code> set as usual
(see <a href="jdbcConfig.html">Section 3.4</a>).
</p>
<p>Additional parameters for this output mode are:
<dl>
<dt><strong><code>protocol = <jdbc-protocol></code> <em>(String)</em></strong></dt>
<dd>The driver-specific sub-protocol specifier for the JDBC
connection.
For MySQL's Connector/J driver, this is <code>mysql</code>,
and for PostgreSQL's driver it is <code>postgresql</code>.
For other drivers, you may have to consult the driver
documentation.
</dd>
<dt><strong><code>host = <value></code> <em>(String)</em></strong></dt>
<dd>The host which is acting as a database server.
<p>[Default: <code>localhost</code>]
</p>
</dd>
<dt><strong><code>db = <db-name></code> <em>(String)</em></strong></dt>
<dd>The name of the database on the server into which the
new table will be written.
<p>The value of this parameter forms the last part
of the JDBC connection URL.
That means that for some JDBC drivers,
you can append parameter specifications to it
to affect the way the connection is made to the database, e.g.
"<code>db=some_db?useSSL=false</code>"
for MySQL's Connector/J.
</p>
</dd>
<dt><strong><code>dbtable = <table-name></code> <em>(String)</em></strong></dt>
<dd>The name of the table which will be written to the
database.
</dd>
<dt><strong><code>write = create|dropcreate|append</code> <em>(<a href="http://www.starlink.ac.uk/stil/javadocs/uk/ac/starlink/table/jdbc/WriteMode.html">WriteMode</a>)</em></strong></dt>
<dd>Controls how the values are written to a table in the database. The options are:
<ul>
<li><code>create</code>: Creates a new table before writing. It is an error if a table of the same name already
exists.
</li>
<li><code>dropcreate</code>: Creates a new database table before writing. If a table of the same name already
exists, it is dropped first.
</li>
<li><code>append</code>: Appends to an existing table. An error results if the named table has the wrong
structure (number or types of columns) for the data being written.
</li>
</ul>
<p>[Default: <code>create</code>]
</p>
</dd>
<dt><strong><code>user = <username></code> <em>(String)</em></strong></dt>
<dd>User name for the SQL connection to the database.
<p>[Default: <code>buildd</code>]
</p>
</dd>
<dt><strong><code>password = <passwd></code> <em>(String)</em></strong></dt>
<dd>Password for the SQL connection to the database.
</dd>
</dl>
</p>
<hr><a href="match.html">Next</a> <a href="mode-topcat.html">Previous</a> <a href="outModes.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="match.html">Crossmatching</a><br>
<b>Up: </b><a href="outModes.html">Output Modes</a><br>
<b>Previous: </b><a href="mode-topcat.html">topcat</a><br>
<hr><i>STILTS - Starlink Tables Infrastructure Library Tool Set<br>Starlink User Note256<br>STILTS web page:
<a href="http://www.starlink.ac.uk/stilts/">http://www.starlink.ac.uk/stilts/</a><br>Author email:
<a href="mailto:m.b.taylor@bristol.ac.uk">m.b.taylor@bristol.ac.uk</a><br>Mailing list:
<a href="mailto:topcat-user@jiscmail.ac.uk">topcat-user@jiscmail.ac.uk</a><br></i></body>
</html>
|