CREATE OR REPLACE FUNCTION "public"."showcreatetable"("dbinstancename" varchar, "namespace" varchar, "tablename" varchar, "tenantid" varchar)RETURNS "pg_catalog"."varchar" AS$BODY$declaretableScriptcharacter varying default '';
tableNum int2 ;begin
--check db extist
tableNum:= count(*) from pg_class where relname=tablename and relnamespace =(select oid from pg_namespace where nspowner=(select datdba from pg_database where datname=dbinstancename) and nspname =namespace
);IF tableNum=0 then
return '';end if;--columns
tableScript:=tableScript || 'CREATE TABLE IF NOT EXISTS'|| '"sch_'||tenantid||'".'||tablename|| '('||array_to_string(
array(select concat( c1, c2, c3, c4, c5, c6 ) ascolumn_linefrom(select '"'||column_name||'"