Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uRZwQ-00DdwT-LN for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Jun 2025 17:17:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uRZwO-00BbNe-PK for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Jun 2025 17:17:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uRZwO-00BbNV-BY for pgsql-hackers@lists.postgresql.org; Tue, 17 Jun 2025 17:17:45 +0000 Received: from mail-pg1-x531.google.com ([2607:f8b0:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uRZwM-002aB4-1n for pgsql-hackers@postgresql.org; Tue, 17 Jun 2025 17:17:44 +0000 Received: by mail-pg1-x531.google.com with SMTP id 41be03b00d2f7-b2c4331c50eso4758388a12.3 for ; Tue, 17 Jun 2025 10:17:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1750180660; x=1750785460; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=bTV5TEpGwLFVf5J0d6UFhpip2Y7PAP3eM1qxBAi4Opw=; b=GG2k4BbtXHoWxOiuthUHvdd3gWEzrqUP/JU/Cq6jVM3A10td3kQ3OPTICfpRByjOC/ /7zPPje5E0wV1QFHyFxhOzZpeUC0oyXZPbrpxVWlJEVcGEqQtZD0zmkXw+QNAIDnFN6d TQejlz4jPIu3vOHkGXLDHmgmOuIC2uJLO6iFkd2Xt++cLgCiFXgGNiUDqvg+h3I60IxD tfO06vymaLWDNpZSnE9fZ/IX6xfsM9PUznzWdtkUt3zJXLHwQiQ0yQaFEvBVDrtsE66O KgB219pYB9BLnXmfU+4sX5O190WKvKeh9aaNVoZUy15KPrqZ1c5ETlO6B8QMz3M7fKuX qH7w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750180660; x=1750785460; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=bTV5TEpGwLFVf5J0d6UFhpip2Y7PAP3eM1qxBAi4Opw=; b=ekjuCIWueYf0GIoP2of/IHiHtu8EJrJWNRl1uiDwXxxCjXde+ZNBJFPII4AmEND+Aa AcfybNm/Iux1uhnvsVMBCjNnG7RkBRNzNHDVEGwkAi5/N3yAdt+J0Nz6Ve/D2LZwCi78 hsTOSOna6cWjf1PemOXAs6Gy8TrBGRolG24I3euUlOscqWuRgBigJgXY4EAsNz573qKe eilpqVQDFKdFmxJmzWMuJwUtXRAkBbSkxhoDxZok+sPgNiBUPtx4mpcfHx+wyVqlydbw GD/quZ9TXN6QGqOd0eGkCJed0I7s+Yn2jpBW8aGvoECRx8bw6pxehJO8u0yKsX4LwSCv V4fA== X-Forwarded-Encrypted: i=1; AJvYcCVuUgG/6/8dkXPRf6gfaG72xlWYzjpKAzD8vbvZjmXKtaDOZjYq0AGfkU1UzQbdM70B9I3ZGL6oAn1iqojr@postgresql.org X-Gm-Message-State: AOJu0YxV9UhK0e11blWh14QQiNwtA2JnZht97T0FHz1lFNpbDQGz/tM7 QEFZjrNXGL4YMuVC6XLiuv3TVnKC27R2VRcuUKrpjt/5RYgOlrUnLrKSIqSaeZlGSw== X-Gm-Gg: ASbGnctFL00mXRTtYTJ/80F8XJ+qAeR6o8cmbBKDsKfr/utK8ArSI86pscIyqnIylHu MriRky5GKJkZwEZbBETOdxFjVAeGJkDNYusH1UuEq/R2H3hz19jznElEuvPx+t9eLikIjXzBPd5 Df2mTcRpc8IibudfJ9FnOHJOpzySbJPsMatTx1/oOYfndQA6C7qgXR2SFM+ePa76j/6V46ebHBV 3T0i0cbPI6g3TtFsYBsANypySIZ+DAUh4fCp8WqppWGQRAF6cjOFUpK8N5VpUsXY6DRgA14Hr0n +Ml4TixM1ylfn7fD2d9tt6j4+ie/UUl/YhOff6LaFCVpiCIA5HfoLNa57az5FQ== X-Google-Smtp-Source: AGHT+IEoLF456JduASo/a/quYUcKZ8O0QvevGaLeoAs1y7DlilQSUcdybKQWb4bEEuXTGMin4aKSKA== X-Received: by 2002:a05:6a21:6d90:b0:1f5:8c05:e8f8 with SMTP id adf61e73a8af0-21fbd631610mr20736743637.25.1750180660036; Tue, 17 Jun 2025 10:17:40 -0700 (PDT) Received: from [172.18.4.26] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b31bfa14f88sm1149337a12.1.2025.06.17.10.17.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Jun 2025 10:17:39 -0700 (PDT) Message-ID: <2a1a00a7393c2bdfc7051c697f801716c0601d1f.camel@j-davis.com> Subject: Re: pg_dump --with-* options From: Jeff Davis To: Corey Huinker , Fujii Masao Cc: Nathan Bossart , Robert Haas , Peter Eisentraut , pgsql-hackers Date: Tue, 17 Jun 2025 10:17:37 -0700 In-Reply-To: References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <1854ffbf-f8eb-4bc3-b9f8-223bbf58c392@oss.nttdata.com> <271f899c54d112b353e009286af7c6cdb7c3d609.camel@j-davis.com> <94f89b0a-5d83-4a67-9092-50ba3913441c@oss.nttdata.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-06-16 at 15:35 -0400, Corey Huinker wrote: >=20 > I think this is the exact sort of confusion caused by having two of > the three types default to on in all circumstances, and one default > to off in one special circumstance. That's certainly a part of the confusion, but the "--x-only" options also put us in a tough spot. If --data-only had always been spelled "--no-schema" (or "--without- data" or whatever), and --schema-only had always been spelled "--no- data", then I think it would be a lot easier to add statistics into the mix. Regards, Jeff Davis