DragonFly On-Line Manual Pages

GtkSQL(1)               http://gtksql.sourceforge.net/               GtkSQL(1)

NAME
       GtkSQL - SQL database interface

SYNTAX
       gtksql [-h] [-s "script" ] [-f scriptfile]

DESCRIPTION
       GtkSQL is an interactive SQL interface to various databases. Currently,
       MySQL and PostgreSQL are supported.

       A script interface is provided using the LUA script language. The
       program configuration and workspace files are saved as LUA scripts.

       NOTE: It is possible to compile GtkSQL without LUA support. If you do
       this, saved workspaces and scripts will not be supported.

OPTIONS
       -h>    Show command-line help.

       -s <script>
              Runs <script> directly.

       -f <scriptfile>
              Loads and runs a script from <scriptfile>.

FILES
       /usr/bin/gtksql

ENVIRONMENT VARIABLES
       HOME   Specifies the home directory

EXAMPLES
       Connect to the "billing" database on the MySQL server myserver.com.

       gtksql -s 'connect("mysql://myserver.com/billing")'

       Connect to the same server as the user fred, with password password:

       gtksql -s 'connect("mysql://fred:password@myserver.com/billing")'

       And the same with a PostgreSQL server:

       gtksql -s 'connect("postgresql://fred:password@myserver.com/billing")'

SCRIPTS
       Scripts are straight text files. It uses the LUA engine, which is
       documented at http://www.lua.org. All of the standard LUA functions are
       available. In addition to these, GtkSQL adds the following functions:

       -h     Show command-line help.

       addquery(<querytext>)
              Adds a query containing the given text.

       connect(<url>)
              Connects to the given url.

       deleteQueries()
              Removes all existing queries.

       exit() Exits the program.

       help() Displays simple help on the LUA script functions.

       loadQuery(<queryfile>)
              Opens a new query and loads the file into it.

       moveWindow(x, y)
              Move the window to the position given. The x and y locations
              refer to the distance of the top left of the GtkSQL window, from
              the top left of the screen.

       sizeWindow(width, height)
              Resize the window. Note that there is a minimum size built into
              the application. The minimum size depends on the screen size of
              the various buttons etc.

AUTHORS
       Darryl Luff <djluff@users.sourceforge.net>

SEE ALSO
       None.

Darryl Luff                          0.4.5                           GtkSQL(1)