rust postgres
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 | use postgres::{Client, NoTls}; fn main(){ let mut client = Client::connect( "host=localhost user=postgres password=postgres port=5433" , NoTls).unwrap(); client.batch_execute(" CREATE TABLE person ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, data BYTEA ) ").unwrap(); let name = "Ferris" ; let data = None ::<&[u8]>; client.execute( "INSERT INTO person (name, data) VALUES ($1, $2)" , &[&name, &data], ).unwrap(); for row in client.query( "SELECT id, name, data FROM person" , &[]).unwrap() { 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); } } |
【推荐】FlashTable:表单开发界的极速跑车,让你的开发效率一路狂飙
【推荐】Flutter适配HarmonyOS 5知识地图,实战解析+高频避坑指南
【推荐】博客园的心动:当一群程序员决定开源共建一个真诚相亲平台
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步