postgresql

以postgres用户 建立book数据库

/Library/PostgreSQL/9.3/bin/createdb -U postgres book

$ /Library/PostgreSQL/9.3/bin/psql -U postgres book

Password for user postgres: 

psql (9.3.2)

Type "help" for help.

book=# create extension cube

book-# ;

CREATE EXTENSION

book=# ^D\q

$ /Library/PostgreSQL/9.3/bin/psql book -c "select '1'::cube;" -U postgres

Password for user postgres: 

 cube 

------

 (1)

(1 row)