March 26, 2021

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' );

No comments:

Post a Comment