Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVzHu-00DEud-9a for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:37:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tVzHt-0086VW-Qc for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:37:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVzHt-0086VO-En for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:37:53 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVzHq-000nBO-0G for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:37:52 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-2aa179a8791so655304fac.1 for ; Thu, 09 Jan 2025 12:37:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736455068; x=1737059868; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=SnBI6O61QjDc6rsmWDV5ZlPwJSKi/OaZ8fKIzQznO7U=; b=ha1u4RyIDKOaWxJAaE2AwqSI47iEN2DymVc0MZO0DQ98/IPbdYM3vtHdT7HWvVzypt xgvtxUVSkEgjv53RfsB6DWPsg4EY18bCc5koO5dcGL913jwrjQE09Itq1ciCMJiLUI9p T79IDcOi+y2sEhjusiI5GbLDNRO7PFDI/UC8pFGfij1FrvXVFqtwVEAZKRaabK/7f085 UlW9jBH59nrAOE9ppZ+IKt/pk2XD0UhWNLEMi7HZhBqlyXxcpndSr2YyrQjGTNynRsab kPv/agA8xSc79+HKC/M0sRzIjnXJtixYrytNT6oJJBkY8OOqOJVt2ynnuGG+6XK+skAZ XLvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736455068; x=1737059868; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=SnBI6O61QjDc6rsmWDV5ZlPwJSKi/OaZ8fKIzQznO7U=; b=AIDhP4QbpHURl2GO37eRyezyOe6ca+iLBacUxpVUE6aNZUlj0GdFjuT8ZZk3bK7L0k EfmoVKlIx1mmj03Zt3ILxrShcJhAwAPqy0amN4CBsA83yf+IVRHNm81X8JbF4fln+ImX BII5+NC3ndPIzk0G+k2Yvy5jcJKdqJmglgJSKputt7ypZPkID6Whex7nC42+foYtFBEA GvpWamoR8MKHdPwBpEeVGzKHsXVzQY9hZTJn4tZzg3GoZMGExsvrrHF5vUki7cXcKxFz 6D/VGRhobjwx7XIrTpBGS4lMCrE2Kz9Y8cZa3JRMNAkig1o9usjrlrJ3a/uvvDf5PrZo wYeg== X-Gm-Message-State: AOJu0YxODQuKBRIpdtK8Fr3Z4yz0Z6FKZt1c3EAo0cThzzMmGD9WYzer 3um6ceGAZZdF4qRZEKG522xRfWR8NVfZugIx5YJf/x2b9X0vgKXvZqjfWIszvKjiVWCNaVx8rzX ApQ8G+aWaJxGAk2rIqSQbYi6UhNL40wfl X-Gm-Gg: ASbGncuYYlraJuiNFrRKpNZsen65VMu9L4ksicpf2xTUz0c7kndfCMD0HXEDn8zc+R9 tgyOQgZlP/iCe02SYyM638F9yOQb4tLFM5L7hCRE= X-Google-Smtp-Source: AGHT+IEsHGfDVbiwh2V1dhwS0nPHAuWRSW24JaL4OYwXpxhWKEgFM7TeRtkKescr7tLOHOQ4/i57B89HwC6BExKpZQ4= X-Received: by 2002:a05:6871:7882:b0:29d:c764:f873 with SMTP id 586e51a60fabf-2aa0694cdacmr4668141fac.31.1736455068536; Thu, 09 Jan 2025 12:37:48 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Thu, 9 Jan 2025 15:37:37 -0500 X-Gm-Features: AbW1kvb1wVTRyR_sVrNerluAwTpNpUWrQuCDJ77722OTpMb9tJZQG_gY2zqnklc Message-ID: Subject: Re: Display Bytea field To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000875ca4062b4bf337" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000875ca4062b4bf337 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Sure. There's at least one Postgresql driver for PS, and Google says there are 3rd party libraries to display images. It's just a Simple Matter Of Programming! On Thu, Jan 9, 2025 at 3:31=E2=80=AFPM Andy Hartman wrote: > could it be done using Powershell? > > On Thu, Jan 9, 2025 at 3:25=E2=80=AFPM Ron Johnson > wrote: > >> On Thu, Jan 9, 2025 at 3:17=E2=80=AFPM Andy Hartman >> wrote: >> >>> How thru a simple query can I make sure data matches and I can display = it >>> >>> On Thu, Jan 9, 2025 at 3:16=E2=80=AFPM Andy Hartman >>> wrote: >>> >>>> I have migrated over a Table from Mssql that had an Image column I now >>>> have it in Postgres >>>> >>> >> Did SSMS see the column, and then display thousands (or millions) of >> images? >> >> What you're going to need here is a GUI app (that can be a web app) whic= h >> "you" have programmed to know *that column is full of JPEG (or PNG or >> whatever) images*, and so call the relevant decoding library then >> display at the appropriate location in a window. >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000875ca4062b4bf337 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Sure.=C2=A0 There's at least one Postgresql drive= r for PS, and Google says there are 3rd party libraries to display images.<= /div>

It's just a Simple Matter Of Programming!
On Thu, Jan 9, 2025 at 3:31=E2=80=AFPM Andy Hartman <hartman60home@gmail.com> wr= ote:
could it be done using Powershell?=C2=A0

On Thu, Jan 9, 2025 at 3:25= =E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On T= hu, Jan 9, 2025 at 3:17=E2=80=AFPM Andy Hartman <hartman60home@gmail.com> wrote= :
How thru a simple query can I make sure data ma= tches=C2=A0and I can display it

On Thu, Jan 9, 2025 at 3:16=E2=80=AFPM Andy = Hartman <ha= rtman60home@gmail.com> wrote:
I have migrated over a Table from Mss= ql that had an Image column I now have it in Postgres

Did SSMS see the column, and then displ= ay thousands (or millions) of images?=C2=A0

What you're going to need here is a GUI app (that can be = a web app) which "you" have programmed to know that column is = full of JPEG (or PNG or whatever) images, and so call the relevant deco= ding library then display at the appropriate location in a window.

--
Death to <Redacted&g= t;, and butter sauce.
Don't boil me, I'm still alive.
<= div><Redacted> lobster!


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000875ca4062b4bf337--