mysql> show tables;
Empty set (0.01 sec)
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> create table ttt(id bigint auto_increment primary key);
Query OK, 0 rows affected (0.02 sec)
mysql> show tables;
+------------------+
| Tables_in_fields |
+------------------+
| ttt |
+------------------+
1 row in set (0.00 sec)
mysql> rollback;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+------------------+
| Tables_in_fields |
+------------------+
| ttt |
+------------------+
1 row in set (0.00 sec)
|
postgres@127:postgres> \dt;
+----------+--------+--------+---------+
| Schema | Name | Type | Owner |
|----------+--------+--------+---------|
+----------+--------+--------+---------+
SELECT 0
Time: 0.018s
postgres@127:postgres> begin
BEGIN
Time: 0.001s
postgres@127:postgres> create table ttt (id int);
CREATE TABLE
Time: 0.018s
postgres@127:postgres> \dt;
+----------+--------+--------+----------+
| Schema | Name | Type | Owner |
|----------+--------+--------+----------|
| public | ttt | table | postgres |
+----------+--------+--------+----------+
SELECT 1
Time: 0.016s
postgres@127:postgres> rollback;
ROLLBACK
Time: 0.001s
postgres@127:postgres> \dt;
+----------+--------+--------+---------+
| Schema | Name | Type | Owner |
|----------+--------+--------+---------|
+----------+--------+--------+---------+
SELECT 0
Time: 0.019s
|