Обсуждение: Packed raster data in postgresql?

Поиск
Список
Период
Сортировка

Packed raster data in postgresql?

От
"Elstermann, Mike"
Дата:

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?

От
Ron
Дата:
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?

От
Pavel Stehule
Дата:
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.