****************** 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 ] +--------+--------------+-------+--------+ | Schema | Name | Type | Owner | +--------+--------------+-------+--------+ | public | pgbash_test1 | table | pgbash | +--------+--------------+-------+--------+ (1 row) [ List of indexes ] +--------+---------------+-------+--------+--------------+ | Schema | Name | Type | Owner | Table | +--------+---------------+-------+--------+--------------+ | public | pgbash_index1 | index | pgbash | pgbash_test1 | +--------+---------------+-------+--------+--------------+ (1 row) [ List of views ] +--------+--------------+------+--------+ | Schema | Name | Type | Owner | +--------+--------------+------+--------+ | public | pgbash_view1 | view | pgbash | +--------+--------------+------+--------+ (1 row) [ List of sequences ] +--------+-------------+----------+--------+ | Schema | Name | Type | Owner | +--------+-------------+----------+--------+ | public | pgbash_seq1 | sequence | pgbash | +--------+-------------+----------+--------+ (1 row) [ List of access permissions ] +--------+--------------+---------------------------+ | Schema | Table | Access privileges | +--------+--------------+---------------------------+ | public | pgbash_seq1 | | | public | pgbash_test1 | {=arwdRxt,pgbash=arwdRxt} | | public | pgbash_view1 | | +--------+--------------+---------------------------+ (3 rows) [ List of tables ] +--------+--------------+-------+--------+ | Schema | Name | Type | Owner | +--------+--------------+-------+--------+ | public | pgbash_test2 | table | pgbash | +--------+--------------+-------+--------+ (1 row) [ List of indexes ] +--------+---------------+-------+--------+--------------+ | Schema | Name | Type | Owner | Table | +--------+---------------+-------+--------+--------------+ | public | pgbash_index2 | index | pgbash | pgbash_test2 | +--------+---------------+-------+--------+--------------+ (1 row) [ List of relations ] +--------+--------------+----------+--------+ | Schema | Name | Type | Owner | +--------+--------------+----------+--------+ | public | pgbash_seq1 | sequence | pgbash | | public | pgbash_test1 | table | pgbash | | public | 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 : _RETURN [ "pgbash_seq1" data definitions ] +---------------+---------+----------+---------+ | Attribute | Type | NotNull | Default | +---------------+---------+----------+---------+ | sequence_name | name | not null | | | last_value | bigint | not null | | | increment_by | bigint | not null | | | max_value | bigint | not null | | | min_value | bigint | not null | | | cache_value | bigint | not null | | | log_cnt | bigint | not null | | | is_cycled | boolean | not null | | | is_called | boolean | not null | | +---------------+---------+----------+---------+ (9 rows) [ List of relations ] +--------+--------------+-------+--------+ | Schema | Name | Type | Owner | +--------+--------------+-------+--------+ | public | 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