Postgres sqlalchemy Session creation with schema name

Question

I can able to create postgres sqlalchemy connection to 'public' schema.

 url = 'postgresql://scott:tiger@localhost:5432/mydatabase'
 engine = create_engine(url)
 engine.connect()
 session = sessionmaker(bind=engine)
 Session = session()

Now try to connect non-public schema say 'myschema'.

 engine = create_engine(url, connect_args={"schema" : "myschema"})
 engine.connect()
 session = sessionmaker(bind=engine)
 Session = session()

I got error :

TypeError: connect() got an unexpected keyword argument 'schema'

How can i connect postgres by using able statements.

Thank you.

This seems really ugly/complex... there's no simpler way to just tell sqlalchemy (don't use public use "foo")? — Adam Hughes
– Adam Hughes, Commented Aug 31, 2020 at 15:52

Hrvoje · Accepted Answer · 2021-04-09 16:14:21Z

1

This is valid connection string for specific schema:

engine = create_engine('postgresql://dbuser:dbpass@localhost:5432/dbname', connect_args={'options': '-csearch_path={}'.format('dbschema')})

answered Apr 9, 2021 at 16:14

Hrvoje

15.4k11 gold badges103 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres sqlalchemy Session creation with schema name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related