public inbox for [email protected]  

help / color / mirror / Atom feed

From: Wasim Devale <[email protected]>
To: Pgsql-admin <[email protected]>
To: pgsql-admin <[email protected]>
Subject: pg_dump
Date: Tue, 13 Aug 2024 00:39:50 +0530
Message-ID: <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com> (raw)

Hi All

Please let me know if the below option persists while using pg_dump command:

-t table_name --exclude-column column_name

I have a table with a column having bytea data type (BLOBS). I just want to
exclude this in the dump file as it is of 99GB but I want the other data in
the same table which is of only 22MB.

Please let me know any work around this.

I used this option in pg_dump but that didn't work:

--exclude-table-data = table_name

PG version 12.19

Thanks,
Wasim

view thread (17+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pg_dump
  In-Reply-To: <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox