PostgresDriver class final

Owns a native postgres pool; each callback pins one physical connection.

The connection opens lazily on acquisition. Configuration is independent of SQLite. Use pg.PoolSettings for limits, TLS, timeouts and application name. Every isolation level and read-only transaction mode is supported.

SQL uses PostgreSQL's native $1, $2, ... placeholders without rewriting. Each call executes one statement using the extended protocol, regardless of the pool's queryMode. Prepared transactions are unsupported and rejected. Parameters support int, String, bool, double, DateTime, Uint8List and null. Dates are bound as UTC timestamptz; byte arrays use bytea. Unsupported values fail before SQL execution. Native PostgreSQL result types are preserved. Native exceptions propagate unchanged. PostgreSQL server errors retain pg.ServerException codes and constraint metadata. SQLSTATE 23505 and 23503 retain their native unique and foreign-key exception subclasses. Application SQL follows PostgreSQL session-setting persistence rules. Use SET LOCAL inside Database.transaction for scoped configuration.