安装
brew install postgresql
安装了两个依赖包
==> Installing dependencies for postgresql: openssl, readline
开启服务
brew services start postgresql
或者
pg_ctl -D /usr/local/var/postgres start
使用
[keke.zhaokk@zkkMac ~]
$ createdb exampledb
[keke.zhaokk@zkkMac ~]
$ psql exampledb
psql (9.6.1)
Type "help" for help.
exampledb=# create table users(id serial, name varchar(25));
CREATE TABLE
exampledb=# insert into users(name) values('keke');
INSERT 0 1
exampledb=# insert into users(name) values('xiayq');
INSERT 0 1
exampledb=# select * from users;
id | name
----+-------
1 | keke
2 | xiayq
(2 rows)
exampledb=#