Postgresql - Error Message

This message is received in response to the query SELECT * FROM JA_Party. I would like to know
what am I doing wrong.
ERROR: relation "ja_party" does not exist
LINE 1: SELECT * FROM JA_Party
^
********** Error **********
ERROR: relation "ja_party" does not exist
SQL state: 42P01
Character: 15

Questions by ggnpostgresql

Showing Answers 1 - 10 of 10 Answers

murali

  • Dec 1st, 2014
 

Case Sensitive or the table does not exists.

  Was this answer useful?  Yes

devendra

  • Apr 13th, 2015
 

table does not exist.

  Was this answer useful?  Yes

Sanu Das

  • May 29th, 2015
 

Table does not exists

  Was this answer useful?  Yes

Ronak

  • Jul 2nd, 2015
 

In Postgre SQL , we need to write schema name.table name so please try SELECT * FROM (SCHEMA_NAME).JA_Party;
Regards,
Ronak

  Was this answer useful?  Yes

mitz

  • Aug 22nd, 2016
 

It means that the table (relation) dosen't exists in the public schema (the default schema)

  Was this answer useful?  Yes

Monalee

  • Dec 29th, 2016
 

The query executed for database does not have table named "JA_party"
Here be careful that PostgreSQL is case sensitive.

  Was this answer useful?  Yes

Manoj Yadav

  • Mar 8th, 2017
 

It means that the table doesn't exists in the public schema

  Was this answer useful?  Yes

Prachita Raut

  • Jun 14th, 2017
 

This table JA_Party doesnt exist in connected dB

  Was this answer useful?  Yes

Atul Mahajan

  • Jun 16th, 2017
 

table ja_party does not exit

  Was this answer useful?  Yes

Abhishek

  • Aug 12th, 2020
 

There are three possibilities to this.
1. The table ja_party does not exist in the connected database.
2. Schema having ja_party table has not be set in schema search_path.
3. Its possible that the table owner is different than the connected role.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions