From: | George Roberge <groberge(at)andforthelamb(dot)org> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Insert image into bytea question |
Date: | 2014-05-01 00:39:12 |
Message-ID: | 1398904752.5570.0.camel@debian |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Greetings, all.
This might be a stupid question, but I have not found one good post or
article on the syntax for inserting an image into a PostgreSQL table
bytea field on the Internet.
I am currently learning version 9.1, which I had read should work pretty
well for inserting and retrieving images in the bytea format, but i
don't know how. I have seen examples of the bytea_import command (which
I couldn't get to work), and other posts that state that the image must
be encoded using a "SELECT encode(XXXX)" statement in the query. I had
originally intended to store the location of the image into a field in
the database and just pull that reference from the table, and was
hopeful when I saw that PostgreSQL can handle storing images directly,
and that it may be even be the preferred method in some cases.
I have been looking online for a couple of hours and have left the Net
about as confused as when I started! I think that some of the reason is
that this appears to be a newer method of doing things, and I have been
reading older information.
Any guidance that anyone can offer would be greatly appreciated.
George R.
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-05-01 01:31:10 | Re: Insert image into bytea question |
Previous Message | Rajmohan C | 2014-04-30 15:34:08 | hooks not working in postgresql 9.3 (building from source) |