postgresql.md 453 Bytes
Newer Older
Scott Sun's avatar
Scott Sun committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
## 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   列举数据库
```