From f7fe9d06275ad6bd153a8d90fd80ef19f3ab23c4 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 7 Oct 2014 18:52:54 +0800 Subject: [PATCH] pgsql/schema_create_table_statement.sql --- pgsql/schema_create_table_statement.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql index 065e4fc0..d43feb43 100644 --- a/pgsql/schema_create_table_statement.sql +++ b/pgsql/schema_create_table_statement.sql @@ -54,15 +54,15 @@ BEGIN ORDER BY a.attnum LOOP IF column_record.attnum = 1 THEN - v_table_ddl:='CREATE TABLE '||column_record.schema_name||'.'||column_record.table_name||' ();'; + v_table_ddl:='CREATE TABLE '||column_record.schema_name||'.'||column_record.table_name||' ();'||chr(10)||chr(10); ELSE - v_table_ddl:= 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' || v_table_ddl||';'; + v_table_ddl:= ''; END IF; -- what does this do? IF column_record.attnum <= column_record.max_attnum THEN - v_table_ddl:=v_table_ddl||chr(10)|| - ' '||column_record.column_name||' '||column_record.column_type||' '||column_record.column_default_value||' '||column_record.column_not_null; + v_table_ddl:= v_table_ddl||chr(10)|| + 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' ||column_record.column_name||' '||column_record.column_type||' '||column_record.column_default_value||' '||column_record.column_not_null; END IF; END LOOP; -- 2.39.2