Hi all, I am not an expert in DB. So please excuse, if the question is stupid.
In PostgreSQL, we do support custom data types - say enum type. --> CREATE TYPE testtype AS ENUM {'test1', 'test2'}; Now, I was wondering whether we should be using a different table or the enum itself for the same? --> CREATE TABLE testtypetable { testtype varchar(3) PRIMARY KEY, id serial }; A new table would help in any modification of enum values, right? But then there is a mechanism to create this type, so there must be some extremely pertinent reason for having the same. Other than ease of use, I couldnt find any.
