postgresql INSERT Basic INSERT
Example
Let's say we have a simple table called person:
CREATE TABLE person (
person_id BIGINT,
name VARCHAR(255).
age INT,
city VARCHAR(255)
);
The most basic insert involves inserting all values in the table:
INSERT INTO person VALUES (1, 'john doe', 25, 'new york');
If you want to insert only specific columns, you need to explicitly indicate which columns:
INSERT INTO person (name, age) VALUES ('john doe', 25);
Note that if any constraints exist on the table , such as NOT NULL, you will be required to include those columns in either case.
