Subject | ISQL: Display rows vertically? |
---|---|
Author | Michael Ludwig |
Post date | 2010-05-13T09:12:43Z |
Consider a statement such as:
SQL> select * from MON$ATTACHMENTS;
MON$ATTACHMENT_ID MON$SERVER_PID MON$STATE MON$ATTACHMENT_NAME ...
Unless your terminal is extremely wide, the output of any statement
involving wide columns will be hard to read.
The mysql client allows the user to specify "\G" instead of ";" as
the statement terminator to indicate that columns are to be displayed
vertically rather than horizontally.
MON$ATTACHMENT_ID 101
MON$SERVER_PID 2896
MON$STATE 1
MON$ATTACHMENT_NAME xong
...
Is there a similar facility in ISQL?
--
Michael Ludwig
SQL> select * from MON$ATTACHMENTS;
MON$ATTACHMENT_ID MON$SERVER_PID MON$STATE MON$ATTACHMENT_NAME ...
Unless your terminal is extremely wide, the output of any statement
involving wide columns will be hard to read.
The mysql client allows the user to specify "\G" instead of ";" as
the statement terminator to indicate that columns are to be displayed
vertically rather than horizontally.
MON$ATTACHMENT_ID 101
MON$SERVER_PID 2896
MON$STATE 1
MON$ATTACHMENT_NAME xong
...
Is there a similar facility in ISQL?
--
Michael Ludwig