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
|
.TH query 1 "2002-06-10" "execute a query" SQL\ Relay
.SH NAME
query \- execute a query
.SH SYNOPSIS
.B query
\fIhost port socket user passwd query \fR[debug]
.br
.B query
[-config \fIconfigfile\fR] -id \fIid query \fR[debug]
.SH DESCRIPTION
The
.B query
command executes the query specified in the \fIquery\fR parameter and
returns the result set as a quote/comma/return seperated value list to
standard output.
.SH OPTIONS
.TP
\fIhost\fR
hostname of the machine running the listener daemon
.TP
\fIport\fR
port number the listener daemon is listening on, for local or remote connections
.TP
\fIsocket\fR
socket the listener daemon is listening on, for local connections
.TP
\fIuser\fR
SQL Relay user name (as per config file)
.TP
\fIpasswd\fR
SQL Relay password (as per config file)
.TP
\fB-config\fR \fIconfigfile\fR
config file to use (default /etc/sqlrelay/sqlrelay.conf)
.TP
\fB-id\fR \fIid\fR
instance to use (as per config file)
.TP
\fIquery\fR
query to be executed
.TP
\fBdebug\fR
produce debugging output
.SH EXAMPLES
.TP
\fBquery "" "" /tmp/examplesocket fred secret "select * from tbl"\fR
Connect to the SQL Relay listener daemon running on the local
machine, with socket \fB/tmp/examplesocket\fR, as user \fBfred\fR,
with password \fBsecret\fR, and run a query.
.TP
\fBquery dbsvr 9000 "" fred secret "select * from tbl" debug\fR
Connect to the SQL Relay listener daemon running on the remote
machine \fBdbsvr\fR, on port \fB9000\fR, as user \fBfred\fR,
with password \fBsecret\fR, and run a query, producing extra
debugging output.
.TP
\fBquery -id example "select * from tbl"\fR
Connect to the SQL Relay listener daemon for instance \fBexample\fR
(as defined in /etc/sqlrelay/sqlrelay.config), and run a query.
.SH SEE ALSO
\fBfields\fP(1),
\#\fBquery\fP(1),
\fBsqlr-config-gtk\fP(1),
\fBsqlrsh\fP(1),
\fBsqlr-cachemanager\fP(8),
\fBsqlr-connection\fP(8),
\fBsqlr-listener\fP(8),
\fBsqlr-scaler\fP(8),
\fBsqlr-start\fP(8),
\fBsqlr-stop\fP(8),
and the documentation in /usr/share/doc/sqlrelay.
.SH AUTHORS
This manual page was written by Andreas Tille <tille@debian.org> and
Florian M. Weps <fweps@pop.agri.ch>, for the Debian GNU/Linux system
(but may be used by others).
|
