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

From Tiago Dantas
Subject Re: [ADMIN] Data type for storing attached file
Date
Msg-id CAJH7SQTsQfaa0RJ8iESx-UBFOqGO=3SaOiyiSLcfM-sn1acGFg@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>)
List 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.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



--
Tiago Dantas
Benefits By Design
Database Administration
Phone: 416.824.8779

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. If you have questions regarding the authenticity or security of this email, please do not hesitate to contact us at 1-888-272-0413.

pgsql-admin by date:

Previous
From: "Ferrell, Denise D CTR NSWCDD, H11"
Date:
Subject: [ADMIN] Data type for storing attached file
Next
From: Ashish Tiwari
Date:
Subject: Re: [ADMIN] Data type for storing attached file