****************** 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_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 | +-----------+---------+---------+ | code | int4 | f | | name | varchar | f | | address | varchar | f | +-----------+---------+---------+ (3 rows) Index Key: pgbash_index1 [ "pgbash_index1" data definitions ] +-----------+------+---------+ | Attribute | Type | NotNull | +-----------+------+---------+ | code | int4 | f | +-----------+------+---------+ (1 row) [ "pgbash_view1" data definitions ] +-----------+---------+---------+ | Attribute | Type | NotNull | +-----------+---------+---------+ | code | int4 | f | | name | varchar | f | | address | varchar | f | +-----------+---------+---------+ (3 rows) Rule : _RETpgbash_view1 [ "pgbash_seq1" data definitions ] +---------------+------+---------+ | Attribute | Type | NotNull | +---------------+------+---------+ | sequence_name | name | f | | last_value | int4 | f | | increment_by | int4 | f | | max_value | int4 | f | | min_value | int4 | f | | cache_value | int4 | f | | is_cycled | char | f | | is_called | char | f | +---------------+------+---------+ (8 rows) [ List of relations ] +--------------+-------+--------+ | Name | Type | Owner | +--------------+-------+--------+ | pgbash_test2 | table | pgbash | +--------------+-------+--------+ (1 row) [ "pgbash_test2" data definitions ] +-----------+---------+---------+ | Attribute | Type | NotNull | +-----------+---------+---------+ | code | int4 | f | | name | varchar | f | | address | varchar | f | +-----------+---------+---------+ (3 rows) Index Key: pgbash_index2 [ "pgbash_index2" data definitions ] +-----------+------+---------+ | Attribute | Type | NotNull | +-----------+------+---------+ | code | int4 | f | +-----------+------+---------+ (1 row) large data 1 large data 2 large data 3