Struct InsertQuery 

pub struct InsertQuery {
    pub with: With,
    pub table: TableRef,
    pub overriding: Option<Overriding>,
    pub values: Values,
    pub conflict: Conflict,
    pub returning: Returning,
}

A PostgreSQL INSERT.

From https://www.postgresql.org/docs/17/sql-insert.html:

[ WITH [ RECURSIVE ] with_query [, ...] ]
INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
    [ OVERRIDING { SYSTEM | USER } VALUE ]
    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
    [ ON CONFLICT [ conflict_target ] conflict_action ]
    [ RETURNING … ]

The row source is one of three alternatives, and DEFAULT VALUES is the one Values cannot represent — an absent clause has to render nothing, and the spelling is not shared with MySQL anyway. So an empty Values is what DEFAULT VALUES is here, and this query writes the keywords itself.

Fields

with: With

WITH ….

table: TableRef

The target: table, optional alias, and the insert column list.

overriding: Option<Overriding>

OVERRIDING … VALUE.

values: Values

The rows, or the query to insert the results of. Empty means DEFAULT VALUES.

conflict: Conflict

ON CONFLICT ….

returning: Returning

RETURNING ….

Implementations

impl InsertQuery

pub fn new() -> InsertQuery

An INSERT with nothing set yet.

pub fn apply(&mut self, mods: impl Mod<InsertQuery>)

Apply more mods to an existing query.

Trait Implementations

impl Clone for InsertQuery

fn clone(&self) -> InsertQuery

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for InsertQuery

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for InsertQuery

fn default() -> InsertQuery

Returns the “default value” for a type.

impl Expression for InsertQuery

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasConflict for InsertQuery

fn conflict_mut(&mut self) -> &mut Conflict

The conflict slot to modify.

impl HasReturning for InsertQuery

fn returning_mut(&mut self) -> &mut Returning

The RETURNING clause to modify.

impl HasTableRef for InsertQuery

fn table_ref_mut(&mut self) -> &mut TableRef

The table reference to modify.

impl HasValues for InsertQuery

fn values_mut(&mut self) -> &mut Values

The row source to modify.

impl HasWith for InsertQuery

fn with_mut(&mut self) -> &mut With

The WITH clause to modify.

impl IntoExpr for InsertQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for InsertQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for InsertQuery

fn query_type(&self) -> QueryType

Which statement this renders.

fn dialect(&self) -> &dyn Dialect

The dialect this query renders itself in.

fn build(&self) -> Result<(String, Vec<Value>), Error>

Render to SQL and arguments, numbering placeholders from 1.

fn build_from(&self, start: usize) -> Result<(String, Vec<Value>), Error>

build with a different first placeholder position, for splicing into a statement that already has arguments — bob’s BuildN.

impl<H, L, M> QueryExtensions<H, L, M> for InsertQuery

fn hooks(&self) -> &[Hook]

Hooks to run before this query executes.

fn loaders(&self) -> &[Loader]

Loaders to run after this query executes, for eagerly loaded relations.

fn mapper_mods(&self) -> &[MapperMod]

Adjustments to the row mapper, for relations loaded in the same query.