For aspiring database administrators. Create database connection using python's SQLAlchemy.

postgres_connection.py

from sqlalchemy import create_engine

default_query = ("select * from pg_catalog.pg_tables where schemaname !="
"'information_schema' and schemaname != 'pg_catalog'")

def create_engine_custom(username, password=None, host='localhost', db=None):
  password = ':' + password if password else ''
  db = db if db else ''
  engine = create_engine(f'postgresql+psycopg2://{username}{password}@{host}/{db}')
  return engine

  def execute_query_return_rows(query, engine):
    engine.connect()
    result = engine.execute(query)
    return result.fetchall()

    if __name__ == '__main__':
      query = default_query
      print('Use file to change the host.')
      engine = create_engine_custom(username=input("db_username > "),
                    password=input("password > "))
      engine.connect()
      rows = execute_query_return_rows(query, engine)
      tables_name = [row[1] for row in rows]
      print(tables_name)

requirements.txt

SQLAlchemy
psycopg2