Skip to content

Instantly share code, notes, and snippets.

@roniemicro
Created August 19, 2014 08:51
Show Gist options
  • Select an option

  • Save roniemicro/5445d0b5c220816a51dc to your computer and use it in GitHub Desktop.

Select an option

Save roniemicro/5445d0b5c220816a51dc to your computer and use it in GitHub Desktop.
CREATE TABLE locations (
geo_code text PRIMARY KEY,
district_id text,
district_name text,
division_id text,
division_name text,
pourashava_id text,
pourashava_name text,
union_id text,
union_name text,
upazilla_id text,
upazilla_name text
);
COPY locations (geo_code, division_id, division_name, district_id, district_name, upazilla_id, upazilla_name, pourashava_id, pourashava_name, union_id, union_name) FROM 'dummy-locations.csv';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment