pg_stat_user_tables
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. Not all of them but 10%-20%. The
common problem I noticed is adding "_" at the end of table name and
truncating name "hospital" to "hosp".
Anyone ever had similar problem? Any other way to get list of table
names?
Thanks,
JP
JackpipE <pipe.jack@gmail.com> 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