MIME-Version: 1.0
References: 
 <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com>
 <7b149653-4992-9285-d9af-53929497f4e8@jakobs.com>
In-Reply-To: <7b149653-4992-9285-d9af-53929497f4e8@jakobs.com>
From: Wasim Devale <wasimd60@gmail.com>
Date: Tue, 13 Aug 2024 11:52:17 +0530
Message-ID: 
 <CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@mail.gmail.com>
Subject: Re: pg_dump
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000005bcf37061f8aa20d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ%40mail.gmail.com>
Precedence: bulk

--0000000000005bcf37061f8aa20d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=3Dpg_toast.pg_toast_10176226

Thanks,
Wasim

On Tue, 13 Aug, 2024, 12:48=E2=80=AFam Holger Jakobs, <holger@jakobs.com> w=
rote:

> 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 =3D 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 \cop=
y
>
> 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
>
>

--0000000000005bcf37061f8aa20d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">I did one thing, we can exclude the toast table in the pg_du=
mp command that has the BLOBS data for a particular table.</p>
<p dir=3D"ltr">--exclude-table-data=3Dpg_toast.pg_toast_10176226</p>
<p dir=3D"ltr">Thanks,<br>
Wasim</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, 13 Aug, 2024, 12:48=E2=80=AFam Holger Jakobs, &lt;<a href=3D"mailto:holge=
r@jakobs.com">holger@jakobs.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">Am 12.08.24 um 21:09 schrieb Wasim Devale:<br>
&gt; Hi All<br>
&gt;<br>
&gt; Please let me know if the below option persists while using pg_dump <b=
r>
&gt; command:<br>
&gt;<br>
&gt; -t table_name --exclude-column column_name<br>
&gt;<br>
&gt; I have a table with a column having bytea data type (BLOBS). I just <b=
r>
&gt; want to exclude this in the dump file as it is of 99GB but I want the =
<br>
&gt; other data in the same table which is of only 22MB.<br>
&gt;<br>
&gt; Please let me know any work around=C2=A0this.<br>
&gt;<br>
&gt; I used this option in pg_dump but that didn&#39;t work:<br>
&gt;<br>
&gt; --exclude-table-data =3D table_name<br>
&gt;<br>
&gt; PG version 12.19<br>
&gt;<br>
&gt; Thanks,<br>
&gt; Wasim<br>
No, pg_dump can only dump complete tables.<br>
<br>
An alternative would be exporting the result of a select command via <br>
COPY or \copy to a file, which can easily be read again with COPY or \copy<=
br>
<br>
COPY is an SQL command and has to be used by a superuser because it <br>
writes to (or reads from) a file on the server.<br>
\copy is a psql command and thus can only be executed in psql (not any <br>
other client) and by any user, because it writes to (or reads from) a <br>
file on the client computer.<br>
<br>
Kind Regards,<br>
<br>
Holger<br>
<br>
-- <br>
<br>
Holger Jakobs, Bergisch Gladbach<br>
<br>
</blockquote></div>

--0000000000005bcf37061f8aa20d--