import psycopg2


def main():

    # ----------- conectar -----------
    conn = None

    try:
      conn = psycopg2.connect("dbname='econexoes' user='postgres' host='localhost' password='eco123'")
    except:
      print("I am unable to connect to the database")

    try:
      cur = conn.cursor()

      cur.execute("select id from endereco")
      enderecos = cur.fetchall()

      for endereco in enderecos:
        cur.execute("select id from cliente where endereco_id = {}".format(endereco[0]))
        clientes = cur.fetchall()

        if len(clientes) > 1:
          print(endereco)

      cur.close()
      conn.close()
    except (Exception, psycopg2.DatabaseError) as error:
      print(error)
print("main")
main()