openGauss每日一练第3天 | 创建、修改和删除数据库

生活就像一只储蓄罐，你投入的每一分努力，都会在未来的某一天回馈于你。你所要做的，就是别着急、别犹豫，每天多积累一点点。不必羡慕别人现在所拥有的，只要努力，时间都会给你。

今天学习成果检验内容如下：

omm=# CREATE DATABASE tpcc1;
CREATE DATABASE

omm=# CREATE DATABASE tpcc;2;
CREATE DATABASE

omm=# ALTER DATABASE tpcc1 RENAME TO tpcc10;
ALTER DATABASE

omm=# \l tpc10
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
omm | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm +
| | | | | omm=CTc/omm
template1 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm +
| | | | | omm=CTc/omm
tpcc10 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
tpcc2 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(6 rows)

omm=# \l+ tpcc10
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Descripti
on
-----------+-------+----------+-------------+-------------+-------------------+-------+------------+-------------------------
-------------------
omm | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 10 MB | pg_default |
postgres | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 10 MB | pg_default | default administrative c
onnection database
template0 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm +| 10 MB | pg_default | default template for new
databases
| | | | | omm=CTc/omm | | |
template1 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm +| 10 MB | pg_default | unmodifiable empty datab
ase
| | | | | omm=CTc/omm | | |
tpcc10 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 10 MB | pg_default |
tpcc2 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 10 MB | pg_default |
(6 rows)

omm=# \c tpcc2
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "tpcc2" as user "omm".
tpcc2=# CREATE TABLE customer (
tpcc2(# id int,
tpcc2(# name varchar(20)
tpcc2(# );
CREATE TABLE
tpcc2=# \c omm
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "omm".
omm=# DROP DATABASE tpcc10;
DROP DATABASE
omm=# DROP DATABASE tpcc1;^C
omm=# DROP DATABASE tpcc2;
DROP DATABASE