Galaxy Communicator Documentation:

The MITRE PostGres Server

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

Version history

• 1.0 on 1/25/02

Usage

Command line

Default port

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
};

Message set

• sql_query
• reinitialize

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

Known bugs

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