Display column comments for views in pgAdmin UI

[frgis]

Currently, pgAdmin allows users to view and edit column comments for tables, but not for views. Column comments on views are stored in the PostgreSQL system catalog (pg_description), but there is no way to see them in the pgAdmin interface (Properties dialog, Object browser, etc.).

thanks

[coderabbitai]

📝 CodeRabbit Plan Mode

Generate an implementation plan and prompts that you can use with your favorite coding agent.

• Create Plan

Examples

• Example 1
• Example 2

---

🔗 Similar Issues

Related Issues

• Toggle Comment Ctrl+/ in PgAdmin 9.8 server mode not working #9153

👤 Suggested Assignees

• MaxStr444

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!

[adityatoshniwal]

Hi @frgis,

I can see/edit view columns, here is the screenshot. What is your pgAdmin version?

[frgis]

Hi @adityatoshniwal ,

I apologize for not describing my issue clearly enough. When I add a comment to a column in a materialized view, the comment is correctly saved. However, when I view the materialized view’s SQL script in the SQL tab, the column comments do not appear. The problem is that if I need to drop and recreate the materialized view, I might forget about the column comments and lose them. Would it be possible, as is already the case for tables and regular views, to also display column comments for materialized views in the SQL script?
I am currently using version 6.9 on Windows 11.

Thanks