pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Packed raster data in postgresql?
3+ messages / 3 participants
[nested] [flat]

* Packed raster data in postgresql?
@ 2023-05-16 15:03 Elstermann, Mike <Mike.Elstermann@itc-halle.de>
  2023-05-16 17:09 ` Re: Packed raster data in postgresql? Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Elstermann, Mike @ 2023-05-16 15:03 UTC (permalink / raw)
  To: 'pgsql-general@lists.postgresql.org' <pgsql-general@lists.postgresql.org>

Hello all,

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

Thanks & best regards mikeE.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Packed raster data in postgresql?
  2023-05-16 15:03 Packed raster data in postgresql? Elstermann, Mike <Mike.Elstermann@itc-halle.de>
@ 2023-05-16 17:09 ` Ron <ronljohnsonjr@gmail.com>
  2023-05-16 17:44   ` Re: Packed raster data in postgresql? Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Ron @ 2023-05-16 17:09 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Packed raster data in postgresql?
  2023-05-16 15:03 Packed raster data in postgresql? Elstermann, Mike <Mike.Elstermann@itc-halle.de>
  2023-05-16 17:09 ` Re: Packed raster data in postgresql? Ron <ronljohnsonjr@gmail.com>
@ 2023-05-16 17:44   ` Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Pavel Stehule @ 2023-05-16 17:44 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-05-16 17:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-16 15:03 Packed raster data in postgresql? Elstermann, Mike <Mike.Elstermann@itc-halle.de>
2023-05-16 17:09 ` Ron <ronljohnsonjr@gmail.com>
2023-05-16 17:44   ` Pavel Stehule <pavel.stehule@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox