>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.