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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
