Creating a Table

Create an empty table in the current database. The table will be owned by the creator. The same table can be stored in different databases. You can execute the CREATE TABLE statement to create a table.


CREATE TABLE table_name 
    (column_name data_type [, ... ]);

Parameter Description

  • table_name

    Specifies the name of the table to be created.

  • column_name

    Specifies the name of the column to be created in the new table.

  • data_type

    Specifies the data type of the column.


Run the following commands to create a table named customer_t1. The table columns are c_customer_sk, c_customer_id, c_first_name, and c_last_name. The data types of the table columns are integer, char (5), char (6), and char (8), respectively.

openGauss=# CREATE TABLE customer_t1
    c_customer_sk             integer,
    c_customer_id             char(5),
    c_first_name              char(6),
    c_last_name               char(8),
    Amount                    integer

If the following information is displayed, the table has been created:

编组 3备份
    openGauss 2024-04-12 00:46:38