pg_tables and schemas

Tom,

Does the pg_tables view need to be fixed now that we have schemas?

Yep:

test2=# create schema a;
CREATE SCHEMA
test2=# create schema b;
CREATE SCHEMA
test2=# create table a.test (a int4);
CREATE TABLE
test2=# create table b.test (b int4);
CREATE TABLE
test2=# select * from pg_tables where tablename not like 'pg_%';tablename | tableowner | hasindexes | hasrules |
hastriggers
-----------+------------+------------+----------+-------------test      | chriskl    | f          | f        | ftest
 | chriskl    | f          | f        | f
 
(2 rows)

Chris