Struct PgDialect 

pub struct PgDialect;

PostgreSQL dialect — generates PG-specific SQL syntax.

Trait Implementations

impl Clone for PgDialect

fn clone(&self) -> PgDialect

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PgDialect

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

Formats the value using the given formatter.

impl SqlDialect for PgDialect

fn json_agg_with_columns( &self, b: &mut SqlBuilder, alias: &str, _columns: &[&str], )

JSON array aggregation with explicit column names.

fn row_to_json_with_columns( &self, b: &mut SqlBuilder, alias: &str, _columns: &[&str], )

Single-row JSON with explicit column names.

fn count_expr(&self, b: &mut SqlBuilder, expr: &str)

COUNT function with schema qualification.

fn count_star(&self, b: &mut SqlBuilder)

COUNT(*) for total counts.

fn set_session_var(&self, b: &mut SqlBuilder, key: &str, value: &str)

Set a session/transaction-local variable.

fn get_session_var(&self, b: &mut SqlBuilder, key: &str, column_alias: &str)

Read a session variable in a SELECT expression.

fn type_cast(&self, b: &mut SqlBuilder, expr: &str, ty: &str)

Cast an expression to a type.

fn from_json_body( &self, b: &mut SqlBuilder, columns: &[CoercibleField], json_bytes: &[u8], )

FROM clause for unpacking a JSON body into rows.

fn push_type_cast_suffix(&self, b: &mut SqlBuilder, ty: &str)

Append a type cast suffix to the builder.

fn push_array_type_cast_suffix(&self, b: &mut SqlBuilder, ty: &str)

Append an array type cast suffix to the builder.

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

Quote an identifier (table, column, schema name).

fn quote_literal(&self, lit: &str) -> String

Quote a string literal.

fn supports_fts(&self) -> bool

Full-text search predicate.

fn fts_predicate( &self, b: &mut SqlBuilder, config: Option<&str>, column: &str, operator: &str, )

Generate FTS predicate SQL.

fn row_to_json_star(&self, b: &mut SqlBuilder, source: &str)

Convert an entire CTE row to JSON text (for scalar function calls).

fn count_star_from(&self, b: &mut SqlBuilder, source: &str)

COUNT(*) subquery for exact count from a CTE source.

fn push_literal(&self, b: &mut SqlBuilder, s: &str)

Push a single-quoted SQL literal with proper escaping.

fn supports_lateral_join(&self) -> bool

Whether the backend supports LATERAL joins.

fn named_param_assign(&self) -> &str

Named parameter assignment syntax for function calls.

fn json_agg(&self, b: &mut SqlBuilder, alias: &str)

JSON array aggregation expression.

fn row_to_json(&self, b: &mut SqlBuilder, alias: &str)

Single-row JSON expression.

fn session_vars_are_select_exprs(&self) -> bool

Whether session variable setup uses SELECT-based expressions.

fn build_tx_vars_statement(&self, _b: &mut SqlBuilder, _vars: &[(&str, &str)])

Build a single statement that sets all session/transaction variables.

fn supports_dml_cte(&self) -> bool

Whether the backend supports DML (INSERT/UPDATE/DELETE) inside CTEs.

impl Copy for PgDialect