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

[Giuseppe Broccolo]

Hi,

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:

                      https://wiki.postgresql.org/wiki/BinaryFilesInDB

Cheers,
Giuseppe.

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

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