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 1tVzBi-00DE6X-JH for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:31:31 +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 1tVzBg-007umj-Vj for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:31:28 +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 1tVzBg-007ulw-J5 for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:31:28 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVzBd-000n7r-17 for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:31:27 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-e549dd7201cso2353141276.0 for ; Thu, 09 Jan 2025 12:31:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736454684; x=1737059484; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=OKPiGktCUE95ZBQhVhe0vYD15pxHFNrFcuYfpcneF+c=; b=RuiG3thSWTL0X43IcTgHSU3VWCtY3HfwDkF3h6RLmD8Qqd6wQ5AJfalWwPtBuOPQ7l /Q0jyRcMulxzVFvMl5e07vFOVwY+wwn5Wl6BCEKYxDlm8QO0cSmQclbu2idWMBhlmXIu akA3CzZOm525JbvgifnKJfjRQsAt+OARjqgwp5O527UiB81O96Qw2QJHpbrQIoSG+/KO UiEJJxwz9el9bWimrc5j3FoVc68ZpZ4cW9PW/H/rHwXgEXS/wC+fOjpOezufFHaE3Zlm Cj+w3w0/+mjlOkXcJ62z+DrLWhvtyjYz5p52THYvBEll79cO6Z7VKi4tn0JoM5xlB5f3 SDMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736454684; x=1737059484; h=cc: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=OKPiGktCUE95ZBQhVhe0vYD15pxHFNrFcuYfpcneF+c=; b=NlPjwkrTC7oVjvu6YmJKdH01VY/Nb/0nO6klwgjhU/f/TmzgJBIXo49NkDuUPkdPkF BDmKJvtCcyDoQRGqU+8A6OlLCD5ZOfOwN8wgIZKOU9Z0glhKiAXuZcjhm1eeNEFtidiY gnQkTsSiC9N1A37ENxHUtwkmHOQ+qSmexxB+qkO07OgO5tNQPoLlz5liKsdI2io4htZo g1i8l+i9C1LMDHtMYQUuXaB2L24JhR+IAknQJxwRlQ5cD2WSd7sIIvCbgbwiHnahlG01 82N9jxa2ZC/XuIUBFlPh9QhYojKTgjpNaPmYG4JgEUy23u4NAToNR9HhDzFZojMfYPHr 6MRw== X-Gm-Message-State: AOJu0YxeC6wUdQOskKIuOl6m6Ze5FXaDmvN/FiMwzBF3bQ9/99HWgGPM QnU91wrsGvvF79WUXn0tsxXSZc0Dq5u7axY7tSToefrTEb/VhVDRnAuOx+Jm/zD8QT12C92SZTY YopNpu2K9SF33HSAa8xDU8b9u2Z0= X-Gm-Gg: ASbGncujwTv+4gdHqGuA79vocdYopH/Hg3xBnIyY9qDaA9uEbVjPPCeBwvNOzFYWZzh b4IjXKx5z9Tba/bnqlAcEPjwe4vNqtzCrtmU9 X-Google-Smtp-Source: AGHT+IHKj+cEr+KwxSxW+KeDINQapaRnsFwEiWyErWjIP2lZAaFNNr8hDYFwVE8NUBwmekPZAzmQ5tptiltgqVibio0= X-Received: by 2002:a05:6902:150e:b0:e4a:3170:1e90 with SMTP id 3f1490d57ef6-e54edf48296mr6910417276.12.1736454683967; Thu, 09 Jan 2025 12:31:23 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Andy Hartman Date: Thu, 9 Jan 2025 15:31:13 -0500 X-Gm-Features: AbW1kvZVLbfJGT7Ub2ibPNGVKZfO_0ITHjoVOSH6M-U473dI2-4K3KxlRZlzSXQ Message-ID: Subject: Re: Display Bytea field To: Ron Johnson Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000009b4aa0062b4bdcae" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009b4aa0062b4bdcae Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 i= t >> >> 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) which > "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! > --0000000000009b4aa0062b4bdcae Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 Thu, Jan 9, 2025 at 3:17=E2=80=AFPM Andy Hartman <hartman60home@gmail.com<= /a>> wrote:

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

Did SSMS see the column, an= d then display 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 tha= t column is full of JPEG (or PNG or whatever) images, and so call the r= elevant decoding library then display at the appropriate location in a wind= ow.

--
Death to <= Redacted>, and butter sauce.
Don't boil me, I'm still alive.=
<Redacted> lobster!
--0000000000009b4aa0062b4bdcae--