>I have done some research after converting my database from MySQL 5.6 to PostgreSQL 9.6 (the best move I have ever made), >and the consensus I found can be summed up as:
>1. Never, neve, never use VARCHAR or even CHAR
>2. Always always, always use TEXT
>Unless, that is, you have some kind of edge case. This may require a little work upfront, but it will save you from a >TON of grief down the road.
Can you elaborate? Why would anyone create a text column to store customer name or product name which can very well be in varchar(50) type of cols.