Re: Data type for storing attached file

From: Tiago Dantas <tiago(dot)dantas(at)bbd(dot)ca>
To: "Ferrell, Denise D CTR NSWCDD, H11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Data type for storing attached file
Date: 2017-07-11 15:12:45
Message-ID: CAJH7SQTsQfaa0RJ8iESx-UBFOqGO=3SaOiyiSLcfM-sn1acGFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Have you tried *bytea*?
https://www.postgresql.org/docs/9.3/static/datatype-binary.html

On Tue, Jul 11, 2017 at 11:10 AM, 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
>

--
*Tiago Dantas*
Benefits By Design
Database Administration
Phone: 416.824.8779
www.bbd.ca

--

*This email may contain privileged or confidential information intended
solely for the recipient(s) to whom it was addressed. If you received this
message in error we kindly ask you not to copy or distribute it. If you are
not the intended recipient of this message please notify the sender and
delete this and any attachments. If you do not wish to receive further
communications, you can manage your subscriptions (including the option to
unsubscribe) here
<https://docs.google.com/a/bbd.ca/forms/d/e/1FAIpQLSfBnf67-HeiwDiDFwMa3CTQXJLOllYmsvAbkM2cDd23Q_0hHA/viewform>.
If you have questions regarding the authenticity or security of this email,
please do not hesitate to contact us at 1-888-272-0413.*

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ashish Tiwari 2017-07-11 15:31:02 Re: Data type for storing attached file
Previous Message Ferrell, Denise D CTR NSWCDD, H11 2017-07-11 15:10:16 Data type for storing attached file