# HG changeset patch
# User fknauft
# Date 1296568107 -3600
# Node ID 4c125fbb2c5b02197fca66f31b7939a3da10c62e
# Parent  19983d06abdbac1c20844df185dda4a9cee7104c
Views are listed in "getListOfUserTables"

diff -r 19983d06abdb -r 4c125fbb2c5b RestDbGisApi.py
--- 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