Thanks David for clarifying. I am coming from an Oracle background, so there we(developers) mostly use CHAR or VARCHAR2 data types for such identifiers instead of CLOB.
Sorry for my naiveness about PostgreSQL doc practices.
On Wednesday, July 17, 2024, Muhammad Ikram <mmikram@gmail.com> wrote:
IMHO, a minor issue in the doc. As a good practice we use TEXT data type when we expect longer text e.g. comments, doc kind of columns.
Who is we in this conversation? If it’s the documentation please reference existing work. Text is our preferred type and we are fairly consistent in using it to my knowledge.