show

Show or toggle settings.

Table Mode


gfsh:/Customers>select * from /Customers

Row  Address  Name        Id
---  -------  ----        --
1    Tokyo    Yuki T      CUST34571
2    Delhi    V Ahmad     CUST17891
3    Oviedo   Fernando A  CUST13541
4    Pune     Vishal R    CUST10401
5    Karpen   Michael S   CUST96874
	
Class: data.Customer
Fetch size: 50, Limit: 1000
  Results: 5, Returned: 5/5
elapsed (msec): 4

Using -table, table Mode is OFF i.e. Catalog mode is ON

gfsh:/Customers>show -table
	
show -table is false

gfsh:/Customers>select * from /Customers
	
1. 
   Address = Karpen
   Id = CUST96874
   Name = Michael S

2. 
   Address = Oviedo
   Id = CUST13541
   Name = Fernando A
	
3. 
   Address = Delhi
   Id = CUST17891
   Name = V Ahmad

4. 
   Address = Pune
   Id = CUST10401
   Name = Vishal R

5. 
   Address = Tokyo
   Id = CUST34571
   Name = Yuki T

Fetch size: 50, Limit: 1000
  Results: 5, Returned: 5/5
elapsed (msec): 5

Using -type enable/disable showing field type information for Catalog mode. Notice the data types shown in ( & ) 298.

gfsh:/Customers>show -type 

show -type is true
	
gfsh:/Customers>select * from /Customers
	
1.  (Customer)
    Address = Delhi (String)
    Id = CUST17891 (String)
    Name = V Ahmad (String)

2.  (Customer)
    Address = Tokyo (String)
    Id = CUST34571 (String)
    Name = Yuki T (String)

3.  (Customer)
    Address = Karpen (String)
    Id = CUST96874 (String)
    Name = Michael S (String)
	
4.  (Customer)
    Address = Oviedo (String)
    Id = CUST13541 (String)
    Name = Fernando A (String)

5.  (Customer)
    Address = Pune (String)
	   Id = CUST10401 (String)
    Name = Vishal R (String)

Fetch size: 50, Limit: 1000
  Results: 5, Returned: 5/5
elapsed (msec): 4

Toggle printing results on screen using -p. Notice that the results are not displayed on screen.

gfsh:/Customers>show -p                 

show -p is false
	
gfsh:/Customers>select * from /Customers

Fetch size: 50, Limit: 1000
   Results: 5, Returned: 5/5
elapsed (msec): 4

Toggle displaying time taken to execute the command. Note that 'elapsed (msec):' is not shown.

gfsh:/Customers>show -t

show -t is false
	
gfsh:/Customers>select * from /Customers

Fetch size: 50, Limit: 1000
   Results: 5, Returned: 5/5