On 03/06/2016 10:11, Adriano dos Santos Fernandes wrote:
> ISQL commands that display things in columns (for example, SHOW TABLE)
> must be changed to print each item per line.
>
>

How should we align this things as show table <name> ?

1) If we do more or less nothing, it will be:

(must be viewed with fixed font)
--------------
SQL> show table t1;
N1                              INTEGER Nullable
N2                              INTEGER Nullable
N234567890123456789012345678901234567890123456789012345678901234 INTEGER
Nullable
N3                              INTEGER Nullable
--------------

It does not break ISQL tests and is easy to do.

2) Otherwise, we can extend to pad to the max. possible length. It's
easy but makes output crazy to read.

3) We also can calculate the max. length for a given table. For me looks
more professional, but is not easy to do with gpre code and will break
ISQL tests as well.


Adriano


------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to