-- Zuerst Wetterdaten herunterladen:
-- curl http://api.openweathermap.org/data/2.5/weather?q=London,uk -o weather_london.json

CREATE TABLE weather (data json);

\COPY weather FROM 'weather_london.json'

-- alternatively, in psql 9.3 you can actually call curl directly from the COPY command, e.g.:
-- \COPY weather FROM PROGRAMME 'curl http://api.openweathermap.org/data/2.5/weather?q=Vienna'
-- but that will not work from the psql 8.1 client...

SELECT * from weather;

select data->>'name', data->'wind'->>'speed' as windspeed from weather;