Open Source Toolkit Documentation:

The MITRE PostGres Server

License / Documentation home / Help and feedback

The MITRE PostGres server is a Communicator-compliant server which serves as an PostGres SQL client. PostGres is a free, powerful client-server implementation of SQL.

Status
Usage
Message set
Messages issued
Known bugs

Status

History and plans

Stable implementation from Galaxy Communicator 3.2 distribution.

Version history

1.0 on 1/25/02

Usage

Command line

<OSTK_ROOT>/bin/pgdb_server ...

Default port

16000

Command line arguments

static char *oas[] = {
"-dblogin <un/pw/db@host>", "<username>/<password>/database[@host] for database login", NULL,
"-maxrows <mr>", "maximum number of rows to be returned", "1000",
NULL
};

To use the database defaults, you can pass empty strings for username, password and database. This server also accepts the standard server arguments. See the command-line argument parsing library in the Galaxy Communicator documentation for details.

sql_query sends a query to the database and returns the result set in a single frame.

parameter type optional depends on description/constraints

IN: :query string SQL query string

:maxrows integer yes maximum number of rows to be returned for this query. This value is bounded by the maximum row count set on the command line (or by the default value if the not specified on the command line)

OUT: :query_result list of frames result of the query. Answer is of the form
{c result
   :nfound <integer: number of results>
   :column_names <list of strings: names of columns>
   :values <list of lists of ints and strings: sequence
            of rows, in same order as columns>
}

This message returns a frame.

reinitialize ignores the frame it's passed (it just returns it).

Messages issued

None.

Known bugs

The PostGres server will currently seg fault if the :query key is not present.