Struct PostgresBackend 

pub struct PostgresBackend {
    pub read_only: bool,
    /* private fields */
}

PostgreSQL database backend.

All connection pools — including the default — live in a single concurrent cache keyed by database name. No external mutex required.

Fields

read_only: bool

Implementations

impl PostgresBackend

pub async fn new(config: &DatabaseConfig) -> Result<Self, AppError>

Creates a new PostgreSQL backend from configuration.

Stores a clone of the configuration for constructing connection options for non-default databases at runtime. The initial pool is placed into the shared cache keyed by the configured database name.

Errors

Returns AppError::Connection if the connection fails.

Trait Implementations

impl Clone for PostgresBackend

fn clone(&self) -> PostgresBackend

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl DatabaseBackend for PostgresBackend

async fn list_databases(&self) -> Result<Vec<String>, AppError>

Lists all accessible databases.

async fn list_tables(&self, database: &str) -> Result<Vec<String>, AppError>

Lists all tables in a database.

async fn get_table_schema( &self, database: &str, table: &str, ) -> Result<Value, AppError>

Returns column definitions for a table.

async fn get_table_schema_with_relations( &self, database: &str, table: &str, ) -> Result<Value, AppError>

Returns column definitions with foreign key relationships.

async fn execute_query( &self, sql: &str, database: Option<&str>, ) -> Result<Value, AppError>

Executes a SQL query and returns rows as a JSON array.

async fn create_database(&self, name: &str) -> Result<Value, AppError>

Creates a database if it doesn’t exist.

fn dialect(&self) -> Box<dyn Dialect>

Returns the SQL dialect for this backend.

fn read_only(&self) -> bool

Whether read-only mode is enabled.

impl Debug for PostgresBackend

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

Formats the value using the given formatter.