From: | Louis Bertrand <louis(at)bertrandtech(dot)on(dot)ca> |
---|---|
To: | "Mills, Wallace" <MillsW1(at)prose(dot)dpi(dot)qld(dot)gov(dot)au> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Storing Graphic Files |
Date: | 2001-01-15 02:15:44 |
Message-ID: | Pine.BSO.4.20.0101142111080.27667-100000@grendel.bts |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
You can play around with large objects from the command line in psql.
See the \lo_* commands in the psql man page:
http://www.postgresql.org/users-lounge/docs/7.0/user/app-psql.htm
I use them from the PHP interface, and it's quite nice to use:
get your object's OID, open it like you would a file, access it with
the file handle, then close it.
I'm not sure about the other programming interfaces, but I don't expect it
would be much different.
Ciao
--Louis <louis(at)bertrandtech(dot)on(dot)ca>
OpenBSD: Secure by default. http://www.openbsd.org/
On Mon, 15 Jan 2001, Mills, Wallace wrote:
> I am trying to sort out how one can store and retrieve graphic files when
> using Postgresql. From reading the docs and other material I have been able
> to find, it would appear as though to store images they have to be stored as
> Largew Objects. My problem is that I can not get my head around how this is
> accomplished. I would appreciate it if someone could explain in simple terms
> (or even an example) how to accomplish the storing/retrieving of images in
> the database.
> Thanks in advance.
>
> Wallace Mills
>
>
> ********************************DISCLAIMER****************************
> The information contained in the above e-mail message or messages
> (which includes any attachments) is confidential and may be legally
> privileged. It is intended only for the use of the person or entity
> to which it is addressed. If you are not the addressee any form of
> disclosure, copying, modification, distribution or any action taken
> or omitted in reliance on the information is unauthorised. Opinions
> contained in the message(s) do not necessarily reflect the opinions
> of the Queensland Government and its authorities. If you received
> this communication in error, please notify the sender immediately and
> delete it from your computer system network.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-15 02:18:25 | Re: Two novice questions |
Previous Message | Mike Castle | 2001-01-15 02:07:33 | Re: Two novice questions |