How to create/insert record(s) into Postgres Table using PostgreSQL?

How to create/insert record(s) into Postgres Table using PostgreSQL?

Syntax:

INSERT INTO table_name ( column1_Name, column2_Name, ... ) VALUES ( column1, column2, ... );

Examples:

Inserting one record:

INSERT INTO interested_car ( interested_car_name ) VALUES ( 'Honda' );

Inserting multiple records:

INSERT INTO interested_car ( interested_car_name ) VALUES
    ( 'Kia' ),
    ( 'Toyota' ),
    ( 'Hyundai' );

Leave a Reply