Skip to content

Instantly share code, notes, and snippets.

@iamtekson
Created December 16, 2019 06:24
Show Gist options
  • Save iamtekson/9f79747601c9d8eaa9de792ff79ef6d2 to your computer and use it in GitHub Desktop.
Save iamtekson/9f79747601c9d8eaa9de792ff79ef6d2 to your computer and use it in GitHub Desktop.
# If you want to import the database using earth.sql file, try this command
psql -U postgres -h localhost -p 5432 < earth.sql
# If you want to import the database using earthquake.gz file, try this command
gzip -d -c earthquake.gz| sed -e '/AS integer/d' | psql -U postgres -h localhost -p 5432 -W earthquake
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment