****************** command test ******************
 
# Connected Databases List (C: current database is '*')

 C | connect_name | user_name | target_name(db@host:port) | client_encoding 
---+--------------+-----------+---------------------------+-----------------
   | db1          | pgbash    | pgbash_db1:5432           |   
 * | db2          | pgbash    | pgbash_db2:5432           |   
(2 rows)
 
[ List of tables ]
+--------------+-------+--------+
| Name         | Type  | Owner  |
+--------------+-------+--------+
| pgbash_test1 | table | pgbash |
+--------------+-------+--------+
(1 row)
[ List of indexes ]
+---------------+-------+--------+
| Name          | Type  | Owner  |
+---------------+-------+--------+
| pgbash_index1 | index | pgbash |
+---------------+-------+--------+
(1 row)
[ List of views ]
+--------------+------+--------+
| Name         | Type | Owner  |
+--------------+------+--------+
| pgbash_view1 | view | pgbash |
+--------------+------+--------+
(1 row)
[ List of sequences ]
+-------------+----------+--------+
| Name        | Type     | Owner  |
+-------------+----------+--------+
| pgbash_seq1 | sequence | pgbash |
+-------------+----------+--------+
(1 row)
[ List of access permissions ]
+--------------+-------------------------+
| Relation     | Access permissions      |
+--------------+-------------------------+
| pgbash_seq1  |                         |
| pgbash_test1 | {"=arwR","pgbash=arwR"} |
| pgbash_view1 |                         |
+--------------+-------------------------+
(3 rows)
[ List of tables ]
+--------------+-------+--------+
| Name         | Type  | Owner  |
+--------------+-------+--------+
| pgbash_test2 | table | pgbash |
+--------------+-------+--------+
(1 row)
[ List of indexes ]
+---------------+-------+--------+
| Name          | Type  | Owner  |
+---------------+-------+--------+
| pgbash_index2 | index | pgbash |
+---------------+-------+--------+
(1 row)
[ List of relations ]
+--------------+----------+--------+
| Name         | Type     | Owner  |
+--------------+----------+--------+
| pgbash_seq1  | sequence | pgbash |
| pgbash_test1 | table    | pgbash |
| pgbash_view1 | view     | pgbash |
+--------------+----------+--------+
(3 rows)
[ "pgbash_test1" data definitions ]
+-----------+-----------------------+---------+---------+
| Attribute | Type                  | NotNull | Default |
+-----------+-----------------------+---------+---------+
| code      | integer               |         |         |
| name      | character varying(32) |         |         |
| address   | character varying(64) |         |         |
+-----------+-----------------------+---------+---------+
(3 rows)

Index  Key: pgbash_index1
[ "pgbash_index1" data definitions ]
+-----------+---------+---------+---------+
| Attribute | Type    | NotNull | Default |
+-----------+---------+---------+---------+
| code      | integer |         |         |
+-----------+---------+---------+---------+
(1 row)
[ "pgbash_view1" data definitions ]
+-----------+-----------------------+---------+---------+
| Attribute | Type                  | NotNull | Default |
+-----------+-----------------------+---------+---------+
| code      | integer               |         |         |
| name      | character varying(32) |         |         |
| address   | character varying(64) |         |         |
+-----------+-----------------------+---------+---------+
(3 rows)

Rule      : _RETpgbash_view1
[ "pgbash_seq1" data definitions ]
+---------------+---------+---------+---------+
| Attribute     | Type    | NotNull | Default |
+---------------+---------+---------+---------+
| sequence_name | name    |         |         |
| last_value    | integer |         |         |
| increment_by  | integer |         |         |
| max_value     | integer |         |         |
| min_value     | integer |         |         |
| cache_value   | integer |         |         |
| log_cnt       | integer |         |         |
| is_cycled     | "char"  |         |         |
| is_called     | "char"  |         |         |
+---------------+---------+---------+---------+
(9 rows)
[ List of relations ]
+--------------+-------+--------+
| Name         | Type  | Owner  |
+--------------+-------+--------+
| pgbash_test2 | table | pgbash |
+--------------+-------+--------+
(1 row)
[ "pgbash_test2" data definitions ]
+-----------+-----------------------+---------+---------+
| Attribute | Type                  | NotNull | Default |
+-----------+-----------------------+---------+---------+
| code      | integer               |         |         |
| name      | character varying(32) |         |         |
| address   | character varying(64) |         |         |
+-----------+-----------------------+---------+---------+
(3 rows)

Index  Key: pgbash_index2
[ "pgbash_index2" data definitions ]
+-----------+---------+---------+---------+
| Attribute | Type    | NotNull | Default |
+-----------+---------+---------+---------+
| code      | integer |         |         |
+-----------+---------+---------+---------+
(1 row)
large data 1
large data 2
large data 3