How to save a file in Postgresql database?

Question

PostgreSQL

How to save a file (*.doc,*.png ...) to the database. What type should the cell have and the Sql command itself to save to the database

Answer 1

If the file is small, then you can stuff it into a field like bytea

create table images(id int, image bytea);
insert into images values (1, pg_read_file('/path/to/image.jpg')::bytea);

But keep in mind that during operations with the image field , PostgreSQL will load its contents into memory. So it's better to use BLOB

create table images (id int, image oid); 
insert into images values (1, lo_import('/path/to/image.jpg'));

Answer 2

It is better not to store files in the database at all. Depending on the project, the path to the file can be various relative or absolute links, or data for generating them.

Answer 3

it's better to save the path to the file
and always store the file on the hard disk
. How do you imagine the return of this file in the browser?