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

[karsten]

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.
https://www.postgresql.org/docs/current/largeobjects.html
 
Cheers
Karsten

  _____  

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
andsounds?


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?

Regards,

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