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 1tVz5H-00DDHj-Aj for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:24:51 +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 1tVz5G-007nJb-1n for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 20:24:49 +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 1tVz5F-007nIX-Ml for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:24:49 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVz5A-000n5A-0G for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 20:24:46 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-2aa17010cbcso550656fac.3 for ; Thu, 09 Jan 2025 12:24:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736454283; x=1737059083; 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=3nGkYbTtIk27Plx9u5kZV+E8mlK1qC/lZK4alv0aGEQ=; b=JQ1XdXBPHHLqWIWqoMFT6/1t9iyiUgrK60lxx4C7lF2YV9Mc5urgeZ8Xc25qbSHET+ rID+QMu0LbcLVFc43T3gKb3cjSGkb5dELhEGeilXE0TDA+Uc3/W3HV08cBAX90/JL17c Xl8uz+U+GY6MRjEacF3fT3FDuTRUrog6dfd2vzjg0kNyqJXqjFDVtfgwCPg9wxxmceNq j3BZmb41IOM3IzjVLuxlqQ+jowZ+LSiKt3fxg0deH3MBJLVAVjCxOFhbFKL8hQNaoYqd giNobybPdOpor+3zK3ndjpu+mYUAubCu2WHyxDYo3UhmQVCm5M7Es2ovOzLFwZqxx43m RLFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736454283; x=1737059083; 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=3nGkYbTtIk27Plx9u5kZV+E8mlK1qC/lZK4alv0aGEQ=; b=iM8PuQgwxUmxr4oKcz1YULhA2KgxOfl3uQTaeej1tAHBIKL3i1YpkMcZD5jmpFVooa U4C1DlRLQ1Q7Qm6klxmQGDjgtr2I/d5F9J2iwAAummaZ0ehntAd6oxQexgo1XU/s8dgx XpvcO6mKqAVwC0Bt3X+LufgXG4HL5e4ONZKfpvJGJyZgrLNRz0vIbm1kYlDeOH++a3WS cXby5LUPmx3hIfWfpIHRN2ecyy/VybFWwHUah638I32OcdJYEUy4xQx72Z/HAMV5HY9O T4vy4lCSsJrKhP2n9QEA+brA8Lc0jXrZ91KubglUmvbSwxgnlLb1vkP5zhbufAgjDwEY DDiQ== X-Gm-Message-State: AOJu0YyCMqktiPTM448lTv8vptCjjtazziXPz5cN+gpk9YC1Xu9FB+TI DVWtGZ1vEnQq59W0iRfeoQqUbk7y39C4qlkwfrYMvO8i21BFFoXnlk5DjZ9tYgfoaB06GXXj/eB lVab9MhuRHMihdH9OAqWGYJ//evOU7A== X-Gm-Gg: ASbGnctKUxAuCytR22HqjuAuzDkenByMi0a9PWUcex6xXxc3IHzT99qHjSw0adhkC4m gkqRrqyyOfOWWb5Rkn6yvBASSbuxE/8O5W6LzmJo= X-Google-Smtp-Source: AGHT+IHnHDJyUh6BT0/Wtrow0ddXScJUhK9QuKfanEfwAPRtlVzVzAkl/CBjLc1IXhwUjjeJdM+7Pr0SOFqwIpv2XjE= X-Received: by 2002:a05:6870:9f12:b0:29f:c5f3:a827 with SMTP id 586e51a60fabf-2aa069e5fd2mr4530454fac.35.1736454283049; Thu, 09 Jan 2025 12:24:43 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Thu, 9 Jan 2025 15:24:32 -0500 X-Gm-Features: AbW1kvbDNiWzoA83aiGfX4rmydTeT-8tHOSRvLpeex9_WSsu-GplyQ9XRBIK3VI Message-ID: Subject: Re: Display Bytea field To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b5c1e8062b4bc44d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b5c1e8062b4bc44d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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) 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. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000b5c1e8062b4bc44d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Jan 9, 2025 at 3:17=E2=80=AFPM An= dy Hartman <hartman60home@gma= il.com> wrote:
How thr= u a simple query can I make sure data matches=C2=A0and I can display it
On T= hu, Jan 9, 2025 at 3:16=E2=80=AFPM Andy Hartman <hartman60home@gmail.com> wrote= :
I have migrated over a Table from Mssql that had an Image column I now h= ave it in Postgres

Did SSMS see the column, and then display thousands (or millions) of image= s?=C2=A0

What you're going= to need here is a GUI app (that can be a web app) which "you" ha= ve programmed to know that column is full of JPEG (or PNG or whatever) i= mages, and so call the relevant decoding library then display at the ap= propriate location in a window.

--
Death to <Redacted>, and butter sauce.
Don't b= oil me, I'm still alive.
<Redacted> lobster!
--000000000000b5c1e8062b4bc44d--