Crate postgres

Rust-Postgres is a pure-Rust frontend for the popular PostgreSQL database. It exposes a high level interface in the vein of JDBC or Go’s database/sql package.

extern crate postgres;

use postgres::{Connection, SslMode};

struct Person {
    id: i32,
    name: String,
    data: Option<Vec<u8>>
}

fn main() {
    let conn = Connection::connect("postgresql://postgres@localhost", &SslMode::None)
            .unwrap();

    conn.execute("CREATE TABLE person (
                    id              SERIAL PRIMARY KEY,
                    name            VARCHAR NOT NULL,
                    data            BYTEA
                  )", &[]).unwrap();
    let me = Person {
        id: 0,
        name: "Steven".to_string(),
        data: None
    };
    conn.execute("INSERT INTO person (name, data) VALUES ($1, $2)",
                 &[&me.name, &me.data]).unwrap();

    let stmt = conn.prepare("SELECT id, name, data FROM person").unwrap();
    for row in stmt.query(&[]).unwrap() {
        let person = Person {
            id: row.get(0),
            name: row.get(1),
            data: row.get(2)
        };
        println!("Found person {}", person.name);
    }
}

Modules

• error
  Error types.
• io
  Types and traits for SSL adaptors.
• rows
  Query result rows.
• types
  Traits dealing with Postgres data types

Macros

• accepts
  Generates a simple implementation of ToSql::accepts which accepts the types passed to it.
• to_sql_checked
  Generates an implementation of ToSql::to_sql_checked.

Structs

• CancelData
  Contains information necessary to cancel queries for a session.
• Column
  Information about a column of the result of a query.
• ConnectParams
  Information necessary to open a new connection to a Postgres server.
• Connection
  A connection to a Postgres database.
• LoggingNoticeHandler
  A notice handler which logs at the info level.
• Notification
  An asynchronous notification.
• Notifications
  An iterator over asynchronous notifications.
• Statement
  A prepared statement.
• Transaction
  Represents a transaction on a database connection.
• UserInfo
  Authentication information.

Enums

• ConnectTarget
  Specifies the target server to connect to.
• IsolationLevel
  An enumeration of transaction isolation levels.
• SslMode
  Specifies the SSL support requested for a new connection.

Traits

• GenericConnection
  A trait allowing abstraction over connections and transactions
• HandleNotice
  Trait for types that can handle Postgres notice messages
• IntoConnectParams
  A trait implemented by types that can be converted into a ConnectParams.

Functions

• cancel_query
  Attempts to cancel an in-progress query.

Type Aliases

• Result
  A type alias of the result returned by many methods.