Include Comments in Schema

[jorinvo]

Hi, so Postgres tables/columns/views show up when querying duckdb_tables/duckdb_columns/duckdb_views which is great!
This metadata also contains a column called "comment".
And Postgres supports comments on tables/columns/views just like DuckDB does.

I was hoping that the comments from Postgres would also show up when querying metadata from DuckDB.
I am curious if this is simply missing or if there is another reason for this behavior.
And are you interested in supporting comments?
Thank you for all the hard work on this extension!

[anirudhp-ops]

Hi, I'm interested in working on this issue! Before I dive in, I wanted to check — is this something the team would like to support? If so, I'd be happy to implement it. Any pointers on where in the codebase to start looking would also be greatly appreciated. Thanks!

[staticlibs]

@anirudhp-ops

is this something the team would like to support

Yes, I think comments support may be useful, a PR would be welcome (cannot guarantee the timed review though).

Any pointers on where in the codebase to start looking

Off the top of my head I would think it should be added somewhere in PostgresTableEntry.

[anirudhp-ops]

Hi, just checking in on PR #450 — happy to make any changes if needed!