Support \x for Expanded Display

[jackmaney]

The tabulate output looks very pretty, but a feature I love from psql is the expanded display option (\x) for looking at rows in really wide tables (ie tables with rows that are too big to fit in one line on the terminal). However, this isn't yet supported in pgcli:

$ pgcli
[dbname]> \x
syntax error at or near "\"
LINE 1: \x
        ^

[jaytaylor]

+1

[amjith]

This was requested by a few people. Need to look at how to do this effectively.

[treystout]

+1

[cezio]

+1

[jc21]

+1

[stedi67]

+1

[binarysource]

+1

[amjith]

Merged in PR #63 that adds \x support to master.

This currently fails on Python 3, but that will be fixed before the next release.

Can someone install the latest master and try it out?

You can install the latest master using the following command.

pip install -e git+git@github.com:amjith/pgcli.git#egg=pgcli

[jackmaney]

It mostly works, but it seems to be printing extra information:

$ pgcli
[dbname]> \x
Expanded display is on.
Expanded display is on.
[dbname]> select generate_series(1,5);
-[ RECORD 0 ]---+--
generate_series | 1
-[ RECORD 1 ]---+--
generate_series | 2
-[ RECORD 2 ]---+--
generate_series | 3
-[ RECORD 3 ]---+--
generate_series | 4
-[ RECORD 4 ]---+--
generate_series | 5

SELECT 5
+-------------------+
|   generate_series |
|-------------------|
|                 1 |
|                 2 |
|                 3 |
|                 4 |
|                 5 |
+-------------------+
SELECT 5

[jackmaney]

Whoah...it's not just with \x. I'm seeing double (blarg is just a test table):

$ pgcli
[dbname]> select * from blarg;
+-----------+
|         x |
|-----------|
|         2 |
|         3 |
| -17171717 |
+-----------+
SELECT 3
+-----------+
|         x |
|-----------|
|         2 |
|         3 |
| -17171717 |
+-----------+
SELECT 3

[amjith]

@jackmaney Fixed. Can you try again?

[amjith]

9a62921 - fixes the double printing of output.

[jackmaney]

That did it. 😄

[jaytaylor]

Awesome work everybody!

On Fri, Jan 9, 2015 at 1:05 AM, Jack Maney notifications@github.com wrote:

That did it. [image: 😄]

—
Reply to this email directly or view it on GitHub
#19 (comment).

[amjith]

This is now available in the release version 0.11.0

https://pypi.python.org/pypi?:action=display&name=pgcli&version=0.11.0