Re: Storing large files in multiple schemas: BLOB or BYTEA

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <tigran2-postgres(at)riatest(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA
Date: 2012-10-10 13:33:18
Message-ID: D960CB61B694CF459DCFB4B0128514C20886AE29@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tigran2-postgres(at)riatest(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-10-10 13:46:13 Re: moving from MySQL to pgsql
Previous Message Seref Arikan 2012-10-10 13:27:56 Re: Suggestions for the best strategy to emulate returning multiple sets of results