Re: pg_dump

Please let me know your inputs.

On Tue, 13 Aug, 2024, 11:52 am Wasim Devale, <wasimd60(at)gmail(dot)com> wrote:

> 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
>>
>>