Mercurial > hg > ChinaGisRestApi

changeset 100:4c125fbb2c5b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Views are listed in "getListOfUserTables"
author fknauft
date Tue, 01 Feb 2011 14:48:27 +0100
parents 19983d06abdb
children 7ed1d9c6122e
files RestDbGisApi.py
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/RestDbGisApi.py	Wed Jan 26 17:29:22 2011 +0100
+++ b/RestDbGisApi.py	Tue Feb 01 14:48:27 2011 +0100
@@ -127,8 +127,10 @@
         """return list of tables"""
         logging.debug("getlistofusertables")
         # get list of db tables
-        qstr = """SELECT t.table_name FROM information_schema.tables t, public.gis_table_meta m WHERE t.table_type = 'BASE TABLE' 
-                    AND t.table_schema = %s AND t.table_name = m.table_name ORDER BY 1"""
+#        qstr = """SELECT t.table_name FROM information_schema.tables t, public.gis_table_meta m WHERE t.table_type = 'BASE TABLE' 
+#                    AND t.table_schema = %s AND t.table_name = m.table_name ORDER BY 1"""
+        qstr = """SELECT t.table_name FROM information_schema.tables t, public.gis_table_meta m 
+                  WHERE  t.table_schema = %s AND t.table_name = m.table_name ORDER BY 1"""
         
         data=self.executeSQL(qstr,(schema,))
         return data