How do I get tables in postgres using psycopg2?

This did the trick for me:

cursor.execute("""SELECT table_name FROM information_schema.tables
       WHERE table_schema="public"""")
for table in cursor.fetchall():
    print(table)