Re: Design strategy for table with many attributes

2024-07-04 Thread Kent Dorfman
On 7/4/24 15:37, Lok P wrote: Or say, what is the maximum number of columns per table we should restrict? Should we break the single transaction into multiple tables like one main table and other addenda tables with the same primary key to join and fetch the results wherever necessary? 900 co

Re: Description field for tables and views

2024-07-03 Thread Kent Dorfman
On 7/3/24 15:30, Christophe Pettus wrote: On Jul 3, 2024, at 12:28, Kent Dorfman wrote: Is there any psql function/command to add a description field to a table or view definition in the system? Allow me to introduce you to my good friend "COMMENT": https://www.postgresq

Description field for tables and views

2024-07-03 Thread Kent Dorfman
I think I already know the answer but asking here is probably quicker turnaround than researching it. I've gotten into a "view bloat" scenario with many many custom views that I cannot remember what they actually do.  Is there any psql function/command to add a description field to a table or