SELECT column_name, data_type 
FROM information_schema.columns 
WHERE table_name = 'e505_lotes_activos' 
AND table_schema = 'public';
