I imported OpenStreetMap data of Karlsruhe to PostGis using osm2pgsql. This creates 4 table, one names planet_osm_roads. Sadly this table does only contains major streets. Smaller streets can be found within planet_osm_line, along with a lot of other stuff such as railways, bicycle tracks...