/usr/share/gtk-doc/html/libgda-5.0/ch39s03.html is in libgda-5.0-doc 5.2.4-1ubuntu1.
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 | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Commands: GNOME Data Access 5 manual</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.79.1">
<link rel="home" href="index.html" title="GNOME Data Access 5 manual">
<link rel="up" href="gda-sql-manual-run.html" title="Getting started">
<link rel="prev" href="ch39s02.html" title="Execution">
<link rel="next" href="gda-sql-manual-dsn.html" title="DSN management">
<meta name="generator" content="GTK-Doc V1.25 (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="5"><tr valign="middle">
<td width="100%" align="left" class="shortcuts"></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="16" height="16" border="0" alt="Home"></a></td>
<td><a accesskey="u" href="gda-sql-manual-run.html"><img src="up.png" width="16" height="16" border="0" alt="Up"></a></td>
<td><a accesskey="p" href="ch39s02.html"><img src="left.png" width="16" height="16" border="0" alt="Prev"></a></td>
<td><a accesskey="n" href="gda-sql-manual-dsn.html"><img src="right.png" width="16" height="16" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="id-1.8.4.4"></a>Commands</h2></div></div></div>
<p>
The console tool allows the user to enter SQL commands (which can span several lines and must be terminated with
a semi colon). The commands are executed synchronously and the results displayed right after execution, for example:
</p>
<pre class="programlisting">
cnc1> select *
> from customers order by name;
id | name | last_update | default_served_by | country | city
---+-----------------+-----------------------+-------------------+---------+-----
2 | Ed Lamton | 2008-08-12 00:00:00+0 | 4 | SP | MDR
9 | Greg Popoff | 2007-12-25 00:00:00+0 | 2 | SP | MDR
3 | Lew Bonito | 2008-08-13 00:00:00+0 | 1 | FR | TLS
4 | Mark Lawrencep | 2007-12-25 00:00:00+0 | | SP | MDR
10 | Vladimir Zirkov | 2001-01-31 00:00:00+0 | 4 | |
(5 rows)
cnc1>
</pre>
<p>
The SQL dialect to be used must be understood by the database to which the connection is opened, so
it is possible to use database's specific commands, for example with a PostgreSQL database:
</p>
<pre class="programlisting">
cnc2> show search_path;
search_path
--------------
"$user",public
(1 row)
cnc2>
</pre>
<p>
</p>
<p>
There are also some internal commands which all start either with a dot or backslash and perform some
actions such as changing the default output mode (to HTML for example) or getting meta information
about the database structure. For example, use the <span class="command"><strong>.?</strong></span> to display a help message
about all internal commands (with truncated output here):
</p>
<pre class="programlisting">
gda> .?
Formatting
\H [HTML|XML|CSV|DEFAULT]
Set output format
General
\? List all available commands
\bind CNC_NAME CNC_NAME1 CNC_NAME2 [CNC_NAME ...]
Bind several connections together into the CNC_NAME virtual connection
</pre>
<p>
</p>
</div>
<div class="footer">
<hr>Generated by GTK-Doc V1.25</div>
</body>
</html>
|