Expand description
A single INSERT ... VALUES row, which PostgreSQL processes like the target list of a SELECT without FROM.
Functions§
- implicit_
target_ columns - The columns an INSERT without a column list fills in order: a table’s columns or a view’s output columns. A materialized view cannot be a target, and its INSERT keeps the form that reports so.
- single_
row_ values_ query - The
INSERT ... SELECTform of an INSERT whose single VALUES row contains a set-returning call, so the call expands into one inserted row per result as inPostgreSQL. A DEFAULT entry leaves its column out of the target list, where the column default fills it as for an omitted column. Any other INSERT has no such form.