upload_data_pg_cloud.sh

psql "sslmode=require host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER password=$PGPASSWORD" -f table_definitions.sql;
psql "sslmode=require host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER password=$PGPASSWORD" -c "\COPY os.open_uprn_white_horse FROM 'data/open_uprn_white_horse.csv' DELIMITER '|' CSV ";  
psql "sslmode=require host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER password=$PGPASSWORD" -c "\COPY os.code_point_open_white_horse FROM 'data/code_point_open_white_horse.csv' DELIMITER '|' CSV ";  
psql "sslmode=require host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER password=$PGPASSWORD" -c "CREATE INDEX uprn_wh_gis ON os.open_uprn_white_horse USING gist(geom);"
psql "sslmode=require host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER password=$PGPASSWORD" -c "CREATE INDEX cp_wh_gis ON os.code_point_open_white_horse USING gist(geom);"