pg数据库只读怎么关掉

硬锁定，直接将数据库切换到恢复模式，绝对不会有写 *** 作出现、软锁定，设置default_transaction_read_only为on，默认开启的事务为只读事务。用户如果使用begiontransactionreadwrite可破解。

SELECT

pg_proc.proname AS "函数名称",

pg_type.typname AS "返回值数据类型",

pg_proc.pronargs AS "参数个数"

FROM

pg_proc

JOIN pg_type

ON (pg_proc.prorettype = pg_type.oid)

WHERE

pg_type.typname != 'void'

AND pronamespace = (SELECT pg_namespace.oid FROM pg_namespace WHERE nspname = 'public')

---