PostgreSQL: Script to Find Table and Column without comment or description

In this post, I am sharing one script to find the table and column, which are not associated with any comment or description of PostgreSQL.

Self documentation is a most important thing for every developer and company.
In our company, I have strictly set this rule as database development standard to write a comment of description for every table and column.

You can also manage this description using different UML tools, but first thing is: it should be attached to the database objects so whenever you are going to create a database diagram then comment or description added automatically.

The Humans are made for mistake so sometimes I have to find such a list object which are not associated with any comment or description.

Basically at this time I am sharing this DBA script for PostgreSQL.
I have filtered below query by giving User_Name in WHERE clause so if you want for all users then you should remove this filter.

Find Table without comment.

Find Column without comment.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from