On Mon, 7 Jun 2021, Adrian Klaver wrote:
What Philip is suggesting is to use Python only simple script to connect to
database and retrieve from table. Something like:
import psycopg2
con = psycopg2.connect(<connection_str>)
cur = con.cursor()
cur.execute('select * from activitytypes')
rs = cur.fetchall()
print(rs)
Adrian,
con = psycopg2.connect(bustrac)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 'bustrac' is not defined
That's because there's a problem with connecting to the database. See my
reply to Rob's message.
Thanks,
Rich
