PostgreSQL Database creation/deletion

Method 1-System commands
sudo su-postgres #切换到postgres用户 (System user)
Createdb Weichen #创建数据库
Psql #直接訪问数据库 (default into local postgres database)
\l--View Database list
: Q--Exit list page
\q--Exit client
dropdb Weichen #删除数据库

Method 2-psql Command Line
Sudo-u Postgres Psql #登录client
Create Database Weichen; --Create a database
Create database sz owner Postgres; --Create a database
Select Oid,datname from Pg_database; --View the list of databases
Drop database Weichen; --Delete Database
Drop database sz; --Delete Database

PostgreSQL Database creation/deletion