PostgreSQL Insert Data

To contribute a new record to a PostgreSQL table, deploy the INSERT INTO instruction.

INSERT INTO cars (brand, model, year) 
VALUES ('Chevrolet', 'Impala', 1967);

After executing, the terminal confirms with:

INSERT 0 1

This indicates one entry successfully appended.

🛈 The zero is a placeholder for an internal PostgreSQL process—ignore it for now.

Retrieve full table contents to verify data with:

SELECT * FROM cars;

This could yield:

 brand   |  model   | year 
---------+----------+------  
Chevrolet | Impala | 1967 
(1 row)

You can register several data lines in one go by including more value sets:

INSERT INTO cars (brand, model, year) 
VALUES   
   ('Dodge', 'Charger', 1970),   
   ('Mazda', 'RX-7', 1985),   
   ('Honda', 'Prelude', 1992);

Terminal reply:

INSERT 0 3

Signifying three new rows incorporated.

To cross-check the contents again, rerun:

SELECT * FROM cars;

You’ll now see all records stacked beneath each other.

Watch these YouTube tutorials to understand POSTGRESQL Tutorial visually:

Previous Next