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,
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 |