Skip to content

Instantly share code, notes, and snippets.

@hrstt

hrstt/file0.txt

Created March 21, 2013 12:52
Show Gist options
  • Save hrstt/5212784 to your computer and use it in GitHub Desktop.
Save hrstt/5212784 to your computer and use it in GitHub Desktop.
Download ZIP
Ubuntu にPostgreSQLを用意する ref: http://qiita.com/items/5f40a6aed6b81521b8f7
Raw
file0.txt
$ sudo apt-get install postgres postgres-client psotgresql-contrib
Raw
file1.txt
$ sudo su - postgres
$ createdb book
$ psql book -c "SELECT '1'::cube"
ERROR: type "cube" does not exist
LINE 1: SELECT '1'::cube;
Raw
file2.txt
psql book -c "CREATE EXTENSION tablefunc"
psql book -c "CREATE EXTENSION fuzzystrmatch"
psql book -c "CREATE EXTENSION pg_trgm"
psql book -c "CREATE EXTENSION cube"
psql book -c "CREATE EXTENSION dict_xsyn"
Raw
file3.txt
$ psql book -c "SELECT '1'::cube;"
cube
------
(1)
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment