How to create a user in PostgreSQL

I had try to use the Windows Version of PostgreSQL. But I found that version of postgresql was not as friendly to users as the Windows Version of MySQL. In my point, maybe the reason why is that PostgreSQL  use something that does work under Linux, but not under Windows. For example, when i use an account which is same as the account i login windows for starting/stoping the PostgreSQL service in the installition, there world be a permission error. And the installision then failed. All would rollbacked. I had to use the default configure to install PostgreSQL in Windows to avoid some unnessesary problem. Anyway, I just wanna learn and use PostgreSQL. It's fine if it can work.

hehe, let's see how to create a user in PostgreSQL. It's easy.
we login the psql, and use this command:
create user andrewleung with createdb password '123456';

now, we have create a user which name 'andrewleung' with the password 123456 and the permission of create database. if we wanna cancel the permission of create database, we can use this command:
alter user andrewleung no createdb;

The complete syntax for the CREATE USER command is

CREATE USER user-name
[[WITH] option ]...

option := SYSID user-id-number
| [NO]CREATEDB
| [NO]CREATEUSER
| IN GROUP groupname [, ...]
| [[UN]ENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'expiration'
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值