Re: pg_dump - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_dump
Date
Msg-id CAKFQuwZLpJkxOJzZW6Y8qKiXUkVmLZFRX=jn2LbYarVKzVmRfw@mail.gmail.com
Whole thread Raw
In response to pg_dump  (Wasim Devale <wasimd60@gmail.com>)
List pgsql-admin
On Monday, August 12, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

Please let me know if the below option persists while using pg_dump command:

-t table_name --exclude-column column_name

No, there is no option to dump a partial table, rows or columns.
 

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.

Write your own copy command to export that table’s contents.  See the —snapshot option.

David J.

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: pg_dump
Next
From: Holger Jakobs
Date:
Subject: Re: pg_dump