postgresql 在navicat 中表不显示_Postgresql常用的操作和命令

Postgresql

Linux安装Postgresql

$ sudo pacman -Syu$ sudo pacman -S postgresql$ sudo su postgres[postgres]$ initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'[postgres]$ exit$ sudo systemctl start postgresql$ sudo systemctl stop postgresql

创建用户

CREATE USER [user-name] WITH PASSWORD [password]; # names containing '-' must be quoted by double quotes

授权数据库

ALTER DATABASE [database_name] OWNER TO [user-name];

显示所有的用户

du</