I’m trying to connect to my PostgreSQL database using SQLAlchemy, but I’m encountering an issue due to my password containing the ‘@’ character. The problem arises because the ‘@’ symbol is also used in the connection string syntax. How can I properly format the connection string to handle this situation? Any help would be greatly appreciated!

%load_ext sql
from sqlalchemy import create_engine
%sql postgresql://postgres:xxxxx@yyyyy@localhost:5432/ABC

this is the error i am getting –

Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname
or an existing connection: dict_keys([])
No module named ‘psycopg2’
Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname
or an existing connection: dict_keys([])

The Database is – ABC
The Password is – xxxx@yyyy (format)

How do i access this database in my jupyter notebook (Python) ?