A Preview Without the Heavy Columns

L. wants to preview the log, but the meter charges for every column read — and arrays with nested records are the heaviest. Output every column of events except items and session, without listing the survivors by hand.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

event_id	user_id	event_name	platform	city	event_ts	revenue	is_paid
1	101	app_open	ios	Murmansk	1773479520.000000	NULL	false
2	101	product_view	ios	Murmansk	1773479590.000000	NULL	false
3	101	purchase	ios	Murmansk	1773479740.000000	1290	true

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid