使用 Datagrip

配置Live Templates

Settings -> Editor -> Live Templates -> SQL

我的设置

1
2
3
4
5
6
7
sf = select * from
scf = select count(1) from
df = delete from
fu = for update
gp = group by
oy = order by
ii = insert into

Data Extractor

选择导出格式（csv, markdown, sql-insert）导出部分（Ctrl + C）或全部（Dump Data）

Generate POJOs

右键选择表（可多个） -> Scripted Extensions -> Generate POJOs.groovy

纵向显示数据（Transpose a table）

查询结果 -> Show Options Menu -> Transpose

Copy a table to another schema

右键选择表（单选） -> Copy Table to…

Inject a language for a column

Go to the specified row

Ctrl + G