1. 首先建一张表
lightdb@postgres=# CREATE TABLE public.act_hi_identitylink (
id_ character varying(64) NOT NULL,
group_id_ character varying(255) NULL,
type_ character varying(255) NULL,
user_id_ character varying(255) NULL,
task_id_ character varying(64) NULL,
proc_inst_id_ character varying(64) NULL
) TABLESPACE pg_default;
CREATE TABLE
2. 通过函数get_ddl来获取ddl建表语句
lightdb@postgres=# select dbms_metadata.get_ddl('table', 'act_hi_identitylink','public');
get_ddl
--------------------------------------------
CREATE TABLE public.act_hi_identitylink (+
id_ character varying(64) NOT NULL, +
group_id_ character varying(255) NULL, +
type_ character varying(255) NULL, +
user_id_ character varying(255) NULL, +
task_id_ character varying(64) NULL, +
proc_inst_id_ character varying(64) NULL+
) TABLESPACE pg_default; +
+
(1 row)
需要说明的是:
该特性不要求当前数据库或实例运行在oracle模式下。
详细语法可参考LightDB官网查看https://www.hs.net/lightdb
更多请登录LightDB官网进行查看:https://www.hs.net/lightdb