Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The above error occurs when there is no table exists with the given name. But in this case, the table name with "inventory" exists but as the table is in public schema it was resulting results in an errorthe same error as the table doesn't exists.

Environment

VersionServer 6.15.4
ApplicationConfluence
App Version10.0.0
Database TypePostgreSql

...

Panel
bgColor#f9ecc5

As the table is in public schema in PostgreSQL, it should be mentioned in the select statement

Image RemovedImage Added


Solution

Code Block
themeMidnight
SELECT * FROM public. "inventory" ;

Result:

It will display the data in the table inventory:

...