/usr/share/doc/stilts/sun256/secB.26.2.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 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>Examples</title>
</head>
<body>
<hr>
<a href="tcube.html">Next</a> <a href="tcopy-usage.html">Previous</a> <a href="tcopy.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="tcube.html">tcube: Calculates N-dimensional histograms</a><br>
<b>Up: </b><a href="tcopy.html">tcopy: Converts between table formats</a><br>
<b>Previous: </b><a href="tcopy-usage.html">Usage</a><br>
<hr>
<h3><a name="secB.26.2">B.26.2 Examples</a></h3>
<p>Here are some examples of <code>tcopy</code> in use:
<dl>
<dt><strong><pre>
stilts tcopy stars.fits stars.xml
</pre></strong></dt>
<dd>Copies a FITS table to a VOTable.
Since no input format is specified, the format is automatically
detected (FITS is one of the formats for which this is possible).
Since no output format is specified, the <code>stars.xml</code>
filename is examined to make a guess at the kind of output to write:
the <code>.xml</code> ending is taken to mean a TABLEDATA-encoded
VOTable.
</dd>
<dt><strong><pre>
stilts tcopy stars.fits stars.xml ifmt=fits ofmt=votable
</pre></strong></dt>
<dd>Does the same as the previous example, but the input and output
formats have been specified explicitly.
</dd>
<dt><strong><pre>
stilts tcopy ofmt=text http://remote.host/data/vizer.xml.gz#4 -
</pre></strong></dt>
<dd>Prints the contents of a remote, compressed VOTable to the terminal in
a human-readable form. The <code>#4</code> at the end of the URL
indicates that the data from the fifth <code>TABLE</code> element
in the remote document are to be used. The gzip compression of
the table is taken care of automatically.
</dd>
<dt><strong><pre>
stilts tcopy ifmt=csv ofmt=latex spec.csv
</pre></strong></dt>
<dd>Converts a comma-separated values file to a LaTeX table environment,
writing the result to standard output.
</dd>
<dt><strong><pre>
stilts -classpath /usr/local/jars/pg73jdbc3.jar \
-Djdbc.drivers=org.postgresql.Driver \
tcopy in="jdbc:postgresql://localhost/imsim#SELECT ra, dec, Imag FROM dqc" \
ofmt=fits wfslist.cat
</pre></strong></dt>
<dd>Makes an SQL query on a PostgreSQL database and writes the
results to a FITS file.
The whole command is shown here, to show that the
classpath is augmented to include the PostgreSQL
driver class, and the driver class is named using the
<code>jdbc.drivers</code> system property.
As you can see, using SQL from Java is a bit fiddly,
and there are other ways to perform this
setup than on the command line - see <a href="jdbcConfig.html">Section 3.4</a>
and <code><a href="tpipe.html">tpipe</a></code>'s
<code>omode=tosql</code> output mode.
</dd>
</dl>
</p>
<hr><a href="tcube.html">Next</a> <a href="tcopy-usage.html">Previous</a> <a href="tcopy.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="tcube.html">tcube: Calculates N-dimensional histograms</a><br>
<b>Up: </b><a href="tcopy.html">tcopy: Converts between table formats</a><br>
<b>Previous: </b><a href="tcopy-usage.html">Usage</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>
|