Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyyAn-0007QC-7K for pgsql-general@arkaria.postgresql.org; Tue, 16 May 2023 17:09:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pyyAk-0006Tf-Bo for pgsql-general@arkaria.postgresql.org; Tue, 16 May 2023 17:09:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyyAj-0006TW-Ul for pgsql-general@lists.postgresql.org; Tue, 16 May 2023 17:09:14 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pyyAe-000B5k-EE for pgsql-general@lists.postgresql.org; Tue, 16 May 2023 17:09:13 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-559debdedb5so211769367b3.0 for ; Tue, 16 May 2023 10:09:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684256947; x=1686848947; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=i6hAnljsdwVVhuUpw3aXV2sn+DKxAckGIh0s/N+Zee4=; b=AuHp7PTrEoRpymYB+FyJjd8wCkq0BBn53cGUzUL+25sDDv55j2Aakhh4w1WYHPgA5F hhMy+z6AZfaV8BllKieUV0HoNAYRUk2Rw2wSkpBJylor+adrLDRWb34WnIRC6uXNuRgc G2IoxyoOJTmZMBDPP7spuC+/tFPJ+SMFty32RL/Pr8mYNaHraJ9RgRFjYR9PctcV69gZ eOeIyELCbOVnm7n0CqtWg2orIPIOWppVX0S/7bu56ZQMKqrMEPVmSvidSo2Khevrjq+S 7AJWrPfyUCKG+AD5BkfiedgrKd3CsGgBgdHqmMgxEBzeAYDPBit3uVnB+fYXK1BOdZQW sFaQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684256947; x=1686848947; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=i6hAnljsdwVVhuUpw3aXV2sn+DKxAckGIh0s/N+Zee4=; b=hBaqr13SrQNhBqBnexSwyOZbqLbUBVsnfKO/gXlFHWwWb+fROi4TcopDxzXDw4g1ld z9+NgfovPzHCenBBAKLjSzVpXqzwPx8n8igFKLyMpke7XaCLOyCJ3+nOQRd24+xjkxib 1SqLRugSA1JiDg2JUkjhrKvnwKm0x1VzWFlU1FN1ZJ3cmYmw1D6Uq2Tj7N0+Thiv4vSg jUSOmIxmchf5KigZiabSHLSZxGMZRrofydmVVNLtn+BXmI9fA9HDvd4qasvhpfgZ/5bK S4pODh2gniCsIXu/VtyJywnEWyVxUfILq2rfKeypMYXyXA0fMnZ8bqVvMUbNn2c1lmzH NltA== X-Gm-Message-State: AC+VfDxSuq7Uv5XL/j+9PaO7VKlDgyB+5PUoDAB5ZPMMWfg9P4f/e4AA vVze1G3yF9VSeDOWJA76zwLEKEoea1I= X-Google-Smtp-Source: ACHHUZ7FMdRVpnr2LRZ0OMb5B06nT5JFpQdlDf24HLDIa6ao9+adcCl/KTb+b/mPW7PzpS/FskWJkA== X-Received: by 2002:a81:4f16:0:b0:54f:ba86:9df with SMTP id d22-20020a814f16000000b0054fba8609dfmr34162317ywb.28.1684256947135; Tue, 16 May 2023 10:09:07 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:cc23:f234:2e34:bf3f? ([2600:1700:bd2c:b810:cc23:f234:2e34:bf3f]) by smtp.googlemail.com with ESMTPSA id x79-20020a81a052000000b0055a581c7f03sm11189ywg.29.2023.05.16.10.09.06 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 May 2023 10:09:06 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------xw79XKdVq3yl49lYdEyBkN00" Message-ID: Date: Tue, 16 May 2023 12:09:05 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Packed raster data in postgresql? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------xw79XKdVq3yl49lYdEyBkN00 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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. --------------xw79XKdVq3yl49lYdEyBkN00 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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.
--------------xw79XKdVq3yl49lYdEyBkN00--