Retrieve large objects from file system

From: Vitaly Larchenkov <vitaly(dot)larchenkov(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Retrieve large objects from file system
Date: 2018-11-09 11:49:53
Message-ID: 7AFB0E04-18E6-41FD-9888-88BA02AF7847@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
I need to store pretty large (2-3 Gb) files in database. Is it possible to store column values (my blobs) in directory and access them with sql queries?
I found “file_fdw" but it works with sources that suitable for COPY FROM, but i want to have few regular columns like “date_added”, “version” and “object” which values points to file in directory with objects.

Thanx

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2018-11-09 11:57:16 Re: Retrieve large objects from file system
Previous Message David Rowley 2018-10-29 04:29:43 Re: running a query on a list of tables