Struct Postgres 

pub struct Postgres;

PostgreSQL dialect: $N placeholders, RETURNING, "ident" quoting, ON CONFLICT (cols) DO UPDATE SET ... upserts, DISTINCT ON support.

Trait Implementations

impl SqlDialect for Postgres

fn placeholder(&self, i: usize) -> String

Emit the 1-indexed parameter placeholder for position i.

fn returning_clause(&self, cols: &str) -> String

Emit the clause (leading space included) that requests the given columns be returned after an INSERT/UPDATE/DELETE. Postgres/SQLite/MySQL emit RETURNING cols; MSSQL emits OUTPUT INSERTED.cols.

fn quote_ident(&self, i: &str) -> String

Quote a table/column identifier for safe interpolation.

fn supports_distinct_on(&self) -> bool

Whether the dialect supports SELECT DISTINCT ON (cols) (Postgres-only among our backends today).

fn upsert_clause(&self, c: &[&str], s: &str) -> String

Emit the ON CONFLICT / ON DUPLICATE KEY clause (leading space included) that converts an INSERT into an upsert.

fn insert_has_returning(&self) -> bool

Whether an INSERT statement can use the dialect’s returning clause to retrieve inserted rows in-place.

fn begin_sql(&self) -> &'static str

SQL keyword that begins a transaction. Defaults to BEGIN.

fn commit_sql(&self) -> &'static str

SQL keyword that commits a transaction. Defaults to COMMIT.

fn rollback_sql(&self) -> &'static str

SQL keyword that rolls back a transaction. Defaults to ROLLBACK.