Struct Postgres 

pub struct Postgres;

PostgreSQL dialect marker type.

Trait Implementations

impl Dialect for Postgres

const AUTO_PK: &'static str = "BIGSERIAL PRIMARY KEY"

Auto-increment primary key DDL fragment.

const INSERT_IGNORE: &'static str = "INSERT"

INSERT OR IGNORE prefix for this backend.

const CONFLICT_NOTHING: &'static str = "ON CONFLICT DO NOTHING"

Suffix for conflict-do-nothing semantics.

const COLLATE_NOCASE: &'static str = ""

Case-insensitive collation suffix for ORDER BY / WHERE clauses.

const EPOCH_NOW: &'static str = "EXTRACT(EPOCH FROM NOW())::BIGINT"

Current epoch seconds expression.

const NOW: &'static str = "NOW()"

Current timestamp expression, for direct assignment into a TEXT/TIMESTAMPTZ updated_at-style column (as opposed to Self::EPOCH_NOW, which yields an integer).

const JSON_CAST: &'static str = "::jsonb"

Cast suffix for a bind parameter carrying pre-serialized JSON text, destined for a JSON-typed column.

const TIMESTAMPTZ_CAST: &'static str = "::timestamptz"

Cast suffix for a bind parameter carrying a pre-formatted timestamp string, destined for a timestamp-typed column.

const GREATEST_FN: &'static str = "GREATEST"

Scalar function name returning the greatest of two (or more) numeric arguments.

const LEAST_FN: &'static str = "LEAST"

Scalar function name returning the least of two (or more) numeric arguments.

fn ilike(col: &str) -> String

Case-insensitive comparison expression for a column.

fn epoch_from_col(col: &str) -> String

Epoch seconds expression for a timestamp column.

fn select_as_text(col: &str) -> String

Project a non-TEXT column so it decodes into a plain String.

fn timestamptz_from_epoch(placeholder: &str) -> String

Timestamp expression for binding a Unix epoch-seconds value into a TEXT/TIMESTAMPTZ compacted_at-style column.