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

[Shaozhong SHI]

Hi, Karsten,

Can PowerPoint or a desktop application load in a picture from PostgreSQL?

Regards,

Shao

On Fri, 6 Nov 2020 at 08:57, karsten <karsten at terragis.net> wrote:

> 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/4ad4ab62/attachment.html>