golang & python 连接 postgreSQL及postgre如何插入含有单引号的字符串

最新推荐文章于 2023-12-12 16:15:07 发布

YMY_mine

最新推荐文章于 2023-12-12 16:15:07 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： python 数据库 go

本文链接：https://blog.csdn.net/YMY_mine/article/details/99647340

python 同时被 3 个专栏收录

32 篇文章

订阅专栏

25 篇文章

订阅专栏

数据库

9 篇文章

订阅专栏

golang

package main

import _ "github.com/lib/pq"

func main() {

	pgsqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+"password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)

	db, err := sql.Open("postgres", pgsqlInfo)

	//fmt.Println(reflect.TypeOf(db))  //*sql.DB

	err = db.Ping() //会将连接立马返回给连接池。

	query_sql := "select * from tablename"

	rows, err := db.Query(query_sql)

	defer rows.Close()

}

python

psycopg2安装：http://www.linuxyw.com/517.html

import psycopg2
def conn_pg():
    conn = psycopg2.connect(database='aaa',user='bbb',password='***',host='ccc',port='111')
    cur = conn.cursor()
    cur.execute("select * from pg_tablename where ip = 'ccc'")

    rows = cur.fetchall()
    print(rows)

    conn.commit()  //update delete insert 都得提交

    cur.close()
    conn.close()
    
if __name__ == '__main__':
    conn_pg()

当要insert (str=' Got fatal errom master : 'The slave is connecting using TO_POSogs couires.' ') 里面含有单引号的字符串时，解决方法是：把里面的单引号，替换成两个单引号即可。注：postgre 不识别双引号

' Got fatal error 1236 from master : ''The slave is connecting using TO_POSogs couires.'' '

可以用str.replace(" ' "," '' ")