Create/delete a PostgreSQL database.

Create/delete a PostgreSQL database.
Method 1-system commands
Sudo su-postgres # Switch to postgres user (system user)
Createdb weichen # create a database
Psql # access the database directly (access to the local ipvs database by default)
\ L -- view the Database List
: Q -- exit the list page
\ Q -- exit the client
Dropdb weichen # delete a database

Method 2-psql command line
Sudo-u postgres psql # log on to the client
Create database weichen; -- create a database
Create database sz owner ipvs; -- create a database
Select oid, datname from pg_database; -- view the Database List
Drop database weichen; -- delete a database
Drop database sz; -- delete a database

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.