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
|
.TH fields 1 "2002-06-10" "list fields in a table" SQL\ Relay
.SH NAME
fields \- list fields in a table
.SH SYNOPSIS
.B fields
\fIhost port socket user passwd table\fR
.br
.B fields
[-config \fIconfigfile\fR] -id \fIid table\fR
.SH DESCRIPTION
The
.B fields
command returns a comma seperated list of the fields in the table
specified by the \fItable\fR argument 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
\fItable\fR
table to be described
.SH EXAMPLES
.TP
\fBfields "" "" /tmp/examplesocket fred secret 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 return the fields in table \fBtbl\fR.
.TP
\fBfields dbsvr 9000 "" fred secret tbl\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 return the fields in table \fBtbl\fR.
.TP
\fBfields -id example tbl\fR
Connect to the SQL Relay listener daemon for instance \fBexample\fR
(as defined in /etc/sqlrelay/sqlrelay.config), and return the fields
in table \fBtbl\fR.
.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).
|
