Not able to access SELECT * FROM ao_60db71_issueranking table from postgres database

Question

When I write the following query in postgres Dataase, it gives me error that ao_60db71_issueranking table does not exist

SELECT * FROM ao_60db71_issueranking where issue_id in (SELECT id FROM jiraissue)

Please help.

rrudnicki · Answer

Hi Tushar,

With AO Tables, usually I need to put the table's name between " ". For example:

confluence573=# select * from AO_7CDE43_RECIPIENT;

ERROR:  relation "ao_7cde43_recipient" does not exist

LINE 1: select * from AO_7CDE43_RECIPIENT;

confluence573=#

confluence573=# select * from "AO_7CDE43_RECIPIENT";

----+------------+-----------------+---------------+-------------+-----------+------

(0 rows)
confluence573=#

Regards,

Renato Rudnicki

Boris Berenberg · Answer

Try AO_60DB71_ISSUERANKING instead.