## postgresql

* 下载链接

* http://www.enterprisedb.com/products-services-training/pgdownload#windows

* pwd:159482673    port:5432    locale:C  

* 将 bin 设置环境变量

* psql –h localhost –p 5432 –U postgres 默认连接

## 创建用户

* createuser.exe -s -P scott -U postgres
* psql –h localhost –p 5432 –U scott
* 修改密码  alter user scott with password '159482673';

## 基本命令

```
    \l   列举数据库
```