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
|
.\" mmsql - Mini SQL Terminal Monitor
.\" Copyright (c) 1995-8 Martin Schulze <joey@infodrom.north.de>
.\"
.\" This program is free software; you can redistribute it and/or modify
.\" it under the terms of the GNU General Public License as published by
.\" the Free Software Foundation; either version 2 of the License, or
.\" (at your option) any later version.
.\"
.\" This program is distributed in the hope that it will be useful,
.\" but WITHOUT ANY WARRANTY; without even the implied warranty of
.\" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
.\" GNU General Public License for more details.
.\"
.\" You should have received a copy of the GNU General Public License
.\" along with this program; if not, write to the Free Software
.\" Foundation, Inc.,59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
.\"
.\" This manual page is written especially for Debian GNU/Linux.
.\"
.TH PMSQL 1 "10 Feb 1998" "Mini SQL" "Commands"
.SH NAME
pmsql \- Mini SQL Terminal Monitor
.SH SYNOPSIS
.B pmsql
.RB [ " \-h \fIhost\fP " ]
.RI [ " database " ]
.SH DESCRIPTION
Like all database applications, Msqlperl provides a program that allows a user
to interactively submit queries to the database engine. In the case of Msqlperl,
it's a program simply called
.B pmsql
and completely written in perl. The mSQL distribution comes with its
own monitor program
.BR msql .
It requires one command line argument, being the name of the database
to access. Once started, there is no way to swap databases without
restarting the program. this program is the main user interface to
the database engine. This monitor hasn been modelled after the
original Ingres (and the subsequent Postgres) monitor program.
See
.BR libmsql (3)
for Details in specifying a
.IR host name.
You may get full access to the
.I database
via mSQL queries according configured access rules. Each query must be followed
by `\g' (see later) to get sent to the engine. See
.BR msql (5)
for the supported subset of ANSI-SQL.
.SH COMMANDS
Queries and commands are distinguished due to commands being prefixed by backslashes.
.TP
.B "?"
Print usage summary and current host and database.
.TP
.BI ho[st] " host"
Set default host to
.IR host .
.TP
.BI da[tabase] " database"
Set default database to
.IR database .
.TP
.BR re[lshow] " [ " "\-h \fIhost\fR " " ] [ " " \fIdatabase\fR " " ] [ " " \fItable\fR " " ] [ " " \fIindex\fR " ]
Describe databases or tables in the same way as done by the relshow
program. If host or database are specified, the defaults are set to
these values. The prameter index is only supported for mSQL-2.0.
.TP
.BI ! " EXPR"
Eval the
.I EXPR
In Perl.
.TP
.B q[uit]
Leave pmsql.
.SH Completion
.B pmsql
comes with some basic completion definitions that are far from being
perfect. Completion means, you can use the TAB character to run some
lookup routines on the current host or database and use the results to
save a few keystrokes.
The completion mechanism is very basic, and I'm not intending to
refine it in the near future. Feel free to implement your own
refinements and let me know, if you have something better than what we
have here.
.SH "SEE ALSO"
.BR libmsql (3),
.BR msql (5),
.BR perldoc pmsql.
|
