Re: pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump
Date: 2024-08-13 06:33:20
Message-ID: 1170092.1723530800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Wasim Devale <wasimd60(at)gmail(dot)com> writes:
> 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

Utterly pointless. pg_dump does not dump toast tables as such;
it's only concerned with their parent "regular" tables. It will
fetch data from the regular tables, and it's not concerned with
the server-side implementation detail that some of that data
might be coming out of a toast table.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wasim Devale 2024-08-13 06:42:41 Re: pg_dump
Previous Message Wasim Devale 2024-08-13 06:22:49 Re: pg_dump