# default configuration for text search default_text_search_config = 'pg_catalog.english' # - Other Defaults - #dynamic_library_path = '$libdir' #local_preload_libraries = '' #session_preload_libraries = '' 十九、错误处理ERROR HANDLING #exit_on_error = off # terminate session on any err...
error message # strings lc_monetary = 'zh_CN.UTF-8' # locale for monetary formatting lc_numeric = 'zh_CN.UTF-8' # locale for number formatting lc_time = 'zh_CN.UTF-8' # locale for time formatting # default configuration for text search default_text_search_config = 'pg_catalog....
#default_transaction_isolation = 'read committed' # 每个 SQL 事务都有一个隔离级别,可以是"读未提交"、"读已提交"、"可重复读"或者"可序列化"。 # 这个参数控制每个新事务的默认隔离级别。默认是"读已提交"。 #default_transaction_read_only = off # 一个只读的 SQL 事务不能修改非临时表。 # 这个参...
默认:temp_tablespaces=''临时tablespaces列表,''表示使用系统默认值 a listoftablespace names,''usesonlydefaulttablespace 9.1.4 defaulttransactionisolation 字符型 默认:default_transaction_isolation ='read committed'数据库的隔离级别有四种,分别是Readuncommitte、Readcommitted、Repeatableread、Serializable。 9.1.5 ...
ALTERSYSTEMSETconfiguration_parameter{TO|=}{value|'value'|DEFAULT} 1. 例如:我们现在要修改 maintenance_work_mem --查看所有数据库参数的值 show all;show maintenance_work_mem;--注意这里的设置不会改变postgresql.conf,只会改变postgresql.confALTERSYSTEMSETmaintenance_work_mem=1048576;--重启数据库 ...
name[CONSTANT]type[COLLATEcollation_name][NOTNULL][{DEFAULT|:=|=}expression]; 在自定义函数中声明一个变量,并给这个变量赋值的时候可以用这个方法。示例如下: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 --1declare a integerdefault32;--2declare a integer:=32;--3declare a integer;a:=32;...
CREATE[ORREPLACE]PROCEDUREname([[argmode][argname]argtype[{DEFAULT|=}default_expr][,...]]){LANGUAGElang_name|TRANSFORM{FORTYPEtype_name}[,...]|[EXTERNAL]SECURITYINVOKER|[EXTERNAL]SECURITYDEFINER|SETconfiguration_parameter{TOvalue|=value|FROMCURRENT}|AS'definition'|AS'obj_file','link_symbol'|...
ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT } 将参数从postgresql.auto.conf文件中移除 ALTER SYSTEM RESET configuration_parameter 将所有参数从postgresql.auto.conf文件中移除 ALTER SYSTEM RESET ALL 说明:
The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /var/lib/pgsql/14/data ... ok ...
selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok Success. You can now start the database server using: ...