pg_stat_user_tables

Started by JackpipEabout 18 years ago2 messagesgeneral
Jump to latest
#1JackpipE
pipe.jack@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: JackpipE (#1)
Re: pg_stat_user_tables

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