postgresql 字段默认值?

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 2118 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