POSTGRES: Uppercase table names

[expired user #8427]'s profile image [expired user #8427] posted 10 years ago in General Permalink
One of the databases I have seems to have all it's table names in uppercase. This is causing the left view to show no table names for that schema (show 0B). Other schemas are fine.

I can manually query the table contents using the Query, but would like to get the table list back. Since it appears to be that case mismatch between the information_schema list and the actual table names, is there any option or configuration to ignore case?

Rightly or wrongly, other table viewers like Razor don't have this issue.

Also, this database is read only for me so will not be able to do any table renames.

Thanks.
[expired user #8249]'s profile image [expired user #8249] posted 10 years ago Permalink
This issue came up a few weeks back and I thought Ansgar had mended it.
I have just tested here and Heidi seems quite happy to accept upper/lower case table names.
One difference I have noticed is that PGAdminIII allows the creation of a table with 0 columns, Heidi does not.
I believe Postgres allows tables with 0 columns but MySQL does not.
[expired user #8427]'s profile image [expired user #8427] posted 10 years ago Permalink
Fixed it. I changed the default timeout from 60 to 120 and seems to be working now. Kept getting statement timeout before that

Please login to leave a reply, or register at first.