Re: To take backup of Postgresql Database without large objects - Mailing list pgsql-general

From Christophe Pettus
Subject Re: To take backup of Postgresql Database without large objects
Date
Msg-id 92A90844-8669-477C-90E9-41D619814D8C@thebuild.com
Whole thread Raw
In response to Re: To take backup of Postgresql Database without large objects  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general

> On Apr 11, 2025, at 22:34, sivapostgres@yahoo.com wrote:
> Then I've misunderstood large objects.  Is there document to explain large objects?

Large objects are a relatively old and now little-used feature of PostgreSQL that predates the bytea type:

    https://www.postgresql.org/docs/current/largeobjects.html

As was mentioned, you cannot exclude individual columns with pg_dump; you have to exclude the entire table.


pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: To take backup of Postgresql Database without large objects
Next
From: Adrian Klaver
Date:
Subject: Re: To take backup of Postgresql Database without large objects