ai-LiaoWangweb-app/test_db.py

import psycopg2

try:
    conn = psycopg2.connect(
        host='47.109.147.74',
        port=5432,
        user='maas_collect',
        password='jLDMdRjYZyWLJSfr',
        database='maas_collect'
    )
    cur = conn.cursor()
    cur.execute('SELECT current_database(), current_user, current_schema();')
    print('DB info:', cur.fetchone())
    cur.execute("SELECT nspname FROM pg_namespace WHERE nspname = 'public';")
    print('public schema:', cur.fetchone())
    cur.execute("SELECT has_schema_privilege('public', 'CREATE');")
    print('can create:', cur.fetchone())
    conn.close()
except Exception as e:
    print('Error:', e)