修改postgres的默认密码为“password”
su - postgres
$ psql -c "alter user postgres with password 'password'"
创建一个新的用户wibo
$ createuser wibo
$ createdb wibodb -O wibo
登录wibodb数据库
$ psql wibodb
修改wibo用户的密码
wibodb=> alter user wibo with password 'password';
创建表
wibodb=> create table test (no int,name text );
CREATE TABLE
wibodb=> insert into test (no,name) values (1,'devops');
INSERT 0 1
wibodb=> select * from test;
no | name
----+--------
1 | devops
---------------------