DatabaseLesson 7Free preview

PostgreSQL INSERT INTO

This lesson is part of PostgreSQL · All levels

Summary

INSERT INTO adds one or more new lines to the table. You name the column and then list the values that are aligned with it; the unnamed column will receive either DEFAULT or NULL. PostgreSQL also provides a RETURNING clause to return the resulting value of the insertion such as the newly created id.

Key points

INSERT INTO adds one or more new lines to the table.
The value sequence must be in line with the list of columns mentioned.
The default keyword takes the intrinsic value or result generated column.
RETURNING can return columns such as the output id.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.