查看对象

gsql工具提供了若干高级特性，便于用户使用。常见用法如下：

• 查看命令帮助信息

1. \h [NAME]

例如，查询ABORT的所有语法。

1. openGauss=# \h ABORT 2. Command: ABORT 3. Description: abort the current transaction 4. Syntax: 5. ABORT [ WORK | TRANSACTION ] ; - 切换数据库

1. \c dbname

例如，将postgres数据库切换为数据库dp_tpcc。

1. openGauss=# \c db_tpcc 2. Non-SSL connection (SSL connection is recommended when requiring high-security) 3. You are now connected to database "db_tpcc" as user "omm". 4. db_tpcc=# - 查询所有数据库

1. \l

示例如下。

1. openGauss=# \l 2. List of databases 3. Name | Owner | Encoding | Collate | Ctype | Access privileges 4. -----------+-------+-----------+---------+-------+------------------- 5. mydb | omm | GBK | C | C | 6. postgres | omm | SQL_ASCII | C | C | 7. template0 | omm | SQL_ASCII | C | C | =c/omm + 8. | | | | | omm=CTc/omm 9. template1 | omm | SQL_ASCII | C | C | =c/omm + 10. | | | | | omm=CTc/omm 11. (4 rows) - 查询当前数据库中的所有表

1. \dt

示例如下。

1. openGauss=# \dt 2. List of relations 3. Schema | Name | Type | Owner | Storage 4. --------+-----------------+-------+-------+---------------------------------- 5. public | customer_t1 | table | omm | {orientation=row,compression=no} 6. public | customer_t1_bak | table | omm | {orientation=row,compression=no} 7. (2 rows) - 查看表结构

1. \d tablename

例如，查看表customer_t1的表结构。

1. openGauss=# \d customer_t1 2. Table "public.customer_t1" 3. Column | Type | Modifiers 4. ---------------+--------------+----------- 5. c_customer_sk | integer | 6. c_customer_id | character(5) | 7. c_first_name | character(6) | 8. c_last_name | character(8) | 9. amount | integer |