Struct 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