Jira _postgres database

Jeffrey Mattews

I have a column that is in the database but i can not find the table which it resides. Is there such a query, given the column name for ex.(zeltech) which can be located in 1 out of 50 tables... how can i find its location? For ex. Oracle located its objects by searching a table name DUAL. The syntax looks like this: "select object from dual;"

Nic Brough -Adaptavist-

If you can't find it in the database, how do you know it's in there?

Could you explain where you're getting the idea that there's a column? ex.(zeltech) means nothing to us, doesn't help us work out what you're talking about. Could you tell us what you're seeing on a Jira screen and where?