****************** 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 privileges | +--------------+---------------------------+ | pgbash_seq1 | | | pgbash_test1 | {=arwdRxt,pgbash=arwdRxt} | | 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 | bigint | | | | increment_by | bigint | | | | max_value | bigint | | | | min_value | bigint | | | | cache_value | bigint | | | | log_cnt | bigint | | | | is_cycled | boolean | | | | is_called | boolean | | | +---------------+---------+---------+---------+ (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