Spool File
Displays a spool file dialog to the user:
The user enters a filename to spool the query results to. This does not enable spooling, it only sets the file that data should be spooled to. To create a character delimted output file using a spool file, the user should select a column separator, set column headings off and set the column width to zero.
Syntax Highlighting
Displays a cascade menu controlling the syntax highlighting feature.
Options:
Enabled - turns on syntax highlighting.
Disabled - turns off syntax highlighting.
Tabs
Displays a tab settings dialog to the user:
Allows the user to enter the spacing for tabs used in the SQL command window.
Column Separator
Displays a cascade selection of column separator characters. These can be used to create delimited files in conjunction with spool option. The selections available are none, tab, space and comma.
Output Alignment
Displays a cascade selection of output alignment options:
Aligned - output columns are sized and aligned by datatype and width.
Standard - old style psql output, all columns are run together. Use with column separator to spool delimited output files.
Expanded - displays a record with each field as a separate line. This is identical to the expanded option in psql.
Output Type
Displays a cascade selection of output types:
Text - normal text output.
HTML - formats output into HTML tables.
Output Options
Displays a cascade selection of output formatting options:
Spool Results - controls file spooling.
Column Headings - controls the display of column headings in the Results Window.
Echo Query - controls the display of the SQL query in the Results Window.
Save Options
Saves the selected the currently set options and database connection information to a configuration file in the user's home directory. ($HOME/.mpsql_cfg)