logilab-database #100459 list_tables function should take into account the schema [validation pending]

The list_tables function does not take into account the schema,
and "SELECT tablename FROM pg_tables" returns all the tables.

Perhaps it should rather use:

cursor.execute("""SELECT c.relname AS table_name, u.usename AS owner, n.nspname AS schema
FROM pg_class c, pg_user u, pg_namespace n
WHERE c.relowner = u.usesysid
AND c.relkind = 'r'
AND c.relnamespace=n.oid
AND n.nspname != 'information_schema' AND n.nspname = '%s';""" % self.dbconfig['schema'] )

prioritynormal
typebug
done in1.13.0
load0.250
load left0.000
closed by#d9a772cdbb19 [postgres] Take schema into account in pg_table and pg_indexes requests
patch[postgres] Take schema into account in pg_table and pg_indexes requests [applied]