Check database connection

check_db.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import psycopg2
import sys

con = psycopg2.connect(host="host",database="database", user="user", password="password")
cursor = con.cursor()
try:
  cursor.execute("""SELECT table_name FROM information_schema.tables""")
  for table in cursor.fetchall():
    print(table)
except psycopg2.DatabaseError as e:
    print('Error %s' % str(e))
    sys.exit(1)
finally:
    if con:
        con.close()