Set table and field doc from postgres COMMENT

[jooon]

Postgres has a non-standard SQL concept called comment:

https://www.postgresql.org/docs/current/sql-comment.html

It shows up when you type \d+ in psql and a few other places and is a pretty nice way of documenting your database with the database.

It would be nice if these comments could be used to populate the avro doc fields. It will obviously be quite hard to figure out column descriptions if you run dbeam with --sqlFile, but if you run with --table it should be easier. This code could always try to probe the database for comments or only be activated by a flag.

If I have time later, I will try to add a pull-request, just wanted to first post my idea/feature request.

[rulle-io]

Thanks for pointing to this (unknown for me) SQL concept.

dbeam currently gets all metadata information about an SQL table using interface ResultSetMetaData.
Using anything else (e.g. external utility psql) would make code much more complicated and vendor-specific.