Re: Overriding default adapters in psycopg

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>, psycopg(at)lists(dot)postgresql(dot)org
Subject: Re: Overriding default adapters in psycopg
Date: 2025-11-16 17:30:59
Message-ID: f91d116f-2f94-4e74-9ea8-b8cc4792bd86@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: psycopg

On 11/16/25 08:56, Christophe Pettus wrote:
> Hi!
>
> I am attempting to override the default adapters for JSON and JSONB in psycopg (3), but I am not quite sure how to go about it (I'm testing using orjson for serialization and deserialization). This doesn't appear to work:
>

>> class CyanJSONBDumper(Dumper):
>> def dump(self, obj):
>> return orjson.dumps(obj)
>>
>> psycopg.adapters.register_dumper("jsonb", CyanJSONBDumper)

Following:

https://www.psycopg.org/psycopg3/docs/api/abc.html#psycopg.abc.Dumper.dump

I believe it should be something like:

psycopg.adapters.register_dumper(<some_python_object>, CyanJSONBDumper)

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2025-11-16 17:43:06 Re: Overriding default adapters in psycopg
Previous Message Adrian Klaver 2025-11-16 17:25:42 Re: Overriding default adapters in psycopg