How to create a user in PostgreSQL

最新推荐文章于 2025-08-23 10:14:30 发布

andrewleung

最新推荐文章于 2025-08-23 10:14:30 发布

阅读量852

点赞数

CC 4.0 BY-SA版权

分类专栏： PostgreSQL 文章标签： postgresql user windows command login database

本文链接：https://blog.youkuaiyun.com/andrewleung/article/details/2027235

PostgreSQL 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了在 Windows 环境下使用 PostgreSQL 的一些挑战，并详细解释了如何通过 SQL 命令来创建用户及调整用户的权限设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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'