开发者

PostgreSQL table describe output, what does it mean?

开发者 https://www.devze.com 2023-02-11 13:25 出处:网络
So I get output like this when I do a table describe on a PostgreSQL table. 2, module, varchar, -1, 68, t

So I get output like this when I do a table describe on a PostgreSQL table.

2, module, varchar, -1, 68, t

I'm guessing 2 is the column number, "module" is the column name, varchar is the datatype, 68 is the length, t is nullable.

Is this correct and what does th开发者_高级运维e -1 signify?

Thanks


-1 is the "typmod" (type modifier). For most types, -1 means default or unspecified. For varchar, specifically, -1 means unlimited length.

0

精彩评论

暂无评论...
验证码 换一张
取 消