How to connect to specific squema with python3 and postgres?

Asked Nov 05 '18 at 21:08

Active Nov 05 '18 at 21:08

Viewed 166 times

I want to connect to a postgres database in a specific squema using psycopg2. I read this thread but I get a syntax error.

schema = conf['schema']
conn = psycopg2.connect(
    dbname=conf['database'],
    user=conf['user'],
    host=conf['host'],
    password=conf['passw'],
    port=conf['port'],
    options=f'-c search_path={schema}',
)

I checked the config.json where I get the data.

Thanks

asked Nov 05 '18 at 21:08

Aceconhielo

3,316
4
19
26

It might be the comma `,` after `options=f'-c search_path={schema}','` – jalazbe Nov 05 '18 at 21:10
tried before, did't work – Aceconhielo Nov 05 '18 at 21:11
...What is a "squema"? A SQL schema? – Quentin Nov 05 '18 at 21:11
@Q.Holness a postgres schema – Aceconhielo Nov 05 '18 at 21:12
Have you populated the json? Try to do the connection without using it by doing `dbname='mytable', user='myuser' ` just to make sure what it is. – jalazbe Nov 05 '18 at 21:13
@jalazbe tried too. The syntax error is in the line for options=f'......' but I don't where the problem is – Aceconhielo Nov 05 '18 at 21:17
Could you post anonimized information of your `conf['schema']` ? the problem might be ther . – jalazbe Nov 06 '18 at 06:40
can you share more about error? – dwir182 Nov 06 '18 at 07:27

How to connect to specific squema with python3 and postgres?

0 Answers0