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-boun...@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
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
