Re: Insert image into bytea question - Mailing list pgsql-novice

On 2014-05-01 19:39, David G Johnston wrote:

Ok, very good, thanks to everyone who replied! I was hoping to see a methos within PostgreSQL itself (via INSERT or something), but I can test out a method using PHP instead, since that's the ultimate destination, anyhow.

 

​Not sure how you expected to be able to issue an INSERT w/o some kind of client interface.  If you need to do this via "psql" (i.e. the official PostgreSQL client) there are ways - though I am not that familiar with them.  Typically I'd store the data into a file then do something like:

 

\set variable_name `cat filename.ext`

INSERT INTO tbl (col) VALUES (func_if_needed(:'variable_name'));

 

In which case you might or might not find it easier to use some text intermediary in order to avoid difficulty with "cat".

 

However, I assumed you were using something like PHP or Java and that you would most likely want to have any solution be within the same framework...

 

​David J.

---

View this message in context: Re: Insert image into bytea question
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

I was going to test the table using exactly that.  Since I'm still relatively fresh into PostgreSQL and rusty with my web coding (and PHP), I wanted to make sure that I was going to insert data properly into the table the "easy way" before I started writing code to do it using a web interface.  After looking into it and finding next to no documentation (syntax examples), it may be that it's better to "just do it" with PHP to start.

George R.