Packed raster data in postgresql?

Started by Elstermann, Mikealmost 3 years ago3 messagesgeneral
Jump to latest
#1Elstermann, Mike
Mike.Elstermann@itc-halle.de

Hello all,

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

Thanks & best regards mikeE.

#2Ron
ronljohnsonjr@gmail.com
In reply to: Elstermann, Mike (#1)
Re: Packed raster data in postgresql?

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".

--
Born in Arizona, moved to Babylonia.

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Ron (#2)
Re: Packed raster data in postgresql?

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

Show quoted text

--
Born in Arizona, moved to Babylonia.