Re: Data type for storing attached file

From: Ashish Tiwari <tashish786(at)gmail(dot)com>
To: "Ferrell, Denise D CTR NSWCDD, H11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Data type for storing attached file
Date: 2017-07-11 15:31:02
Message-ID: CAH8UkmHY7b7cZQs4tBf_6jssuCkTyMicxAKCTaE9Yo-zhkwW-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)ferrell(dot)ctr(at)navy(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bear Giles 2017-07-11 18:01:40 Re: Data type for storing attached file
Previous Message Tiago Dantas 2017-07-11 15:12:45 Re: Data type for storing attached file