PostgreSQL table describe output, what does it mean?
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.
精彩评论