Skip to content

Instantly share code, notes, and snippets.

@cblanc

cblanc/postcodesio.sh

Created October 22, 2019 10:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cblanc/18fd32d2c8dbb99290ceec7aa8a32836 to your computer and use it in GitHub Desktop.
Save cblanc/18fd32d2c8dbb99290ceec7aa8a32836 to your computer and use it in GitHub Desktop.
Download ZIP
Various commands to run on postcodes.io.db docker container
Raw
postcodesio.sh
# Start docker container
docker run -p 5432:5432 -e POSTGRES_USER=postcodesio -e POSTGRES_DB=postcodesiodb -e POSTGRES_PASSWORD=password idealpostcodes/postcodes.io.db
# Generate postcode list
psql -h 0.0.0.0 -p 5432 --username postcodesio postcodesiodb -t -A -F"," -c "SELECT postcode FROM postcodes ORDER BY postcode" > postcodes.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment