<ul>
<li>Run the following command to query information about all tables in a database in the system catalog pg_tables:
<pre><code class="lang-plaintext"> ""SELECT * FROM pg_tables;
</code></pre>
</li>
<li>Run the \d+ command of the gsql tool to query table attributes:
<pre><code class="lang-plaintext"> ""\d+ customer_t1;
</code></pre>
</li>
<li>Run the following command to query the data volume of table customer_t1:
<pre><code class="lang-plaintext"> ""SELECT count(*) FROM customer_t1;
</code></pre>
</li>
<li>Run the following command to query all data in the table customer_t1:
<pre><code class="lang-plaintext"> ""SELECT * FROM customer_t1;
</code></pre>
</li>
<li>Run the following command to query only the data in the column c_customer_sk:
<pre><code class="lang-plaintext"> ""SELECT c_customer_sk FROM customer_t1;
</code></pre>
</li>
<li>Run the following command to filter repeated data in the column c_customer_sk:
<pre><code class="lang-plaintext"> ""SELECT DISTINCT( c_customer_sk ) FROM customer_t1;
</code></pre>
</li>
<li>Run the following command to query all data whose column c_customer_sk is 3869:
<pre><code class="lang-plaintext"> ""SELECT * FROM customer_t1 WHERE c_customer_sk = 3869;
</code></pre>
</li>
<li>Run the following command to collate data based on the column c_customer_sk:
<pre><code class="lang-plaintext"> ""SELECT * FROM customer_t1 ORDER BY c_customer_sk;
</code></pre>
</li>
</ul>

* Run the following command to query information about all tables in a database in the system catalog **pg\_tables**:
    
    ```plaintext
    ""SELECT * FROM pg_tables;
    ```
    
* Run the **\\d+** command of the **gsql** tool to query table attributes:
    
    ```plaintext
    ""\d+ customer_t1;
    ```
    
* Run the following command to query the data volume of table **customer\_t1**:
    
    ```plaintext
    ""SELECT count(*) FROM customer_t1;
    ```
    
* Run the following command to query all data in the table **customer\_t1**:
    
    ```plaintext
    ""SELECT * FROM customer_t1;
    ```
    
* Run the following command to query only the data in the column **c\_customer\_sk**:
    
    ```plaintext
    ""SELECT c_customer_sk FROM customer_t1;
    ```
    
* Run the following command to filter repeated data in the column **c\_customer\_sk**:
    
    ```plaintext
    ""SELECT DISTINCT( c_customer_sk ) FROM customer_t1;
    ```
    
* Run the following command to query all data whose column **c\_customer\_sk** is **3869**:
    
    ```plaintext
    ""SELECT * FROM customer_t1 WHERE c_customer_sk = 3869;
    ```
    
* Run the following command to collate data based on the column **c\_customer\_sk**:
    
    ```plaintext
    ""SELECT * FROM customer_t1 ORDER BY c_customer_sk;
    ```

openGauss Viewing Data