ATTACH ​

ATTACH makes another file-backed or in-memory database available through one embedded connection. Qualify its tables with the namespace, such as aux.notes.

Syntax ​

ATTACH [DATABASE] 'path' AS namespace

Interface ​

A server connection rejects ATTACH on both native and HTTP interfaces. Create managed server databases with CREATE DATABASE and select them with USE.

Example ​

Using the embedded Connection API ​

The following application uses an in-memory attachment, so it does not require an existing database file:

use coordinator::Connection;

fn main() -> coordinator::Result<()> {
    let mut db = Connection::open_in_memory()?;
    db.execute("ATTACH ':memory:' AS aux; CREATE TABLE aux.notes(id INTEGER); INSERT INTO aux.notes VALUES(1);")?;
    let result = db.query("SELECT id FROM aux.notes")?;
    assert_eq!(result.rows[0][0].scalar_text(), "1");
    Ok(())
}