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

[p Valdés]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201106/10dda964/attachment.html>