import psycopg2

conn = psycopg2.connect(
    host="10.1.0.20",
    port=5433,
    database="hr_portal",
    user="admin",
    password="DC1qaz2wsx"
)
cur = conn.cursor()

cur.execute("""
    SELECT column_name, data_type
    FROM information_schema.columns
    WHERE table_name = 'tenant_emp_resumes'
    ORDER BY ordinal_position;
""")

cols = cur.fetchall()

print("=== tenant_emp_resumes columns ===\n")
for c in cols:
    print(f"  {c[0]}: {c[1]}")

cur.close()
conn.close()
