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,
