# PostgreSQL uppercase table names

**URL:** <https://forum.inductiveautomation.com/t/postgresql-uppercase-table-names/9356>\
**Category:** Ignition\
**Created:** [November 19, 2014, 3:32pm UTC](https://forum.inductiveautomation.com/t/postgresql-uppercase-table-names/9356 "2014-11-19T15:32:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kwj](https://avatars.discourse-cdn.com/v4/letter/k/838e76/32.png) [@kwj](https://forum.inductiveautomation.com/u/kwj)\
**Post date:** [November 19, 2014, 3:32pm UTC](https://forum.inductiveautomation.com/t/postgresql-uppercase-table-names/9356/1 "2014-11-19T15:32:44Z")

</div>

It seems there is some issue between Ignition and PostgreSQL involving uppercase table names. If I create a table named “TESTdata” and do a database browse in ignition, I will get an error stating there is no relation “testdata”. The easy workaround is just to not use capital letters in table names, but it would be nice to not have to do this.

---

<div class="post-metadata">

**Author:** ![Sergey.Danilov](https://avatars.discourse-cdn.com/v4/letter/s/7cd45c/32.png) [@Sergey.Danilov](https://forum.inductiveautomation.com/u/Sergey.Danilov)\
**Post date:** [November 21, 2014, 8:25am UTC](https://forum.inductiveautomation.com/t/postgresql-uppercase-table-names/9356/2 "2014-11-21T08:25:50Z")

</div>

example: SELECT \* FROM “TESTdata”

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 21, 2014, 11:55am UTC](https://forum.inductiveautomation.com/t/postgresql-uppercase-table-names/9356/3 "2014-11-21T11:55:22Z")

</div>

I had sort of the same issue when migrating to a new MySQL database. It used to be case agnostic, but it appears that’s no longer the case (Doh! Pun was not intended, but I’m going to keep it anyway).