Function

Summary

Prints a tabulated version of records resulting from a query.

Package

sql

Signature

print-query query-exp &key titles formats sizes stream database =>

Arguments

query-exp

An SQL query expression.

titles

A list of strings.

formats

A list of strings.

sizes

A list.

stream

An output stream.

database

A database.

Values

None.

Description

The print-query function takes a symbolic SQL query expression and formatting information and prints onto stream a table containing the results of the query.

A list of strings to use as column headings is given by titles , which has a default value of nil .

The formats argument is a list of format strings used to print each attribute, and has a default value of t , which means that ~A or ~VA are used if sizes are provided or computed.

The field sizes are given by sizes . It has a default value of t , which specifies that minimum sizes are computed.

The output stream is given by stream , which has a default value of t . This specifies that *standard-output* is used.

Examples

The following call prints out two even columns of names and salaries:

(print-query [select [surname] [income] :from [person]]

             :titles '("NAME" "SALARY"))

See also

map-query
print-query
select