<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19597"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=042203408-06112020><FONT color=#000080
size=2 face=Arial>Hi David, </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=042203408-06112020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=042203408-06112020><FONT color=#000080
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=042203408-06112020><FONT color=#000080
size=2 face=Arial>It also is possible to store audio
or other file types </FONT></SPAN><FONT face=Arial><FONT
color=#000080><FONT size=2>a<SPAN class=042203408-06112020>s a blob see e.g. <A
href="https://www.postgresql.org/docs/current/largeobjects.html">https://www.postgresql.org/docs/current/largeobjects.html</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=042203408-06112020></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=042203408-06112020>Cheers</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=042203408-06112020>Karsten</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Shaozhong
SHI<BR><B>Sent:</B> Friday, November 06, 2020 00:31<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> [postgis-users] Can PostgreSQL/PostGIS store and
serve pictures andsounds?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>It is interesting to know the range and types of data
PostgreSQL/PostGIS can store and serve.
<DIV><BR></DIV>
<DIV>We know that it can deal with GIS data.</DIV>
<DIV><BR></DIV>
<DIV>We wonder whether it can be used for general purposes like storing and
serving pictures and sounds?</DIV>
<DIV><BR></DIV>
<DIV>Regards,</DIV>
<DIV><BR></DIV>
<DIV>David</DIV></DIV></BODY></HTML>