Currently, the pg_dump tool outputs comments in different formats for primary/foreign keys and indexes. Below is the comment format.
- for Primary key: -- Name: TABLENAME CONSTRAINTNAME; Type: CONSTRAINT; Schema: SCHEMA; Owner: OWNER - for Foreign key: -- Name: TABLENAME CONSTRAINTNAME; Type: FK CONSTRAINT; Schema: SCHEMA; Owner: OWNER - for Index: -- Name: INDEXNAME; Type: INDEX; Schema: SCHEMA; Owner: OWNER To maintain consistency, I suggest modifying the comment format for indexes to include the associated TABLENAME, similar to constraints. For example: - for Index: -- Name: TABLENAME INDEXNAME; Type: INDEX; Schema: SCHEMA; Owner: OWNER This small change would improve clarity and make the output format more uniform. If I am reporting this to the wrong forum, please excuse me. If possible, kindly suggest the correct forum for submitting this request. Regards,
