What to use to store in postgresql a string with no specific upper limit?
On the postgresql manual page: If you desire to store long strings with no specific upper limit, use text or character varying without开发者_如何学JAVA a length specifier.
My question is: when to use which ? Or it doesn't matter ?
They are the same. Use what you prefer :)
Although text
is not SQL standard I prefer it because is sorter.
精彩评论