postgresql 字段默认值?

This topic created in 2295 days ago, the information mentioned may be changed or developed.

CREATE TABLE test (
	ip inet,
	port integer not null default 0,
	country char(10) not null default '',
	PRIMARY KEY(ip)
)
insert into test (ip, port) values('1.1.1.1', 80)

结果 country 里面有 10 个空字符. 这是为啥?

2 replies • 2020-07-23 11:47:02 +08:00

ooh

Jul 23, 2020

char 长度固定，长度不足的话空格补上

optional

Jul 23, 2020 via iPhone

pg 无脑 text