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

index 751e250..09df8f0 100644 (file)
@@ -4,6 +4,7 @@ $BODY$
 DECLARE
     v_table_ddl   text;
     column_record record;
+    v_colname text;
 BEGIN
     FOR column_record IN 
         SELECT 
@@ -60,6 +61,7 @@ BEGIN
         END IF;
         -- what does this do?
         
+         
         IF column_record.attnum <= column_record.max_attnum THEN
             v_table_ddl:= v_table_ddl||chr(10)||
                      'ALTER TABLE  '||column_record.schema_name||'.'||column_record.table_name||