osm.public contains 267 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
planet_osm_line	access	text	2147483647	√		null
planet_osm_point	access	text	2147483647	√		null
planet_osm_polygon	access	text	2147483647	√		null
planet_osm_roads	access	text	2147483647	√		null
planet_osm_line	addr:flats	text	2147483647	√		null
planet_osm_point	addr:flats	text	2147483647	√		null
planet_osm_polygon	addr:flats	text	2147483647	√		null
planet_osm_roads	addr:flats	text	2147483647	√		null
planet_osm_line	addr:housenumber	text	2147483647	√		null
planet_osm_point	addr:housenumber	text	2147483647	√		null
planet_osm_polygon	addr:housenumber	text	2147483647	√		null
planet_osm_roads	addr:housenumber	text	2147483647	√		null
planet_osm_line	addr:interpolation	text	2147483647	√		null
planet_osm_point	addr:interpolation	text	2147483647	√		null
planet_osm_polygon	addr:interpolation	text	2147483647	√		null
planet_osm_roads	addr:interpolation	text	2147483647	√		null
planet_osm_line	admin_level	text	2147483647	√		null
planet_osm_point	admin_level	text	2147483647	√		null
planet_osm_polygon	admin_level	text	2147483647	√		null
planet_osm_roads	admin_level	text	2147483647	√		null
planet_osm_line	aerialway	text	2147483647	√		null
planet_osm_point	aerialway	text	2147483647	√		null
planet_osm_polygon	aerialway	text	2147483647	√		null
planet_osm_roads	aerialway	text	2147483647	√		null
planet_osm_line	aeroway	text	2147483647	√		null
planet_osm_point	aeroway	text	2147483647	√		null
planet_osm_polygon	aeroway	text	2147483647	√		null
planet_osm_roads	aeroway	text	2147483647	√		null
planet_osm_line	amenity	text	2147483647	√		null
planet_osm_point	amenity	text	2147483647	√		null
planet_osm_polygon	amenity	text	2147483647	√		null
planet_osm_roads	amenity	text	2147483647	√		null
planet_osm_line	area	text	2147483647	√		null
planet_osm_point	area	text	2147483647	√		null
planet_osm_polygon	area	text	2147483647	√		null
planet_osm_roads	area	text	2147483647	√		null
spatial_ref_sys	auth_name	varchar	256	√		null
spatial_ref_sys	auth_srid	int4	10	√		null
planet_osm_line	barrier	text	2147483647	√		null
planet_osm_point	barrier	text	2147483647	√		null
planet_osm_polygon	barrier	text	2147483647	√		null
planet_osm_roads	barrier	text	2147483647	√		null
planet_osm_line	bicycle	text	2147483647	√		null
planet_osm_point	bicycle	text	2147483647	√		null
planet_osm_polygon	bicycle	text	2147483647	√		null
planet_osm_roads	bicycle	text	2147483647	√		null
planet_osm_line	boundary	text	2147483647	√		null
planet_osm_point	boundary	text	2147483647	√		null
planet_osm_polygon	boundary	text	2147483647	√		null
planet_osm_roads	boundary	text	2147483647	√		null
planet_osm_line	bridge	text	2147483647	√		null
planet_osm_point	bridge	text	2147483647	√		null
planet_osm_polygon	bridge	text	2147483647	√		null
planet_osm_roads	bridge	text	2147483647	√		null
planet_osm_line	building	text	2147483647	√		null
planet_osm_point	building	text	2147483647	√		null
planet_osm_polygon	building	text	2147483647	√		null
planet_osm_roads	building	text	2147483647	√		null
planet_osm_point	capital	text	2147483647	√		null
planet_osm_line	construction	text	2147483647	√		null
planet_osm_point	construction	text	2147483647	√		null
planet_osm_polygon	construction	text	2147483647	√		null
planet_osm_roads	construction	text	2147483647	√		null
geography_columns	coord_dimension	int4	10	√		null
planet_osm_line	cutting	text	2147483647	√		null
planet_osm_point	cutting	text	2147483647	√		null
planet_osm_polygon	cutting	text	2147483647	√		null
planet_osm_roads	cutting	text	2147483647	√		null
planet_osm_line	disused	text	2147483647	√		null
planet_osm_point	disused	text	2147483647	√		null
planet_osm_polygon	disused	text	2147483647	√		null
planet_osm_roads	disused	text	2147483647	√		null
planet_osm_point	ele	text	2147483647	√		null
planet_osm_line	embankment	text	2147483647	√		null
planet_osm_point	embankment	text	2147483647	√		null
planet_osm_polygon	embankment	text	2147483647	√		null
planet_osm_roads	embankment	text	2147483647	√		null
geography_columns	f_geography_column	name	2147483647	√		null
geography_columns	f_table_catalog	name	2147483647	√		null
geography_columns	f_table_name	name	2147483647	√		null
geography_columns	f_table_schema	name	2147483647	√		null
planet_osm_line	foot	text	2147483647	√		null
planet_osm_point	foot	text	2147483647	√		null
planet_osm_polygon	foot	text	2147483647	√		null
planet_osm_roads	foot	text	2147483647	√		null
planet_osm_line	highway	text	2147483647	√		null
planet_osm_point	highway	text	2147483647	√		null
planet_osm_polygon	highway	text	2147483647	√		null
planet_osm_polygon_view	highway	text	2147483647	√		null
planet_osm_roads	highway	text	2147483647	√		null
planet_osm_line	historic	text	2147483647	√		null
planet_osm_point	historic	text	2147483647	√		null
planet_osm_polygon	historic	text	2147483647	√		null
planet_osm_roads	historic	text	2147483647	√		null
planet_osm_line	horse	text	2147483647	√		null
planet_osm_point	horse	text	2147483647	√		null
planet_osm_polygon	horse	text	2147483647	√		null
planet_osm_roads	horse	text	2147483647	√		null
planet_osm_line	junction	text	2147483647	√		null
planet_osm_point	junction	text	2147483647	√		null
planet_osm_polygon	junction	text	2147483647	√		null
planet_osm_roads	junction	text	2147483647	√		null
planet_osm_line	landuse	text	2147483647	√		null
planet_osm_point	landuse	text	2147483647	√		null
planet_osm_polygon	landuse	text	2147483647	√		null
planet_osm_polygon_view	landuse	text	2147483647	√		null
planet_osm_roads	landuse	text	2147483647	√		null
planet_osm_line	layer	text	2147483647	√		null
planet_osm_point	layer	text	2147483647	√		null
planet_osm_polygon	layer	text	2147483647	√		null
planet_osm_roads	layer	text	2147483647	√		null
planet_osm_line	learning	text	2147483647	√		null
planet_osm_point	learning	text	2147483647	√		null
planet_osm_polygon	learning	text	2147483647	√		null
planet_osm_roads	learning	text	2147483647	√		null
planet_osm_line	leisure	text	2147483647	√		null
planet_osm_point	leisure	text	2147483647	√		null
planet_osm_polygon	leisure	text	2147483647	√		null
planet_osm_roads	leisure	text	2147483647	√		null
planet_osm_line	lock	text	2147483647	√		null
planet_osm_point	lock	text	2147483647	√		null
planet_osm_polygon	lock	text	2147483647	√		null
planet_osm_roads	lock	text	2147483647	√		null
planet_osm_line	man_made	text	2147483647	√		null
planet_osm_point	man_made	text	2147483647	√		null
planet_osm_polygon	man_made	text	2147483647	√		null
planet_osm_roads	man_made	text	2147483647	√		null
planet_osm_rels	members	_text	2147483647	√		null
planet_osm_line	military	text	2147483647	√		null
planet_osm_point	military	text	2147483647	√		null
planet_osm_polygon	military	text	2147483647	√		null
planet_osm_roads	military	text	2147483647	√		null
planet_osm_line	motorcar	text	2147483647	√		null
planet_osm_point	motorcar	text	2147483647	√		null
planet_osm_polygon	motorcar	text	2147483647	√		null
planet_osm_roads	motorcar	text	2147483647	√		null
planet_osm_line	name	text	2147483647	√		null
planet_osm_point	name	text	2147483647	√		null
planet_osm_polygon	name	text	2147483647	√		null
planet_osm_polygon_view	name	text	2147483647	√		null
planet_osm_roads	name	text	2147483647	√		null
planet_osm_line	natural	text	2147483647	√		null
planet_osm_point	natural	text	2147483647	√		null
planet_osm_polygon	natural	text	2147483647	√		null
planet_osm_roads	natural	text	2147483647	√		null
planet_osm_polygon_view	nature	text	2147483647	√		null
planet_osm_line	oneway	text	2147483647	√		null
planet_osm_point	oneway	text	2147483647	√		null
planet_osm_polygon	oneway	text	2147483647	√		null
planet_osm_roads	oneway	text	2147483647	√		null
planet_osm_line	operator	text	2147483647	√		null
planet_osm_point	operator	text	2147483647	√		null
planet_osm_polygon	operator	text	2147483647	√		null
planet_osm_roads	operator	text	2147483647	√		null
planet_osm_line	osm_id	int4	10	√		null
planet_osm_point	osm_id	int4	10	√		null
planet_osm_polygon	osm_id	int4	10	√		null
planet_osm_polygon_view	osm_id	int4	10	√		null
planet_osm_roads	osm_id	int4	10	√		null
planet_osm_rels	parts	_int4	10	√		null
planet_osm_line	place	text	2147483647	√		null
planet_osm_point	place	text	2147483647	√		null
planet_osm_polygon	place	text	2147483647	√		null
planet_osm_roads	place	text	2147483647	√		null
planet_osm_point	poi	text	2147483647	√		null
planet_osm_line	power	text	2147483647	√		null
planet_osm_point	power	text	2147483647	√		null
planet_osm_polygon	power	text	2147483647	√		null
planet_osm_roads	power	text	2147483647	√		null
planet_osm_line	power_source	text	2147483647	√		null
planet_osm_point	power_source	text	2147483647	√		null
planet_osm_polygon	power_source	text	2147483647	√		null
planet_osm_roads	power_source	text	2147483647	√		null
planet_osm_line	priority	int4	10	√		null
spatial_ref_sys	proj4text	varchar	2048	√		null
planet_osm_line	railway	text	2147483647	√		null
planet_osm_point	railway	text	2147483647	√		null
planet_osm_polygon	railway	text	2147483647	√		null
planet_osm_roads	railway	text	2147483647	√		null
planet_osm_line	ref	text	2147483647	√		null
planet_osm_point	ref	text	2147483647	√		null
planet_osm_polygon	ref	text	2147483647	√		null
planet_osm_roads	ref	text	2147483647	√		null
planet_osm_rels	rel_off	int2	5	√		null
planet_osm_line	religion	text	2147483647	√		null
planet_osm_point	religion	text	2147483647	√		null
planet_osm_polygon	religion	text	2147483647	√		null
planet_osm_roads	religion	text	2147483647	√		null
planet_osm_line	residence	text	2147483647	√		null
planet_osm_point	residence	text	2147483647	√		null
planet_osm_polygon	residence	text	2147483647	√		null
planet_osm_roads	residence	text	2147483647	√		null
planet_osm_line	route	text	2147483647	√		null
planet_osm_point	route	text	2147483647	√		null
planet_osm_polygon	route	text	2147483647	√		null
planet_osm_roads	route	text	2147483647	√		null
planet_osm_line	service	text	2147483647	√		null
planet_osm_point	service	text	2147483647	√		null
planet_osm_polygon	service	text	2147483647	√		null
planet_osm_roads	service	text	2147483647	√		null
planet_osm_line	shop	text	2147483647	√		null
planet_osm_point	shop	text	2147483647	√		null
planet_osm_polygon	shop	text	2147483647	√		null
planet_osm_roads	shop	text	2147483647	√		null
planet_osm_line	sport	text	2147483647	√		null
planet_osm_point	sport	text	2147483647	√		null
planet_osm_polygon	sport	text	2147483647	√		null
planet_osm_roads	sport	text	2147483647	√		null
geography_columns	srid	int4	10	√		null
spatial_ref_sys	srtext	varchar	2048	√		null
planet_osm_nodes	tags	_text	2147483647	√		null
planet_osm_rels	tags	_text	2147483647	√		null
planet_osm_ways	tags	_text	2147483647	√		null
planet_osm_line	tourism	text	2147483647	√		null
planet_osm_point	tourism	text	2147483647	√		null
planet_osm_polygon	tourism	text	2147483647	√		null
planet_osm_roads	tourism	text	2147483647	√		null
planet_osm_line	tracktype	text	2147483647	√		null
planet_osm_polygon	tracktype	text	2147483647	√		null
planet_osm_roads	tracktype	text	2147483647	√		null
planet_osm_line	tunnel	text	2147483647	√		null
planet_osm_point	tunnel	text	2147483647	√		null
planet_osm_polygon	tunnel	text	2147483647	√		null
planet_osm_roads	tunnel	text	2147483647	√		null
geography_columns	type	text	2147483647	√		null
planet_osm_line	waterway	text	2147483647	√		null
planet_osm_point	waterway	text	2147483647	√		null
planet_osm_polygon	waterway	text	2147483647	√		null
planet_osm_polygon_view	waterway	text	2147483647	√		null
planet_osm_roads	waterway	text	2147483647	√		null
planet_osm_line	way	geometry	2147483647	√		null
planet_osm_point	way	geometry	2147483647	√		null
planet_osm_polygon	way	geometry	2147483647	√		null
planet_osm_polygon_view	way	geometry	2147483647	√		null
planet_osm_roads	way	geometry	2147483647	√		null
planet_osm_line	way_area	float4	8,8	√		null
planet_osm_polygon	way_area	float4	8,8	√		null
planet_osm_roads	way_area	float4	8,8	√		null
planet_osm_rels	way_off	int2	5	√		null
planet_osm_line	width	text	2147483647	√		null
planet_osm_point	width	text	2147483647	√		null
planet_osm_polygon	width	text	2147483647	√		null
planet_osm_roads	width	text	2147483647	√		null
planet_osm_line	wood	text	2147483647	√		null
planet_osm_point	wood	text	2147483647	√		null
planet_osm_polygon	wood	text	2147483647	√		null
planet_osm_roads	wood	text	2147483647	√		null
planet_osm_line	z_order	int4	10	√		null
planet_osm_point	z_order	int4	10	√		null
planet_osm_polygon	z_order	int4	10	√		null
planet_osm_roads	z_order	int4	10	√		null
geometry_columns	coord_dimension	int4	10
geometry_columns	f_geometry_column	varchar	256
geometry_columns	f_table_catalog	varchar	256
geometry_columns	f_table_name	varchar	256
geometry_columns	f_table_schema	varchar	256
planet_osm_nodes	id	int4	10
planet_osm_rels	id	int4	10
planet_osm_ways	id	int4	10
planet_osm_nodes	lat	int4	10
planet_osm_nodes	lon	int4	10
planet_osm_ways	nodes	_int4	10
planet_osm_rels	pending	bool	1
planet_osm_ways	pending	bool	1
geometry_columns	srid	int4	10
spatial_ref_sys	srid	int4	10
geometry_columns	type	varchar	30