Problem connecting to a PostgreSQL database with Common SQL

Question

I'm working on Lispworks 8.0.1, and using the Common SQL interface provided by the software.

On the other hand I'm working with PostgreSQL and I want to connect a PostgreSQL database in LispWorks.

Here are the lines I use (following the lispworks guidelines) and the Common SQL tutorial:

(load-all-patches)
(require "postgresql")
(sql:initialize-database-type :database-type :postgresql)

The first two lines work perfectly but on the third line I get the following error :

Could not register handle for external module "-lpq" : dlopen(libpq, 0x0005): tried: 'libpq'
(relative path not allowed in hardened program),
'/System/Volumes/Preboot/Cryptexes/OSlibpq' (no such file), '/usr/lib/libpq' (no such file,
not in dyld cache), 'libpq' (relative path not allowed in hardened program), '/usr/lib/libpq'
(no such file, not in dyld cache).

I downloaded libqp through homebrew and also it is well written in the documentation that

For database-type :oracle, :mysql and :postgresql, if the client library is not installed in a standard place, its directory must be added to the environment variable DYLD_LIBRARY_PATH (see the OS manual entry for dyld).

so I configured the DYLD_LIBRARY_PATH in the .bash_profile file

export DYLD_LIBRARY_PATH=${DYLD_LIBRARY_PATH}:/opt/homebrew/Cellar/libpq

It didn't work so I tried with the .zshrc file the following line:

export DYLD_LIBRARY_PATH="/opt/homebrew/Cellar/libpq"

The error is still the same.

So, does anyone have encountered the same problem and/or has an idea how I can solve this?

Thanks