Подключение Python к БД PostgreSQL и ее отображение

from PyQt5 import QtWidgets
from PyQt5.QtWidgets import QApplication, QMainWindow
from PyQt5.QtSql import QSqlDatabase,QSqlTableModel,QSqlQuery,QSqlQueryModel
import sys
import psycopg2
from config import host, user, password,db_name
 
# connect to database
connection = psycopg2.connect(
    host=host,
    user=user,
    password=password,
    database=db_name
)
 
print("Database opened successfully")
 
 
def application():
    app = QApplication(sys.argv)
    window = QMainWindow()
 
    window.setWindowTitle("Изи СУБД")
    window.setGeometry(400,300, 450,450)
 
    main_text = QtWidgets.QLabel(window)
    main_text.setText("База данных Аэропорт")
    main_text.move(145, 15)
    main_text.adjustSize()
 
    Rbtn = QtWidgets.QPushButton(window)
    Rbtn.move(230, 350)
    Rbtn.setFixedSize(10,45)
    Rbtn.setText("Вперед")
    Rbtn.setFixedWidth(200)
 
    Lbtn = QtWidgets.QPushButton(window)
    Lbtn.move(20, 350)
    Lbtn.setFixedSize(10, 45)
    Lbtn.setText("Назад")
    Lbtn.setFixedWidth(200)
 
    db = QSqlDatabase.addDatabase('PostgreSQL')
 
 
    window.show()
    sys.exit(app.exec_())
 
if __name__=="__main__":
    application()

host = "localhost"
user = "postgres"
password = "123q"
db_name ="BD Aeroport"
port = 5432

import sys
 
from PyQt5.QtCore import Qt
from PyQt5.QtSql import QSqlDatabase, QSqlTableModel
from PyQt5.QtWidgets import (
    QApplication,
    QMainWindow,
    QMessageBox,
    QTableView,
)
 
class DbView(QMainWindow):
    def __init__(self, parent=None):
        super().__init__(parent)
        self.setWindowTitle("QTableView Example")
        # Set up the model
        self.model = QSqlTableModel(self)
        #self.model.setTable("contacts")
        self.model.setEditStrategy(QSqlTableModel.OnFieldChange)
        self.view = QTableView()
        self.view.setModel(self.model)
        self.view.resizeColumnsToContents()
        self.setCentralWidget(self.view)
 
def createConnection():
    con = QSqlDatabase.addDatabase("QSQLITE")
    con.setDatabaseName("contacts.sqlite")
    if not con.open():
        QMessageBox.critical(
            None,
            "QTableView Example - Error!",
            "Database Error: %s" % con.lastError().databaseText(),
        )
        return False
    return True
 
app = QApplication(sys.argv)
if not createConnection():
    sys.exit(1)
win = DbView()
win.show()
sys.exit(app.exec_())

import sys
from PyQt5.QtCore import Qt,pyqtSlot
from PyQt5.QtSql import QSql, QSqlDatabase, QSqlTableModel
from PyQt5.QtWidgets import (
    QApplication,
    QMainWindow,
    QMessageBox,
    QTableView,
)
 
def createConnection(db_name, host='',port=7777, user='',password='', driver="QPSQL"):
    db = QSqlDatabase.addDatabase(driver)
    #print(db.drivers())
    db.setDatabaseName(db_name)
    db.setHostName(host)
    db.setPort(port)
    db.setUserName(user)
    db.setPassword(password)
    if not db.open():
        QMessageBox.critical(None,"Error",db.lastError().text(),)
        return False
    return True
    
class DbView(QMainWindow):
    def __init__(self, parent=None):
        super().__init__(parent)
        menubar = self.menuBar()
        menubar.setNativeMenuBar(False)
        self.mtables = menubar.addMenu("Таблицы")
        self.model = QSqlTableModel(self)
        self.model.setEditStrategy(QSqlTableModel.OnFieldChange)
        view = QTableView()
        view.setModel(self.model)
        view.setSortingEnabled(True)
        view.horizontalHeader().setSectionResizeMode(1)
        view.verticalHeader().setSectionResizeMode(3)
        self.setCentralWidget(view)
        self.add_tables()
        
    def add_tables(self):
        self.mtables.clear()
        for t in self.model.database().tables():
            self.mtables.addAction(t,self.on_tables)
                
    @pyqtSlot()            
    def on_tables(self):
        self.model.setTable(self.sender().text())
        self.model.select()
                
app = QApplication(sys.argv)
if not createConnection('mybase'):
    sys.exit()
w = DbView()
w.show()
sys.exit(app.exec_())