/usr/share/gtk-doc/html/libgda-4.0/ch36s02.html is in libgda-4.0-doc 4.2.8-2build1.
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 103 104 105 106 107 108 109 110 111 112 113 114 115 | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Execution</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
<link rel="home" href="index.html" title="GNOME Data Access 4 manual">
<link rel="up" href="gda-sql-manual-run.html" title="Getting started">
<link rel="prev" href="gda-sql-manual-run.html" title="Getting started">
<link rel="next" href="ch36s03.html" title="Commands">
<meta name="generator" content="GTK-Doc V1.17 (XML mode)">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="2"><tr valign="middle">
<td><a accesskey="p" href="gda-sql-manual-run.html"><img src="left.png" width="24" height="24" border="0" alt="Prev"></a></td>
<td><a accesskey="u" href="gda-sql-manual-run.html"><img src="up.png" width="24" height="24" border="0" alt="Up"></a></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="24" height="24" border="0" alt="Home"></a></td>
<th width="100%" align="center">GNOME Data Access 4 manual</th>
<td><a accesskey="n" href="ch36s03.html"><img src="right.png" width="24" height="24" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="id960054"></a>Execution</h2></div></div></div>
<p>
The <span class="application">Libgda</span>'s SQL console tool runs is a terminal emulator, and can be launched using
the <span class="command"><strong>gda-sql</strong></span> (or <span class="command"><strong>gda-sql-<version></strong></span> for a specific version):
</p>
<div class="cmdsynopsis"><p><code class="command">gda-sql</code> [--help] [-l] [-L] [-C <em class="replaceable"><code>command</code></em>] [-f <em class="replaceable"><code>commands file</code></em>] [-o <em class="replaceable"><code>output file</code></em>] [-s<em class="replaceable"><code>port to use to run embedded HTTP server</code></em>] [-t<em class="replaceable"><code>authentication token required to authenticate clients when running the embedded HTTP server</code></em>] [<em class="replaceable"><code>connection specification</code></em>...]</p></div>
<p>
The options are the following ones:
</p>
<div class="itemizedlist"><ul class="itemizedlist" type="disc">
<li class="listitem"><p>the <code class="option">--help</code> option gives a short help summary</p></li>
<li class="listitem">
<p>the <code class="option">-l</code> and <code class="option">-L</code> options respectively
output a list of the defined data sources (DSN) and of the installed database adaptaters
(database providers):
</p>
<pre class="programlisting">
[prompt]> gda-sql -l
List of defined data sources
DSN | Provider | Description | Connection string | Username | Global
----------+----------+--------------------------------------+-----------------------+----------+-------
SalesTest | SQLite | Test database for a sales department | DB_NAME=sales_test.db | | FALSE
(1 row)
</pre>
<p>
</p>
<pre class="programlisting">
[prompt]> gda-sql -L
List of installed providers
Provider | Description | DSN parameters | Authentication | File
------------+-------------------------------------+--------------------+----------------+----------------------
-------------------------------------
PostgreSQL | Provider for PostgreSQL databases | DB_NAME, | USERNAME, | [...]libgda-postgres.so
SEARCHPATH, PASSWORD
HOST,
PORT,
OPTIONS,
USE_SSL
MSAccess | Provider for Microsoft Access files | DB_NAME, | | [...]libgda-mdb.so
DB_DIR
[...]
</pre>
<p>
</p>
</li>
<li class="listitem"><p>the <code class="option">-C</code> and <code class="option">-f</code> options repectively allow
one to specify a single command to be run or a filename containing the commands to run
before the tool exits</p></li>
<li class="listitem"><p>the <code class="option">-o</code> option allows to specify a file to write the
output to</p></li>
<li class="listitem"><p>the <code class="option">-s</code> requests the embedded HTTP server to be executed, listening on
the port specified.</p></li>
<li class="listitem"><p>the <code class="option">-t</code> specifies a token string which clients will have to
supply to authenticate themselves to the HTTP server, if running.</p></li>
</ul></div>
<p>
</p>
<p>
Connections to be opened can be specified on the command line using either:
</p>
<div class="itemizedlist"><ul class="itemizedlist" type="disc">
<li class="listitem"><p>defined data sources (the ones listed using the <code class="option">-l</code> option)</p></li>
<li class="listitem"><p>connection strings which have the following format:
"[<provider>://][<username>[:<password>]@]<connection_params>".
If a username or password is required, and is not specified either by a DSN's definition or in
the connection string, then it will be requested dynamically.
Note that if provided, <username>, <password> and <provider> must be encoded as per RFC 1738</p></li>
<li class="listitem"><p>for SQLite and MS Access files: the file name</p></li>
</ul></div>
<p>
</p>
<p>
Connections can also be opened while the tool is running using the <span class="command"><strong>.c</strong></span>
internal command.
</p>
<p>
Examples:
</p>
<pre class="programlisting">
[prompt]> gda-sql Sales
[prompt]> gda-sql Postgresql://username@DB_NAME=mydb SQLite://DB_NAME=fspot Sales
[prompt]> gda-sql path/to/dbfile.db
</pre>
<p>
</p>
</div>
<div class="footer">
<hr>
Generated by GTK-Doc V1.17</div>
</body>
</html>
|