Where are all the relations? How to extract connection between ways and nodes?

[zfallahnejad]

I used the osm2pgsql tool to insert the openstreetmap data for france into Postgres. I used their default.style as the style file.

This tool created four tables:

• planet_osm_line: contains all imported ways
• planet_osm_point: contains all imported nodes with tags
• planet_osm_polygon: contains all imported polygons. 
• planet_osm_roads: contains a subset of planet_osm_line suitable for rendering at low zoom levels

I was wondering where are all the relations in these tables. It seems that there are other tables like planet_osm_rels which might include what I want but they are missing here. How can I have this table too? Is there another way to have relations in the tables too?

I also want to know how to extract the connection between ways and nodes. I don't see any connection between the ways in planet_osm_polygon table and the points in planet_osm_point table. How can I have this connection in the generated tables too?

[SomeoneElseOSM]

I was wondering where are all the relations in these tables.

Relations with (multi)polygon geometry will be in planet_osm_polygon.

I don't see any connection between the ways in planet_osm_polygon table and the points in planet_osm_point table. How can I have this connection in the generated tables too?

That rather depends on what you are trying to do. osm2pgsql supports more than one output type, and another might be more appropriate, depending on what you are trying to do. What columns you get, and whether something in the input is treated as an area or a closed line, is also under your control. See e.g. here.