Postgres Pro
Downloads
Home   >   mailing lists

Thread: Packed raster data in postgresql?

Packed raster data in postgresql?

From
"Elstermann, Mike"
Date:

Hello all,

 

is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) in PostgreSQL?

 

Thanks & best regards mikeE.

Re: Packed raster data in postgresql?

From
Ron
Date:
On 5/16/23 10:03, Elstermann, Mike wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;}span.E-MailFormatvorlage17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}div.WordSection1 {page:WordSection1;}

Hello all,

 

is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) in PostgreSQL?


You can store any binary data you want in columns of type "bytea".

--
Born in Arizona, moved to Babylonia.

Re: Packed raster data in postgresql?

From
Pavel Stehule
Date:
Hi

út 16. 5. 2023 v 19:09 odesílatel Ron <ronljohnsonjr@gmail.com> napsal:
On 5/16/23 10:03, Elstermann, Mike wrote:

Hello all,

 

is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) in PostgreSQL?


You can store any binary data you want in columns of type "bytea".

or you can use some specialized extensions - there is some support in PostGIS or in https://en.wikipedia.org/wiki/Rasdaman

Regards

Pavel
 

--
Born in Arizona, moved to Babylonia.