From adecff6d16c8ed27ebef63102a57f3dc3dd68e9a Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 27 Feb 2012 12:41:38 +0800 Subject: [PATCH] dbgenerate.js --- dbgenerate.js | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/dbgenerate.js b/dbgenerate.js index 53db1f75d..360c42508 100644 --- a/dbgenerate.js +++ b/dbgenerate.js @@ -239,9 +239,9 @@ switch(cfg.DBTYPE) { "AND pg_catalog.pg_table_is_visible(c.oid) "; query_describe_table = "SELECT " + "attname as Field, " + - "typname " + - "FROM pg_attribute , pg_type WHERE " + - "typrelid=attrelid AND typname = '%s' "; + ", opcname , atttypmod " + + "FROM pg_attribute,pg_type, pg_opclass " + + " WHERE attrelid=typrelid AND atttypid=opcdeftype AND typname= '%s' "; break; /* "Field": "province", -- 2.39.2