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 upsert_do_nothing_clause(&self, c: &[&str]) -> String

Emit a DO NOTHING/insert-ignore clause for the conflict target. Default empty (fallback dialects skip the single-statement path entirely). PG/SQLite/DuckDB return ON CONFLICT (...) DO NOTHING; MySQL returns ON DUPLICATE KEY UPDATE id = id (no-op self-assign).

fn insert_has_returning(&self) -> bool

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

fn supports_sql_emission(&self) -> bool

Whether this dialect supports SQL emission for upsert / nested-write generation. Returns false for document-store dialects (NotSql) that unimplemented!() on quote_ident / placeholder / upsert_clause. Callers must check this before issuing any SQL via the dialect.

fn supports_upsert(&self) -> bool

True if this dialect’s upsert_clause can produce a usable single-statement INSERT ... ON CONFLICT/ON DUPLICATE form, and (separately) if placeholder and quote_ident are real implementations. False for document-store/NotSql dialects whose SQL-emitting methods are unimplemented!().

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.