Thread: Data type to store files

Data type to store files

From
Félix Sánchez Rodríguez
Date:
Greetings:
 
I need to use a PostgreSQL Data Base to store different kinds of files, eg: images, videos. So, I'm wondering what data type should I use.
 
Tbanks in advance

Re: Data type to store files

From
Agustin Ignacio Genoves
Date:
I guess you should use Bytea

El día 30 de marzo de 2009 19:01, Félix Sánchez Rodríguez
<fesanch@ciego.cult.cu> escribió:
> Greetings:
>
> I need to use a PostgreSQL Data Base to store different kinds of files, eg:
> images, videos. So, I'm wondering what data type should I use.
>
> Tbanks in advance

Re: Data type to store files

From
Tino Schwarze
Date:
On Tue, Mar 31, 2009 at 08:31:43AM -0300, Agustin Ignacio Genoves wrote:

> I guess you should use Bytea

Or go for large objects.

> > Greetings:
> >
> > I need to use a PostgreSQL Data Base to store different kinds of files, eg:
> > images, videos. So, I'm wondering what data type should I use.
> >
> > Tbanks in advance

HTH,

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de