pgsql/schema_create_table_statement.sql
authorAlan Knowles <alan@roojs.com>
Tue, 7 Oct 2014 10:49:23 +0000 (18:49 +0800)
committerAlan Knowles <alan@roojs.com>
Tue, 7 Oct 2014 10:49:23 +0000 (18:49 +0800)
pgsql/schema_create_table_statement.sql

index b41e6c7..1fc8006 100644 (file)
@@ -56,7 +56,7 @@ BEGIN
         IF column_record.attnum = 1 THEN
             v_table_ddl:='CREATE TABLE '||column_record.schema_name||'.'||column_record.table_name||' ();';
         ELSE
-            v_table_ddl:=v_table_ddl||',';
+            v_table_ddl:= 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' || v_table_ddl||';';
         END IF;
 
         IF column_record.attnum <= column_record.max_attnum THEN