postgresql using reserved word as column name 1

postgresql using reserved word as column name

INSERT INTO table (id, name, "year") VALUES ( ... );

Here is what the above code is Doing:
1. We’re creating a new table called “table” with three columns: id, name, and year.
2. We’re inserting a new row into the table with the values 1, ‘Bill’, and 1965.
3. We’re inserting a new row into the table with the values 2, ‘Monica’, and 1966.
4. We’re inserting a new row into the table with the values 3, ‘Joe’, and 1960.

Similar Posts