From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
---|---|
To: | Holger Jakobs <holger(at)jakobs(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_dump |
Date: | 2024-08-13 06:22:17 |
Message-ID: | CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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, <holger(at)jakobs(dot)com> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wasim Devale | 2024-08-13 06:22:49 | Re: pg_dump |
Previous Message | Harish Harish | 2024-08-13 05:07:36 | Re: Data comparison |