PG(HGDB)里支持多个sql语句在同一行中间用分号隔开

highgo=# select version();

version

------------------------------------

HighGo Database 3.1.4 Linux 64-bit

(1 row)

Time: 3.981 ms

highgo=# create database testa;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

CREATE DATABASE

Time: 257.170 ms

Time: 0.058 ms

Time: 0.026 ms

Time: 0.023 ms

Time: 0.021 ms

Time: 0.021 ms

Time: 0.021 ms

Time: 0.020 ms

Time: 0.020 ms

Time: 0.021 ms

Time: 0.022 ms

Time: 0.021 ms

Time: 0.021 ms

Time: 0.020 ms

Time: 0.021 ms

Time: 0.020 ms

Time: 0.020 ms

Time: 0.022 ms

Time: 0.022 ms

Time: 0.021 ms

Time: 0.020 ms

Time: 0.413 ms

Time: 0.032 ms

Time: 0.021 ms

Time: 0.019 ms

Time: 0.020 ms

Time: 0.019 ms

Time: 0.019 ms

Time: 0.019 ms

Time: 0.019 ms

Time: 0.019 ms

Time: 0.020 ms

highgo=# drop database testa;

DROP DATABASE

Time: 107.047 ms

highgo=#

highgo=#

highgo=#

highgo=# create database testa;create database testb;

CREATE DATABASE

Time: 259.213 ms

CREATE DATABASE

Time: 243.738 ms

highgo=#

highgo=# drop database testa;

DROP DATABASE

Time: 107.094 ms

highgo=# drop database testb;

DROP DATABASE

Time: 114.084 ms

highgo=# create databa testa;create database testb;

错误: 语法错误 在 "databa" 或附近的 -----前一个语句失败了，后一个还能成功 。

LINE 1: create databa testa;

^

Time: 0.305 ms

CREATE DATABASE

Time: 246.737 ms

postgres9.6@[local]:5432 postgres# select version();

version

---------------------------------------------------------------------------------------------------------

PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit

(1 row)

Time: 2.934 ms

postgres9.6@[local]:5432 postgres# create database testa;create database testb;;;;;;;;;;;;;;;;;;;

CREATE DATABASE

Time: 269.879 ms

CREATE DATABASE

Time: 265.452 ms

Time: 0.034 ms

Time: 0.015 ms

Time: 0.013 ms

Time: 0.014 ms

Time: 0.013 ms

Time: 0.013 ms

Time: 0.014 ms

Time: 0.013 ms

Time: 0.013 ms

Time: 0.031 ms

Time: 0.013 ms

Time: 0.013 ms

Time: 0.012 ms

Time: 0.013 ms

Time: 0.012 ms

Time: 0.013 ms

Time: 0.013 ms

Time: 0.013 ms

postgres9.6@[local]:5432 postgres# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+-------------+----------+-------------+-------------+---------------------------------

postgres | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

template0 | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"postgres9.6" +

| | | | | "postgres9.6"=CTc/"postgres9.6"

template1 | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"postgres9.6" +

| | | | | "postgres9.6"=CTc/"postgres9.6"

test | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

testa | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

testb | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

(6 rows)

Oracle中不支持这种写法：

DB2数据库在toad里也支持这种写法：

DB2在db2命令提示符下执行也不支持多个sql语句在同一行的写法：