下方是一个表,这个表里面server ICU 为NO 的是 PG 目前不支持的字符编码。 而UTF8 为什么为一个大多数PG的字符的标准,因为这个编码是 ALL,也就是通吃各种字符以及国别的语言。 而这些是怎么带入到我们的建库语句中,参见下图, create database encoding 以及 LC_COLLATE, LC_CTYPE 这三个选项。 en-coding 是...
"gender" varchar(10) COLLATE "pg_catalog"."default" NOT NULL, "address" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "phone" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "grade" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, CONSTRAINT "student_pkey" PRIMARY ...
数据库和堆表的OIDs分别存储在pg_database和pg_class中,可以利用下面的SQL语句查询OIDs。 数据库的OIDs select * from pg_database; postgres=# select * from pg_database; oid | datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid...
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", d.datcollate as "Collate", d.datctype as "Ctype", pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
\d pg_database Table "pg_catalog.pg_database" Column | Type | Modifiers ---+---+--- datname | name | not null datdba | oid | not null encoding | integer | not null datcollate | name | not null datctype | name | not null datistemplate...
首先我最感兴趣的是 pg_stat_io,顾名思义——I/O 类的统计信息 postgres=#\dpg_stat_ioView"pg_catalog.pg_stat_io"Column|Type|Collation|Nullable|Default---+---+---+---+---backend_type|text|||object|text|||context|text|||reads|bigint|||read_time|doubleprecision|||writes|bigint|||...
(50)COLLATE pg_catalog."default",psfs charactervarying(50)COLLATE pg_catalog."default",wjlx charactervarying(50)COLLATE pg_catalog."default",file_sizenumeric(18,6),status charactervarying(20)COLLATE pg_catalog."default",wjly charactervarying(255)COLLATE pg_catalog."default",ztlb charactervarying...
postgres=# \l+ List of databases Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges---+---+---+---+---+---+---+---advent_of_code
"name"varchar(64) COLLATE "pg_catalog"."default", "age" int4, "address"varchar(255) COLLATE "pg_catalog"."default",CONSTRAINT"t2_pkey"PRIMARYKEY("id") );createtablet3(idint,infotext);createtablet4(idint,infotext);CREATEINDEXt3_id_indexONt3 (id);insertintot3selectgenerate_series(1,100...