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 | f test | chriskl | f | f | f (2 rows) Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
