public inbox for [email protected]  

help / color / mirror / Atom feed

From: Wasim Devale <[email protected]>
To: Holger Jakobs <[email protected]>
Cc: [email protected]
Subject: Re: pg_dump
Date: Tue, 13 Aug 2024 11:52:17 +0530
Message-ID: <CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com>
	<[email protected]>

I did one thing, we can exclude the toast table in the pg_dump command that
has the BLOBS data for a particular table.

--exclude-table-data=pg_toast.pg_toast_10176226

Thanks,
Wasim

On Tue, 13 Aug, 2024, 12:48 am Holger Jakobs, <[email protected]> wrote:

> Am 12.08.24 um 21:09 schrieb Wasim Devale:
> > 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
> No, pg_dump can only dump complete tables.
>
> An alternative would be exporting the result of a select command via
> COPY or \copy to a file, which can easily be read again with COPY or \copy
>
> COPY is an SQL command and has to be used by a superuser because it
> writes to (or reads from) a file on the server.
> \copy is a psql command and thus can only be executed in psql (not any
> other client) and by any user, because it writes to (or reads from) a
> file on the client computer.
>
> Kind Regards,
>
> Holger
>
> --
>
> Holger Jakobs, Bergisch Gladbach
>
>

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], [email protected]
  Subject: Re: pg_dump
  In-Reply-To: <CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@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