我试图找出为什么我无法使用psycopg2访问PostgreSQL数据库中的特定表。我运行的是PostgreSQL 11.5
如果这样做，我就可以连接到相关数据库并读取其中的所有表：

import psycopg2

try:
connection = psycopg2.connect(user = "postgres",                #psycopg2.connect() creates connection to PostgreSQL database instance
                              password = "battlebot",
                              host = "127.0.0.1",
                              port = "5432",
                              database = "BRE_2019")

cursor = connection.cursor()                                #creates a cursor object which allows us to execute PostgreSQL commands through python source

#Print PostgreSQL version
cursor.execute("""SELECT table_name FROM information_schema.tables
   WHERE table_schema = 'public'""")

for table in cursor.fetchall():
    print(table)

结果如下所示：

('geography_columns',)
('geometry_columns',)
('spatial_ref_sys',)
('raster_columns',)
('raster_overviews',)
('nc_avery_parcels_poly',)
('Zone5e',)
('AllResidential2019',)
#....etc....

我感兴趣的表是最后一个，'AllResidential2019'
因此，我尝试通过执行以下操作连接到它并打印内容：

try:
    connection = psycopg2.connect(user = "postgres",                
    #psycopg2.connect() creates connection to PostgreSQL database instance
                              password = "battlebot",
                              host = "127.0.0.1",
                              port = "5432",
                              database = "BRE_2019")

    cursor = connection.cursor()                                #creates a cursor object which allows us to execute PostgreSQL commands through python source

    cursor.execute("SELECT * FROM AllResidential2019;")           #Executes a database operation or query. Execute method takes SQL query as a parameter. Returns list of result
    record = cursor.fetchall()

    print(record)

except (Exception, psycopg2.Error) as error:
    print("Error while connecting to PostgreSQL: ", error)

我得到了以下错误：

Error while connecting to PostgreSQL:  relation "allresidential2019" does not exist
LINE 1: SELECT * FROM AllResidential2019;

但是，当我尝试连接到另一个数据库中的另一个表时，我可以成功连接并获得结果（这很有效!结果是这个表中的数据）：

try:
    connection = psycopg2.connect(user = "postgres",                #psycopg2.connect() creates connection to PostgreSQL database instance
                              password = "battlebot",
                              host = "127.0.0.1",
                              port = "5432",
                              database = "ClimbingWeatherApp") .  #different database name

    cursor = connection.cursor()                                

    cursor.execute("SELECT * FROM climbing_area_info ;")          
    record = cursor.fetchall()

    print(record)

except (Exception, psycopg2.Error) as error:
    print("Error while connecting to PostgreSQL: ", error)

我不明白为什么我可以使用完全相同的代码从一个表中检索信息，而不能从另一个表中检索信息（除了名称更改）。我也不知道如何解决这个问题。有人能提供建议吗？