BUG #16052: pg_dump --no-comments not working
The following bug has been logged on the website:
Bug reference: 16052
Logged by: cd a
Email address: cdalxndr@yahoo.com
PostgreSQL version: 11.5
Operating system: Windows 10
Description:
Using the following command:
pg_dump -U postgres -p 5433 -n schema -s --no-comments > schema.sql
The output still has comments:
--
-- PostgreSQL database dump
--
-- Dumped from database version 11.5
-- Dumped by pg_dump version 11.5
--
-- Name: schema; Type: SCHEMA; Schema: -; Owner: -
--
PG Bug reporting form <noreply@postgresql.org> writes:
Using the following command:
pg_dump -U postgres -p 5433 -n schema -s --no-comments > schema.sql
The output still has comments:
--
-- PostgreSQL database dump
--
--no-comments means to suppress dumping of database-object
comments (created with the COMMENT command).
regards, tom lane