pg_dump

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump
Date: 2024-08-12 19:09:50
Message-ID: CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

  • Re: pg_dump at 2024-08-12 19:16:17 from David G. Johnston
  • Re: pg_dump at 2024-08-12 19:18:41 from Holger Jakobs

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-08-12 19:16:17 Re: pg_dump
Previous Message Rui DeSousa 2024-08-12 17:55:47 Re: Pg_repack