Insert image into postgres database using queries

Question

I am wondering how to insert an image into a postgres database in column of type bytea, do I have to insert from the path of the PGDATA? Thanks

Does this answer your question? Insert an image in postgresql database — Ravi
– Ravi, Commented Jan 29, 2020 at 6:02

Garima Aggarwal · Accepted Answer · 2018-07-04 06:03:29Z

2

One way of doing this is creating a column with bytea datatype and run this query:

insert into table(bytea column) values( bytea('C:\image.jpg'));

This will convert store "C:\image.jpg" into the binary representation, and later image can be retrieved from the folder.

Another efficient way of doing this is to convert the image to base64 string and store that in the database.

answered Jul 4, 2018 at 6:03

Garima Aggarwal

214 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1