Extensions
`DETACH`
```sql
DETACH postgres_db;
```  
#### Transactions {#docs:extensions:postgres::transactions}  
```sql
CREATE TABLE postgres_db.tmp (i INTEGER);
BEGIN;
INSERT INTO postgres_db.tmp VALUES (42);
SELECT * FROM postgres_db.tmp;
```  
This returns:  
|    i |
| ---: |
|   42 |  
```sql
ROLLBACK;
SELECT * FROM postgres_db.tmp;
```  
This returns an empty table.