Re: pg_dump - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump
Date
Msg-id 1170092.1723530800@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: pg_dump
List pgsql-admin
Wasim Devale <wasimd60@gmail.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



pgsql-admin by date:

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