Python - AttributeError: 'psycopg2.extensions.connection' object has no attribute 'query'

import psycopg2 as pg

import pandas as pd

from PyQt5.QtSql import QSqlDatabase, QSqlQuery

bd=pg.connect("dbname=municipal user=postgres password = Administra8080")

datos=bd.query('SELECT * FROM usuarios')

if datos.getresult():

  dframe = pd.DataFrame(datos.getresult(), columns=datos.listfields())

  dframe.to_excel('miarchivo.xls',index=False)

import psycopg2

try:

    conn = psycopg2.connect("dbname='template1' user='dbuser' host='localhost' password='dbpass'")

except:

    print "I am unable to connect to the database"

cur = conn.cursor()

cur.execute("""SELECT datname from pg_database""")

rows = cur.fetchall()

for row in rows:

    print "   ", row[0]

   #db connection code

   bd = pg.connect ( "dbname = municipal user = postgres password = Administra8080" )

   Query = "select  * from users"

   cursor = bd.cursor()

   cursor.execute(Query)

   # use fetchall method to fetch all the rows from database table

   records = cursor.fetchall()

   print ("Displaying rows from  table using cursor.fetchall")

   for row in records:

       print (row)