使用python的postgresql连接

我是数据库新手,已经尝试使用python连接postgresql数据库一段时间了,我甚至尝试改为pgsql,但仍然会出现错误。我试过寻找解决办法,但没有成功。我使用的是windows 10+pgsql 9.5&python 3.6.4。

import psycopg2

conn = psycopg2.connect(database='wildlife', user='postgres', password='P@$$w0rd', host='localhost', port='5432')
print("opened the database successfully")

cur = conn.cursor()

while true:
    with cur.execute('SELECT * FROM CAGE;') as j:
       rows = cur.fetchall()
       for row in rows:
           if item == j:            
               print ("ID = "), row[0]
               print ("NAME = "), row[1]
               print ("LIVES = "), row[2]
               print ("WEIGHT = "), row[3]
               print ("LEGS = "), row[4]
               print ("CLASS = "), row[5]
               print ("NUMBER = "), row[6]
               print ("CATEGORY = "), row[7]

conn.close()

我不知道我错过了什么,也不知道我做错了什么。

Traceback (most recent call last):
  File "c:\Users\ignat\.vscode\extensions\ms-python.python-2018.9.1\pythonFiles\experimental\ptvsd_launcher.py", line 85, in <module>
    import ptvsd
  File "c:\Users\ignat\.vscode\extensions\ms-python.python-2018.9.1\pythonFiles\experimental\ptvsd\ptvsd\__init__.py", line 13, in <module>
    from ._vendored import force_pydevd
  File "c:\Users\ignat\.vscode\extensions\ms-python.python-2018.9.1\pythonFiles\experimental\ptvsd\ptvsd\_vendored\force_pydevd.py", line 20, in <module>
    pydevd_constants = import_module('_pydevd_bundle.pydevd_constants')
  File "E:\LOTUS\python\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "c:\Users\ignat\.vscode\extensions\ms-python.python-2018.9.1\pythonFiles\experimental\ptvsd\ptvsd\_vendored\pydevd\_pydevd_bundle\pydevd_constants.py", line 164, in <module>
    from _pydev_imps._pydev_saved_modules import thread
  File "c:\Users\ignat\.vscode\extensions\ms-python.python-2018.9.1\pythonFiles\experimental\ptvsd\ptvsd\_vendored\pydevd\_pydev_imps\_pydev_saved_modules.py", line 21, in <module>
    import xmlrpc.client as xmlrpclib
  File "E:\LOTUS\python\lib\xmlrpc\client.py", line 135, in <module>
    from decimal import Decimal
  File "E:\LOTUS\python\lib\decimal.py", line 3, in <module>
    from _decimal import *
  File "d:\LOTUS\Documents\my projects\DataCode\numbers.py", line 12
    continue
           ^
SyntaxError: 'continue' not properly in loop

但现在我一次又一次地犯同样的错误。不管我加了什么或改变了什么。帮帮我。