Newbie question about blobs and bytea

From: Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Newbie question about blobs and bytea
Date: 2010-02-08 04:51:31
Message-ID: 4B6F9853.4010903@demog.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I have read the stuff on blobs and bytea columns many time in the
past few years , but just do not get it. I have short files, stored on
the operating system as - say - pdf files. Can I store the content of
one of these files in a bytea column? If I do, how do I store and
retrieve the file for display on the screen? If I do this in a bytea
column do I need to escape anything?

Thanks,

Mary Anderson

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-02-08 06:19:49 Re: Incomplete pg_dump operation
Previous Message James Long 2010-02-08 03:14:46 Re: Novice PL/pgSQL question and example