Features

Auto-completion

Simple completions such as keywords and sql-functions.

Keyword Completion

Smart-completion

Table name completions after the 'FROM' keyword.

Table Names

Column name completions once a table is recognized.

Column Names

Alias support

Column completions will work even when table names are aliased.

Alias Resolution

Syntax-highlighting

Syntax highlighting for sql.

Syntax Highlighting

Special commands

Limited support for some of psql's powerful back-slash commands.

Special Commands

Multi-line

F3 key will toggle multi-line support.In multi-line mode you can break your sql statement into multiple lines. A semi-colon is needed to end the line.

Special Commands

Pager

Output of an sql command is automatically piped through less command.

Special Commands

Favorite (named) queries

It is possible to store a query by name and reuse it later.

Example:

  1. Store the query select 1 as foo.
\ns foo select 1
  1. Execute named query foo.
\n foo
> select 1
+----------+
| ?column? |
+----------+
| 1        |
+----------+
SELECT 1

Named queries can have substitution parameters. Parameters can be provided using:

\ns foo select $1
\n foo 1
\ns foo select %s
\n foo 1
  1. Delete named query foo.
\nd foo

blogroll

social