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

Giuseppe Broccolo g.broccolo.7 at gmail.com
Fri Nov 6 01:54:04 PST 2020


I'd suggest having a look as well at `bytea` data type, which has been
introduced after blobs. Here an useful link to
understand which is more suitable depending on your use case:



Il giorno ven 6 nov 2020 alle ore 08:57 karsten <karsten at terragis.net> ha

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201106/f694ba0f/attachment.html>

More information about the postgis-users mailing list