Struct barrel::backend::Pg

pub struct Pg;

Postgres SQL generator backend

Trait Implementations

impl SqlGenerator for Pg

fn create_table(name: &str, schema: Option<&str>) -> String

Create a new table with a name

fn create_table_if_not_exists(name: &str, schema: Option<&str>) -> String

Create a new table with a name, only if it doesn’t exist

fn drop_table(name: &str, schema: Option<&str>) -> String

Drop a table with a name

fn drop_table_if_exists(name: &str, schema: Option<&str>) -> String

Drop a table with a name, only if it exists

fn rename_table(old: &str, new: &str, schema: Option<&str>) -> String

Rename a table from to

fn alter_table(name: &str, schema: Option<&str>) -> String

Modify a table in some other way

fn add_column(ex: bool, schema: Option<&str>, name: &str, tt: &Type) -> String

Create a new column with a type

fn drop_column(name: &str) -> String

Drop an existing column from the table

fn rename_column(old: &str, new: &str) -> String

Rename an existing column

fn create_index(
    table: &str,
    schema: Option<&str>,
    name: &str,
    _type: &Type
) -> String

Create a multi-column index

fn create_constraint(name: &str, _type: &Type) -> String

Create a constraint

fn drop_index(name: &str) -> String

Drop a multi-column index

fn add_foreign_key(
    columns: &[String],
    table: &str,
    relation_columns: &[String],
    schema: Option<&str>
) -> String

Add a foreign key

fn add_primary_key(columns: &[String]) -> String

fn create_partial_index(
    table: &str,
    schema: Option<&str>,
    name: &str,
    _type: &Type,
    conditions: &str
) -> String

Create a multi-column index