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 ( shishaozh...@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 <kars...@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-boun...@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@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
