Thanks for the quick help, Bryan! That solved it.
(Sorry for overlooking that part in the programmer's
guide).
Best regards,
Mary
--- Brian Baquiran <[EMAIL PROTECTED]> wrote:
> Mary Christie Generalao wrote:
> >
> > hi pluggers,
> > I've seen several postgres-related posts before,
> so I
> > presume there are some postgres users here. Can
> you
> > possibly give me an idea how to store binary data
> in a
> > postgres table? I found out postgres doesnt have
> the
> > BLOB data type of oracle. Any hints? As this is
> > off-topic, I'd appreciate responses sent
> privately.
>
> It's more on-topic than a lot of posts.
>
> Postgres can store large objects and refer to them
> via their oid. For
> the SQL interface, there is a function lo_import
> which will take a file
> and import it into the DB. It returns the Oid.
> Clearly you should store
> the Oids in your own tables. There's also a
> lo_export function.
>
> The example from the PG7 documentation is quite
> clear as to how these
> are used:
>
> CREATE TABLE image (
> name text,
> raster oid
> );
>
> INSERT INTO image (name, raster)
> VALUES ('beautiful image',
> lo_import('/etc/motd'));
>
> SELECT lo_export(image.raster, '/tmp/motd') from
> image
> WHERE name = 'beautiful image';
>
> Also, the psql monitor also provides \lo_import,
> \lo_export, \lo_list
> and \lo_unlink. Very useful.
>
> Of course these just use the C API functions
> lo_import(), lo_open() etc.
>
> HTH
> Brian
> _
> Philippine Linux Users Group. Web site and archives
> at http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to
> [EMAIL PROTECTED]
>
> To subscribe to the Linux Newbies' List: send
> "subscribe" in the body to
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
