sql: add \x slash command as alias for \set display_format=records

[erikgrinaker]

psql has a \x [on|off|auto] slash command to switch between table and record output:

test=# SELECT 1, 2, 3;
 ?column? | ?column? | ?column? 
----------+----------+----------
        1 |        2 |        3
(1 row)

test=# \x
Expanded display is on.
test=# SELECT 1, 2, 3;
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

cockroach sql supports the same output formats, but uses \set display_format=records instead:

root@:26257/defaultdb> SELECT 1, 2, 3;
  ?column? | ?column? | ?column?
-----------+----------+-----------
         1 |        2 |        3
(1 row)

Time: 0ms total (execution 0ms / network 0ms)

root@:26257/defaultdb> \set display_format=records
root@:26257/defaultdb> SELECT 1, 2, 3;
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

Time: 0ms total (execution 0ms / network 0ms)

I propose adding \x as an alias for toggling between records and table, and supporting the optional on and off parameters (but not auto in the first iteration).

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @tim-o (member of the technical support engineering team)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}