EDB Home Postgres Tutorials Documentation

Ghost Tables

Highlighted
neiljo10
Level 2 Adventurer
‎03-08-2019 03:54 AM
‎03-08-2019 03:54 AM

Ghost Tables

Hi,

 

I am trying to create a table which throws the error of an existing table but when I use the select command to view it throws does not exist error.

 

I am using DBeaver client tool for PostgreSQL.

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 REPLY 1
Highlighted
ajinkya
Level 3 Adventurer
‎03-08-2019 07:25 AM
‎03-08-2019 07:25 AM

Re: Ghost Tables

Hi,

 

Please make sure you are accessing the correct schema name while creating/selecting the table.

In DBeaver on left side you can check the list of tables available in the database, screen shot is attached. Check if the table is present there.

Kindly share the commands you are using for creating and selecting the table.

 

--

Ajinkya

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks