Skip to content

Instantly share code, notes, and snippets.

@spara

spara/createdb.sql

Created July 26, 2012 21:22
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save spara/3184617 to your computer and use it in GitHub Desktop.
Save spara/3184617 to your computer and use it in GitHub Desktop.
Download ZIP
create database
Raw
createdb.sql
# connect to postgres
psql -h localhost
# create database
CREATE DATABASE mydatabase;
# switch to your database
\connect mydatabase
# add postgis extension
CREATE EXTENSION postgis;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment