psycopg2更改架构不工作

Question

我正在编写一个简单的python程序来连接和显示来自Postgres表的结果，这是在AWS RDS上。我在公共架构中有表mytest。

connection = psycopg2.connect(dbname='some_test',
                    user='user1',
                    host='localhost',
                    password='userpwd',
                    port=postgres_port)
cursor = connection.cursor()
cursor.execute("SET SEARCH_PATH TO public;")
cursor.execute("SELECT *  FROM mytest;")

但这会引发一个错误

SELECT table_name FROM information_schema.tables

Answer 1

ALTER USER username SET search_path = schema1,schema2;

设置后，查询工作良好！