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.

Syntax

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.

Examples

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:

 CREATE TABLE