4 ms·
> why would you upload files/store PDFs on a database server!!? I don't really understand this question. You can put data where you like. There are no "databas
by robertlagrant 2y ago
> why would you upload files/store PDFs on a database server!!?
I don't really understand this question. You can put data where you like. There are no "database servers". These aren't whole toys, take them or leave them. They're made of Lego bricks, and so you can change them.
- lmz 2y agoYes, but clients shouldn't be encouraged to refer to server paths. It's unnecessary exposure of details and makes it harder to move things around. Also I wonder if this requires extra permissions. I know COPY from server files requires extra permissions: > COPY naming a file or command is only allowed to database superusers or users who are granted one of the roles pg_read_server_files, pg_write_server_files, or pg_execute_server_program, since it allows reading or writing any file or running a program that the server has privileges to access.
- robertlagrant 2y agoWhat do you mean by clients in this case?