From: Alan Knowles <alan@roojs.com>
Date: Tue, 7 Oct 2014 10:48:31 +0000 (+0800)
Subject: pgsql/schema_create_table_statement.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=d219e6b9ccff7857ad99f78cbb939339fdd872a5

pgsql/schema_create_table_statement.sql
---

diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql
index 228f73f3..b41e6c72 100644
--- a/pgsql/schema_create_table_statement.sql
+++ b/pgsql/schema_create_table_statement.sql
@@ -1,4 +1,4 @@
-CREATE OR REPLACE FUNCTION generate_create_table_statement(p_table_name varchar)
+CREATE OR REPLACE FUNCTION schema_create_table_statement(p_table_name varchar)
   RETURNS text AS
 $BODY$
 DECLARE
@@ -54,7 +54,7 @@ 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||' ();';
         ELSE
             v_table_ddl:=v_table_ddl||',';
         END IF;