# try this first

get_storage(cls="postgresql", db=<psycopg2 connection instance>, objstorage={"cls": "memory"})

# ïf that doesn't work, something like the following should work

swh.storage.postgresql.storage.Storage(db=<psycopg2 connection instance>, objstorage={"cls": "memory"})