MIME-Version: 1.0
References: <4c05fd7ddf571bfc82baeede1449f7f0@paolodestefani.it>
In-Reply-To: <4c05fd7ddf571bfc82baeede1449f7f0@paolodestefani.it>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Tue, 5 Oct 2021 14:05:12 +0200
Message-ID: 
 <CA+mi_8YxxD_CYqLySiSwLJZvwSmgaQHHzyQFdtjfevhYqV6JoQ@mail.gmail.com>
Subject: Re: From spycopg2 to psycopg3 data adaptation
To: Paolo De Stefani <paolo@paolodestefani.it>
Cc: Psycopg <psycopg@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bmi_8YxxD_CYqLySiSwLJZvwSmgaQHHzyQFdtjfevhYqV6JoQ%40mail.gmail.com>
Precedence: bulk

On Tue, 5 Oct 2021 at 13:30, Paolo De Stefani <paolo@paolodestefani.it> wrote:

> class TimestamptzQDateTimeLoader(Loader):
>      def load(self, value):
>          if value is None:
>              return None

A `None` will never make it here: you can drop this check in psycopg 3.


> BUT it's not working because the "value" is binary not string:
>
> <memory at 0x000000000939BA00>
>
> So how i can get the same result of psycopg2 in psycopg3 ?

You can use bytes(value) to get the value as bytes string, and if you
need a str you can use bytes(value).decode()

-- Daniele