Skip to content

Instantly share code, notes, and snippets.

@alexanno

alexanno/.sh

Created June 29, 2015 20:32
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 alexanno/a3f5a9afd4e17fcf9761 to your computer and use it in GitHub Desktop.
Save alexanno/a3f5a9afd4e17fcf9761 to your computer and use it in GitHub Desktop.
Download ZIP
Import N50 postgis dump
Raw
.sh
#pgadmin works pretty well
#schema only
pg_restore --host localhost --port 5432 --username "alexanno" --dbname "test" --role "alexanno" --no-password --no-owner --no-privileges --no-tablespaces --schema-only --schema n50 --verbose "/Users/alexanno/Downloads/Kartdata_Norge_UTM33_N50_PostGIS/n50_custom.backup
#data only
pg_restore --host localhost --port 5432 --username "alexanno" --dbname "alexanno" --role "alexanno" --no-password --data-only --schema n50 --verbose "/Users/alexanno/Downloads/Kartdata_Norge_UTM33_N50_PostGIS/n50_custom.backup
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment