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 列举数据库