Viewing Objects

gsql provides several advanced features to facilitate user operations. The common usage is as follows:

  • Query the command help information.

    \h [NAME]
    

    For example, query all syntaxes of the ABORT statement.

    openGauss=# \h ABORT
    Command:     ABORT
    Description: abort the current transaction
    Syntax:
    ABORT [ WORK | TRANSACTION ] ;
    
  • Switch databases.

    \c dbname
    

    For example, switch the postgres database to the dp_tpcc database.

    openGauss=# \c db_tpcc
    Non-SSL connection (SSL connection is recommended when requiring high-security)
    You are now connected to database "db_tpcc" as user "omm".
    db_tpcc=# 
    
  • Query all databases.

    \l
    

    The following is an example:

    openGauss=# \l
                              List of databases
       Name    | Owner | Encoding  | Collate | Ctype | Access privileges
    -----------+-------+-----------+---------+-------+-------------------
     mydb      | omm   | GBK       | C       | C     |
     postgres  | omm   | SQL_ASCII | C       | C     |
     template0 | omm   | SQL_ASCII | C       | C     | =c/omm           +
               |       |           |         |       | omm=CTc/omm
     template1 | omm   | SQL_ASCII | C       | C     | =c/omm           +
               |       |           |         |       | omm=CTc/omm
    (4 rows)
    
  • Query all tables in the current database.

    \dt
    

    The following is an example:

    openGauss=# \dt
                                  List of relations
     Schema |      Name       | Type  | Owner |             Storage
    --------+-----------------+-------+-------+----------------------------------
     public | customer_t1     | table | omm   | {orientation=row,compression=no}
     public | customer_t1_bak | table | omm   | {orientation=row,compression=no}
    (2 rows)
    
  • View a table structure.

    \d tablename
    

    For example, view the structure of the customer_t1 table.

    openGauss=# \d customer_t1
            Table "public.customer_t1"
        Column     |     Type     | Modifiers
    ---------------+--------------+-----------
     c_customer_sk | integer      |
     c_customer_id | character(5) |
     c_first_name  | character(6) |
     c_last_name   | character(8) |
     amount        | integer      |
    
Feedback
编组 3备份
    openGauss 2024-04-12 00:46:38
    cancel