hrstt
3/21/2013 - 12:52 PM

Ubuntu にPostgreSQLを用意する ref: http://qiita.com/items/5f40a6aed6b81521b8f7

Ubuntu にPostgreSQLを用意する ref: http://qiita.com/items/5f40a6aed6b81521b8f7

file3.txt
content_copyfile_download
$ psql book -c "SELECT '1'::cube;"
 cube 
------
 (1)
(1 row)
file2.txt
content_copyfile_download
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"
file1.txt
content_copyfile_download
$ sudo su - postgres
$ createdb book
$ psql book -c "SELECT '1'::cube"

ERROR:  type "cube" does not exist
LINE 1: SELECT '1'::cube;
file0.txt
content_copyfile_download
$ sudo apt-get install postgres postgres-client psotgresql-contrib