mclient 'expanded' row formatter

[monetdb-team]

Date: 2015-02-16 18:15:29 +0100
From: Richard Hughes <<richard.monetdb>>
To: clients devs <>
Version: 11.19.9 (Oct2014-SP2)

Last updated: 2015-08-28 13:41:51 +0200

Comment 20665

Date: 2015-02-16 18:15:29 +0100
From: Richard Hughes <<richard.monetdb>>

Created attachment 322
patch

We have some tables with a lot of columns (that's what column stores are for) and none of mclient's renderers create very easy-to-read output in this situation, so I've added a clone of psql's \x formatter. Sample output:

sql>\f x
sql>select * from sys.functions limit 2;
-[ RECORD 1 ]------------
id | 28
name | not_uniques
func | not_uniques
mod | sql
language | 0
type | 1
side_effect | false
varres | false
vararg | false
schema_id | 0
-[ RECORD 2 ]------------
id | 29
name | not_uniques
func | not_uniques
mod | sql
language | 0
type | 1
side_effect | false
varres | false
vararg | false
schema_id | 0
sql>

I like it, and other people might too.

Attached file: mclient-expanded-formatter.patch (text/plain, 2162 bytes)
Description: patch

Comment 20668

Date: 2015-02-19 16:16:18 +0100
From: MonetDB Mercurial Repository <>

Changeset 6e2859f319f4 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=6e2859f319f4

Changeset description:

Implemented a new output format in mclient: --format=expanded.
This is based on a suggestion with accompanying code from Richard
Hughes, but with some changes to deal with multi-line values.  See
bug #3673.

Comment 20669

Date: 2015-02-19 16:17:11 +0100
From: @sjoerdmullender

Thanks. I have taken your code and incorporated into the default branch (with some changes).

Comment 21190

Date: 2015-08-28 13:41:51 +0200
From: @sjoerdmullender

Jul2015 has been released.