[postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

karsten karsten at terragis.net
Fri Nov 6 00:41:51 PST 2020

Hi David, 
it certainly can be used to store pictures . I have for example stored jpeg
pictures taken via an ODK app and then stored in postgres used the data type
bytea for the picture itself.
It also is possible to store audio or other file types as a blob see e.g.


From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Shaozhong SHI
Sent: Friday, November 06, 2020 00:31
To: PostGIS Users Discussion
Subject: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures

It is interesting to know the range and types of data PostgreSQL/PostGIS can
store and serve. 

We know that it can deal with GIS data.

We wonder whether it can be used for general purposes like storing and
serving pictures and sounds?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201106/1a8493ba/attachment.html>

More information about the postgis-users mailing list