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 1umTtp-00GNiP-8u for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Aug 2025 09:05:29 +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 1umTtn-004Em5-NY for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Aug 2025 09:05:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1umTtn-004Elx-Bv for pgadmin-hackers@lists.postgresql.org; Thu, 14 Aug 2025 09:05:27 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1umTtk-000Vot-0j for pgadmin-hackers@postgresql.org; Thu, 14 Aug 2025 09:05:26 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-6188b7532f3so1146529a12.2 for ; Thu, 14 Aug 2025 02:05:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1755162323; x=1755767123; darn=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=aYghJ2KSzZ/SytBkfmr8XqoVmbeEYqomvLgYhv9twz8=; b=l7vsyA3a0gPj+R/kKP+XNOR8aVm0REdqYKJJXESA5iJia+xQqRVVaFamXxxPvk2RQU aJUoHsWfqkr82mRCVD2uh4ltzGpLif2RNYKw0lHfun2wR9zpn2EgQgV4ELv+g0BRBn6B IXy/hZ6Z9Y2zzp0wqiAKD32C8pXKSJg1Qwbi+f4BgRxNAiQ0E8i7qD8Q+fsxv7LPg7uD qFq/iLj5rPL6Vzq0wmBbKkmG0BvKNg4TfrLgnGBdP7cp9IWnes0mY/Ih9M3k7RCODTmv l7Uz6rTBG2gIHqX/hIHiLQ1t43/2IOZc+RArnyF7uJa6l2DnJWYWxkm6rEPWxGhEdwcx ko1g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755162323; x=1755767123; 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=aYghJ2KSzZ/SytBkfmr8XqoVmbeEYqomvLgYhv9twz8=; b=ZurVxafsv8cH9yAeQf76E44tNaxeyV/u+aYr4rJi7tnB/tvju4oPa8ZByF0SdX1LSt xYSOiSrGyQyfqfRbjxIXDkhrXEZCdjnRt7AMFjMIKYEh1eziLSLlgEBxLxF5PR41mMXq 8enmkhqiayM/RKQ6HR157/6ocNhhVw6mXBCrYVb68lsfMZs0bLa9MCZ1kztyZO2SPloK vP/E4kJ0g8fhrvz0aMBxFdnd+3daHOxiteW+ndrXDeE+so7Jdkz+BIXcKEpDoueMuQ8h A/rylQNhrQDBkAT0eJLIhz30MgOa7OAoqmceFtu9evwXfPAWVDV0f008y6CNZN3J78WV 8tUA== X-Gm-Message-State: AOJu0YyoLhzCRbxj3x3ohK/5otcQOfE0ItE084szAW8iyL6vSjOyjUEV YCEDFvJsmn19OqAlxbIkwHvAEDNnsARVn6EPsauixJh2VXY8WeJ65tG1ZtHyuKlGZBPj0xUTLvt euHhnrN+Dyx4V+g7EqHd4nljvbACDcGiKzSMbv8ezcQE7g0TiCOamig== X-Gm-Gg: ASbGncso+WLhZ2ggzrtSN51c0ebQaBwR5DtJvkR78AoeWTw2NYNNaglXikrQ0CDmD2y 5PHDTGcoJ/pqUdhn3XyN1YJ1D799bizzs1MOQjf/SF0hWHCRl1Q7/cP3xdBqvxwexO7H29chPi7 huq2ZKL4N//jVeinYk6xh98j0/s1y7UxS3PX+MNtSybyEJACyFNiugAo8dFtg4/XHnBHGq9WGit wzCCuZjVg== X-Google-Smtp-Source: AGHT+IEUOwP4bu8+d4rZNDUvs5qo2UTZymloxViabCgFRxrB1JplZ9fX4PpYzlJEVJemk1Mu4BSx8BOD9rYqbchyaW8= X-Received: by 2002:a05:6402:4409:b0:615:957f:416b with SMTP id 4fb4d7f45d1cf-6188b984762mr2088982a12.6.1755162322726; Thu, 14 Aug 2025 02:05:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Pravesh Sharma Date: Thu, 14 Aug 2025 14:35:10 +0530 X-Gm-Features: Ac12FXzWZTbbxet8-bsxKOnnN6hr0pGuIwisQ8xKknHhxg-5JdV7c3xZ3JtCcdg Message-ID: Subject: Re: Require suggestions on feature 4011 To: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000c516a4063c4f9293" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c516a4063c4f9293 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Hackers, Any suggestions on the above issue. Thanks, Pravesh On Fri, Aug 8, 2025 at 3:41=E2=80=AFPM Pravesh Sharma < pravesh.sharma@enterprisedb.com> wrote: > Hi Hackers, > > I'm working on feature #4011 > , which involves > exporting and importing BLOB (bytea) data. I've checked its feasibility a= nd > these are the challenges I'm facing: > > Currently, we simply return the string "binary data" for bytea columns, > and we don't load the actual binary data at all. If we want to download > this data, we can bring it to the cursor, but when returning it to the > front end, we'll still send the string "binary data" Upon a user's > request to download, we'll fetch it from the cursor and return it. > > The main challenge I'm facing is how we'll identify the row from which th= e > download needs to happen if there's no primary key in the table. > Additionally, keeping binary data in memory could cause performance issue= s. > For this reason, we can make it a preference-based option. > > > Please let me know your thoughts/suggestions. > > > Thanks, > > Pravesh > > -- > > > Pravesh Sharma > > Senior SDE > > +91 9406461406 > > > enterprisedb.com > --000000000000c516a4063c4f9293 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Any suggestions on the abov= e issue.

Thanks,
Pravesh

=
On Fri, Aug 8, 2025 at 3:41=E2=80=AFPM Pravesh Sharma <pravesh.sharma@enterprisedb.c= om> wrote:
Hi Hacker= s,

I'm working on feature #4011, which involves e= xporting and importing BLOB (bytea) data. I've checked its feasibility = and these are the challenges I'm facing:

Currently, we = simply return the string "binary data" for bytea columns, and we = don't load the actual binary data at all. If we want to download this d= ata, we can bring it to the cursor, but when returning it to the front end,= we'll still send the string "binary data" Upon a user= 's request to download, we'll fetch it from the cursor and return i= t.

The main chall= enge I'm facing is how we'll identify the row from which the downlo= ad needs to happen if there's no primary key in the table. Additionally= , keeping binary data in memory could cause performance issues. For this re= ason, we can make it a preference-based option.


Please let me know your thoughts/suggestions= .


<= p style=3D"margin:0px;font-size:13px;line-height:normal;font-family:"H= elvetica Neue";font-size-adjust:none;font-kerning:auto;font-variant-al= ternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;f= ont-variant-east-asian:normal;font-feature-settings:normal">Thanks,

Pravesh

<= div>
--


<= tbody>

Pravesh Shar= ma

Senior SDE

+91 9406461406


<= /p>

enterprisedb.com

--000000000000c516a4063c4f9293--