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

[Shaozhong SHI]

Any showcases of desktop applications such as Word, Excel, Power Point,
Adobe Illustrator, Graphic packages loading data from PostgreSQL/PostGIS?

Regards,

David

On Fri, 6 Nov 2020 at 12:07, p Valdés <p.valdes334 at gmail.com> wrote:

> see blobs and bytea
>
> https://www.postgresql.org/docs/9.1/datatype-binary.html
>
> El vie., 6 de nov. de 2020 a la(s) 11:42, Shaozhong SHI (
> shishaozhong at gmail.com) escribió:
>
>> 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
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> 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/32818427/attachment.html>