import psycopg2

# Database connection parameters
DB_PARAMS = {
    'dbname': 'bookbeach',
    'user': 'postgres',
    'host': 'localhost'
}

def check_companies_columns():
    """Check what columns exist in the companies table"""
    try:
        conn = psycopg2.connect(**DB_PARAMS)
        cursor = conn.cursor()
        
        # Check columns in companies table
        cursor.execute("""
            SELECT column_name, data_type 
            FROM information_schema.columns 
            WHERE table_name = 'companies' 
            ORDER BY ordinal_position
        """)
        columns = cursor.fetchall()
        
        print("Companies table columns:")
        for column_name, data_type in columns:
            print(f"  {column_name} ({data_type})")
        
        cursor.close()
        conn.close()
        
    except Exception as e:
        print(f"Error checking companies columns: {e}")

if __name__ == "__main__":
    check_companies_columns()