Skip to main content

Module insert_values

Module insert_values 

Source
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.
implicit_target_columns_with_control
single_row_values_query
The INSERT ... SELECT form of an INSERT whose single VALUES row contains a set-returning call, so the call expands into one inserted row per result as in PostgreSQL. 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.
single_row_values_query_with_control