Suggestion to standardize comment format in pg_dump

From: Nohez Poonawala <nohezp(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Suggestion to standardize comment format in pg_dump
Date: 2024-12-11 06:37:34
Message-ID: CAE0ZbBFSBh-CGWXA8n_P7a=KSkT6Tu7uMN7vkBCdMbAtNd8aTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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,

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kirill Reshke 2024-12-11 06:37:49 Re: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)
Previous Message Kirill Reshke 2024-12-11 06:22:39 Re: CREATE SCHEMA ... CREATE DOMAIN support