UPDATE t_info_teacher
SET info_teacher_id = workspace_id || '_' || job_no;
ALTER TABLE table_name ALTER COLUMN column_name TYPE datatype;
ALTER TABLE [IF EXISTS] table_name
RENAME TO new_table_name;
| sql | comment |
|---|
| SHOW time zone | 查看数据库时区 |
string_agg(distinct plate_no, ',')
