PostgresSql Sql 문법

List roles

In psql
	\\du
or
	select * from pg_roles

Change a user’s password

ALTER ROLE [role_name] WITH PASSWORD '[new_password]';

 

Allow user to create databases

ALTER USER <username> WITH CREATEDB;

List all databases

in psql
	\\l

Create database

on the command line
	sudo -u postgres createdb [name] -O [role_name]
in `psql`
	CREATE DATABASE [name] OWNER [role_name];

Drop database

on the command line
	sudo -u postgres dropdb [name] --if-exists
in `psql`
	DROP DATABASE IF EXISTS [name];