Re: Suggestion to standardize comment format in pg_dump

2024-12-11 Thread Tom Lane
"Euler Taveira" writes: > On Wed, Dec 11, 2024, at 3:37 AM, Nohez Poonawala wrote: >> 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: I

Re: Suggestion to standardize comment format in pg_dump

2024-12-11 Thread Euler Taveira
On Wed, Dec 11, 2024, at 3:37 AM, Nohez Poonawala wrote: > 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

Suggestion to standardize comment format in pg_dump

2024-12-10 Thread Nohez Poonawala
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: