CODEWITHSUNDEEP
postgresql
johnlemon
johnlemon

Reputation: 21459

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 a length specifier.

My question is: when to use which ? Or it doesn't matter ?

Upvotes: 1

Views: 68

Answers (1)

DavidEG
DavidEG

Reputation: 5957

They are the same. Use what you prefer :)

Although text is not SQL standard I prefer it because is sorter.

Upvotes: 2

Related Questions