Page 1 of 1

How to store an image in postgresQL

Posted: Wed Feb 15, 2017 10:08 pm
by UKMC
Hi altogether,

I have a binary picture into a LC-variable and want to store it in a postgresQL bytea-column.
How should the insert statement look like to make it work ?
All I've found in the net did not work at all

I hope, there is one out there who can help

Best regards in advance

Ulrich

Re: How to store an image in postgresQL

Posted: Wed Feb 15, 2017 10:53 pm
by UKMC
Dear colleagues,

I just found the solution, it's using base64encode() and base64decode()

It works perfect

Best regards


Ulrich