SQL Language Guide : A. Terminal Monitor : Terminal Monitor Macros : Using Tab or Newline
 
Share this page                  
Using Tab or Newline
If you want to insert a real tab or newline, use \t for tab or \n for newline.
For example, the "sel" macro reads a string and uses the "get" macro to substitute the word SELECT for get.
The resulting string is used with the "sel" parameter "n", which is the name of a table, as follows:
{define;get;SELECT}\eval
{define;sel $n\n; \
get table_name FROM iitables WHERE \
table_name LIKE ā€˜$nā€™}\eval
To get all tables_name in iitables with a name that includes "index":
sel ā€˜%index%'\g