Horton

Re: Exclude pg_largeobject form pg_dump

Adrian Klaver <adrian.klaver@aklaver.com>

View thread View on postgr.es
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Andreas Joseph Krogh <andreas@visena.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2016-03-08T14:43:37Z
Lists: pgsql-hackers, pgsql-general 
On 03/08/2016 01:53 AM, Andreas Joseph Krogh wrote:
> Hi all.
> Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject
> doesn't work. I've tried to exclude tables using OID-datatype also but
> that didn't work either.

Well pg_largeobject is a system catalog so pretty sure it cannot be 
excluded.

What tables are you trying to exclude with OID?

Do you care about not dumping the pg_largeobject table or not dumping 
the data it contains?

> Thanks.
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas@visena.com <mailto:andreas@visena.com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Commits

  1. Add --no-blobs option to pg_dump