Re: Storing large files in multiple schemas: BLOB or BYTEA - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Storing large files in multiple schemas: BLOB or BYTEA
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20886AE29@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Storing large files in multiple schemas: BLOB or BYTEA  (<tigran2-postgres@riatest.com>)
List pgsql-general
tigran2-postgres@riatest.com wrote:
> Is there any other way to store large data in Postgres that allows
streaming and correctly works with
> multiple schemas per database?

Large Objects and bytea are the only ways.

If you want to pg_dump only certain large objects, that won't work
as far as I know (maybe using permissions and a non-superuser can help).

You absolutely need to pg_dump parts of the database regularly?

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: Seref Arikan
Date:
Subject: Re: Suggestions for the best strategy to emulate returning multiple sets of results
Next
From: Merlin Moncure
Date:
Subject: Re: moving from MySQL to pgsql