dbgenerate.js
authorAlan Knowles <alan@akbkhome.com>
Mon, 27 Feb 2012 04:40:52 +0000 (12:40 +0800)
committerAlan Knowles <alan@akbkhome.com>
Mon, 27 Feb 2012 04:40:52 +0000 (12:40 +0800)
dbgenerate.js

index afc606a..53db1f7 100644 (file)
@@ -238,12 +238,19 @@ switch(cfg.DBTYPE) {
             "WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')" +
             "AND pg_catalog.pg_table_is_visible(c.oid) ";
          query_describe_table =  "SELECT " + 
-                "attname , typname FROM pg_attribute , pg_type WHERE   " +
+                "attname as Field, " +
+                "typname  " +
+                "FROM pg_attribute , pg_type WHERE   " +
                 "typrelid=attrelid AND typname = '%s' ";
         break;
-
-    
-    
+/*
+           "Field": "province",
+        "Type": "varchar(255)",
+        "Null": "NO",
+        "Key": null,
+        "Default": null,
+        "Extra": 
+*/  
 }