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 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.