JackpipE <pipe.jack@xxxxxxxxx> writes: > I'm selecting tables from my db using query: > SELECT > pg_stat_user_tables.relname > FROM > pg_stat_user_tables > WHERE > (pg_stat_user_tables.relname LIKE 'name_hosp_%') > The problem I have is that the table names returned by this query are > different from the ones in my db. That hardly seems likely, since the contents of that view are drawn directly from pg_class. Maybe you have some old schemas you've forgotten about? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general