Rust 执行postgresql
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | postgres = "0.19.2" use postgres::{Client, NoTls}; fn main() - > Result<(), postgres::Error> { let mut client = Client::connect( "host=localhost dbname=test user=postgres password=postgres" , NoTls)?; client.batch_execute(" CREATE TABLE person ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, data BYTEA ) ")?; let name = "Ferris" ; let data = None ::<&[u8]>; client.execute( "INSERT INTO person (name, data) VALUES ($1, $2)" , &[&name, &data], )?; for row in client.query( "SELECT id, name, data FROM person" , &[])? { let id : i32 = row.get( 0 ); let name: & str = row.get( 1 ); let data: Option<&[u8]> = row.get( 2 ); println!( "found person: {} {} {:?}" , id , name, data); } Ok(()) } |
【推荐】FlashTable:表单开发界的极速跑车,让你的开发效率一路狂飙
【推荐】Flutter适配HarmonyOS 5知识地图,实战解析+高频避坑指南
【推荐】博客园的心动:当一群程序员决定开源共建一个真诚相亲平台
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步