wangjiaji

-- Schema and import for Yahoo GeoPlanet data into a PostgreSQL database.

CREATE TABLE places (
    woe_id VARCHAR(15) PRIMARY KEY,
    iso VARCHAR(6),
    name TEXT,
    language VARCHAR(6),
    place_type VARCHAR(15),
    parent_woe_id VARCHAR(15)
);