Skip site navigation (1) Skip section navigation (2)

Understanding Binary Data Type

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org>
Subject: Understanding Binary Data Type
Date: 2012-05-22 17:13:12
Message-ID: CAAQLLO5pEuf5ZQYYWY1h9DGkpnZ-30VQEaDX9e=gjVcF4ayHGw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
Hello everyone! I wanted to ask the list a question about the 'bytea'
data type & how I can picture this in my head. I've been reading SQL
for about a few months now and since then, I've only been working with
textual data. Basically I'm familiar with storing text and numerical
characters into tables but my friend told me that databases can hold
much more than just ASCI text. In so I've read up on some pages that
describe the bytea data type:

http://en.wikipedia.org/wiki/Binary_large_object

http://www.postgresql.org/docs/9.1/static/datatype-binary.html

So my question is can and in fact does PostgreSQL and most other RDBMS
have the ability to store large binary files like photos, music, etc
etc into an actual table? I'm guessing the data is dumped into the
table but rather linked or parsed through the file system store path
into the database itself, right? I would just like to know in a basic
round about way how databases store and handle large files like .jpg
or .png files & regardless how relative this term is, how common is it
to use these files or 'bytea' data in tables?

Thanks for any info!

Responses

pgsql-sql by date

Next:From: Ferruccio ZamunerDate: 2012-05-23 09:24:07
Subject: sub query and AS
Previous:From: Jan BakuwelDate: 2012-05-22 07:28:39
Subject: Re: master/detail

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group