Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Data type for storing attached file - Mailing list pgsql-admin

From Ashish Tiwari
Subject Re: [ADMIN] Data type for storing attached file
Date
Msg-id CAH8UkmHY7b7cZQs4tBf_6jssuCkTyMicxAKCTaE9Yo-zhkwW-Q@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Data type for storing attached file  ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
Responses Re: [ADMIN] Data type for storing attached file  (Bear Giles <bgiles@coyotesong.com>)
List pgsql-admin
Tree view
Hi Ferrell , 

I have encoded the files in base64 and stored binary data in text.this can be stored in bytea too.

Thanks.

On Jul 11, 2017 8:41 PM, "Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil> wrote:
Using PostgreSQL v9.3 on Linux...

What data type would be used to store an attachment (file, could be .txt, .doc, .xls, etc.) into a column?

Thank you in advance,
Denise


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Tiago Dantas
Date:
Subject: Re: [ADMIN] Data type for storing attached file
Next
From: Bear Giles
Date:
Subject: Re: [ADMIN] Data type for storing attached file