pgjdbc: PgDatabaseMetaData doesn't return tables if schema is pg_temp_*
I’m using SET search_path TO pg_temp in my tests to isolate them and create tables with sample data. However, reading metadata fails because result set is essentially empty when trying to get it from temp schemas.
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Comments: 17 (7 by maintainers)
Specifying “TEMPORARY TABLE” instead of “TABLE” works. I have to put something like “if (currentSchema.startsWith(“pg_temp_”))” but it’s a small detail. Thanks!