如何快速查看表中哪些列有数据？

SELECT 
    COUNT(CASE WHEN column1 IS NOT NULL THEN 1 END) AS column1_not_null,
    COUNT(CASE WHEN column2 IS NOT NULL THEN 1 END) AS column2_not_null,
    -- ... 对于表中的每一列重复上述模式
FROM 
    your_table;

SELECT jsonb_object_keys(your_jsonb_column) FROM your_table WHERE your_jsonb_column IS NOT NULL;

from sqlalchemy import create_engine, inspect

engine = create_engine('your_database_connection_string')
inspector = inspect(engine)

columns_with_data = {}
for table_name in inspector.get_table_names():
    for column in inspector.get_columns(table_name):
        result = engine.execute(f"SELECT COUNT(*) FROM {table_name} WHERE {column['name']} IS NOT NULL")
        count = result.scalar()
        if count > 0:
            columns_with_data.setdefault(table_name, []).append(column['name'])

print(columns_with_data)