Struct PostgresSqlGenerator 

pub struct PostgresSqlGenerator;

SQL generator that produces PostgreSQL-compatible SQL.

Implementations

impl PostgresSqlGenerator

pub fn new() -> Self

Trait Implementations

impl Clone for PostgresSqlGenerator

fn clone(&self) -> PostgresSqlGenerator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PostgresSqlGenerator

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

Formats the value using the given formatter.

impl Default for PostgresSqlGenerator

fn default() -> Self

Returns the “default value” for a type.

impl ISqlGenerator for PostgresSqlGenerator

fn select(&self, table: &str, columns: &[&str]) -> String

Generates a SELECT statement.

fn insert(&self, table: &str, columns: &[&str], returning: bool) -> String

Generates an INSERT statement.

fn insert_batch( &self, table: &str, columns: &[&str], row_count: usize, ) -> String

Generates a multi-row INSERT statement with row_count value groups (INSERT INTO t (c1, c2) VALUES (?, ?), (?, ?), ...). Placeholders follow the dialect’s numbering (? for SQLite/MySQL, $n for PG).

fn upsert_batch( &self, table: &str, columns: &[&str], conflict_cols: &[&str], row_count: usize, ) -> String

Generates a batch UPSERT statement (row_count value groups).

fn update( &self, table: &str, set_columns: &[&str], where_clause: &str, ) -> String

Generates an UPDATE statement.

fn delete(&self, table: &str, where_clause: &str) -> String

Generates a DELETE statement.

fn create_table(&self, table: &str, columns: &[(String, String)]) -> String

Generates a CREATE TABLE statement.

fn drop_table(&self, table: &str) -> String

Generates a DROP TABLE statement.

fn pagination(&self, skip: Option<usize>, take: Option<usize>) -> String

Generates a pagination clause.

fn parameter_placeholder(&self, index: usize) -> String

Returns the parameter placeholder (e.g., $1 for PG, ? for MySQL).

fn quote_identifier(&self, identifier: &str) -> String

Returns the identifier quoting character (e.g., " for PG, ` for MySQL).

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

Returns the dialect-specific auto-increment syntax.

fn supports_returning(&self) -> bool

Whether insert_batch includes a RETURNING * clause (PostgreSQL). When true, execute_inserts uses query() to read back generated PKs directly from the INSERT result set.

fn uses_numbered_placeholders(&self) -> bool

Whether the dialect uses numbered placeholders (e.g. PostgreSQL $1, $2) where the index depends on position within the full statement.

fn update_batch( &self, table: &str, set_columns: &[&str], pk_col: &str, row_count: usize, where_clause: &str, ) -> String

Generates a batch UPDATE using CASE pk_col WHEN ? THEN ? for row_count rows, reducing N round trips to 1.

fn last_insert_id_sql(&self) -> Option<&'static str>

SQL that retrieves the auto-increment key generated by the most recent batch INSERT. Returns None when the dialect uses RETURNING instead.

fn last_insert_id_returns_first(&self) -> bool

Whether last_insert_id_sql() returns the FIRST (MySQL) or LAST (SQLite) generated ID in a batch INSERT. The executor uses this to compute the full key sequence: first_id..first_id+N or last_id-N+1..last_id.