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 1uNZAs-004af7-9q for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Jun 2025 15:40:06 +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 1uNZAp-00CeU9-2f for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Jun 2025 15:40:03 +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 1uNZAo-00CeU1-OD for pgsql-hackers@lists.postgresql.org; Fri, 06 Jun 2025 15:40:03 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uNZAn-000ZGg-2C for pgsql-hackers@postgresql.org; Fri, 06 Jun 2025 15:40:03 +0000 Received: by mail-io1-xd31.google.com with SMTP id ca18e2360f4ac-86d0bd7ebb5so63197139f.0 for ; Fri, 06 Jun 2025 08:40:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749224399; x=1749829199; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Jgaws6wE1X7Ph4VWZHCdMWY+HAxpDCYikz/Un4mmF4Y=; b=LuYdZ8mzv0XIVfZkGhVVKMruOSRb/ICafO4Y9h81EZKXo66QcTDkOSXNeen8TBcvX7 POUcVn1+sH7P+jvuluW89LOTZOwBN2wxd/JsBX54uwmi/pGaYPlYVipntOI3oL13HF1u ffigdyx+D9Z1LvxJNWSxG6rv075k/2EodK6KgeqzF0hWxbw+hXE79DfeKFQatmeYe7kn RS1f1cEblJM+0TyapfuuiyVfGjSBF8aUz9ntWbnQhnbTntToSbEwHDYn81LCf+RpTvGg G2Z5rvY8F3RyJ1tzjL6UxIIsz2Tx76x2222mLdsX9LuT0S0WvOlJ+4iOTdHc17SvNyWG bbiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749224399; x=1749829199; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Jgaws6wE1X7Ph4VWZHCdMWY+HAxpDCYikz/Un4mmF4Y=; b=gGwT9xG5jvuudRt4I48qb5q95YYVVQWg1rDcsufI9gcV/rn4jeqF9GnS+5MXW+lrWu f8c+88ohRxpUGAC6OdOT58lCo8bnYjugdMQvP/n7RVffaI4o89YKO1cD67piZio/fxhL a5EnyUjoFPZdsg6HB1a0eC9UoPiaF/9AcIU6Rl+eR8DyR1lZthCvlwoSTr4pz+G7mKov KUMFm0F1ahcGB63B0SWWhFR9cGc+ri/xJ640nmW7o/mvtfulilum9Y4JRl4698DnfHNh jaKvX/dMoQzYylHq7WNuD6IycxemQS3GhoCflwRHUwDcBVOZesiH7RN9FyCNb9m8Oozg SWUA== X-Gm-Message-State: AOJu0YyftZgQFnWehalxYB8UkwYtY9TVvZaY+yFg832LcoE9ygSbl2C/ yxgyevdH9i+Xe9BaBoO9af5lEmq6WqJfOxZi9y33LITH8vIN4viIQP3meTqkLg== X-Gm-Gg: ASbGncus7AoXyGzMkVOZ+kXjdZrOarRQM5sfuDu8BhJs23KdVKPl0vk4Iphk67N2l7M KUQoDSbyoQc+iZfoNC/pu4befqzP/jFEwwpfIgznNoL1vCk6OGoeTbF74stouADSUUuo/E/0Ldp 4MfR/RDjFlHu2xx/Cfe0yN9tuLZT82wdXpSwHNlhrHfosePwLG01VDoG/tM7W1oUECh080ZbeYV Ym8WS6CSNg385DGm1NGOAzo9lGU7aMw+87cyflZIAwsQ+jmhTk0eWvCwsa3YCZFs8WK7DR2Jor4 ucxw7OXkNnLznYv8y+kS3MM+PmHhaSv38uvDlOlxHgj6MIBX05eerFQ9ko+MbQUwEBLMNzKl0vA leY4ZblffJTzdB0NnQcCvY1HB0i7FJfNC+rXgUzF5HmQCu5KI0uiE X-Google-Smtp-Source: AGHT+IG555puF3m0fLvO4QGGYRvKOhnaju0OfcDiZXHM51QgbW37XAwtINvxcUXfw81YIBpdBjGcnA== X-Received: by 2002:a05:6602:4810:b0:861:d71f:33e3 with SMTP id ca18e2360f4ac-8733665cc27mr467065339f.5.1749224398925; Fri, 06 Jun 2025 08:39:58 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-500df3f63desm492552173.29.2025.06.06.08.39.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 06 Jun 2025 08:39:58 -0700 (PDT) Date: Fri, 6 Jun 2025 10:39:56 -0500 From: Nathan Bossart To: Peter Eisentraut Cc: pgsql-hackers , pgsql@j-davis.com Subject: Re: pg_dump --with-* options Message-ID: References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 06, 2025 at 09:14:32AM +0200, Peter Eisentraut wrote: > We have > > -a, --data-only dump only the data, not the schema or statistics > --no-data do not dump data > --with-data dump the data # this one is new > > (and there is also --section=data), and then three analogous options for > "schema" and "statistics". > > What is the purpose of the --with-data option? Dumping the data is the > default. Is this to override an earlier --no-data option? I believe the idea is that these will allow folks to be explicit about what they want instead of needing to understand the defaults for every component. -- nathan