Iqbal Singh

• Nov 14th, 2017

Using Analyze or Vaccum Analyze Command, it is also updated by some of DDL, like create Index.

Shankar Kotamarthy

 Profile Answers by Shankar Kotamarthy Questions by Shankar Kotamarthy

• Sep 28th, 2013

Vacuum with the option Analyze is used to update statistics in Postgresql
VACUUM ANALYZE ; is the syntax.

Answer Question  Select Best Answer

List out the disadvantages of PostgreSql Database.

Daniel Prince

• Nov 21st, 2017

You Can try Bucardo Replication or Streaming Replication.

gakorde

 Profile Answers by gakorde Questions by gakorde

• Jul 5th, 2010

Replication is not that much powerful as compared to other databases.

Answer Question  Select Best Answer

supriya

• Dec 8th, 2017

You can set isolation level as read uncommited.

santhanapandi

• Jul 1st, 2013

The SQL standard defines four levels of transaction isolation in terms of three phenomena that must be prevented between concurrent transactions. These undesirable phenomena are: Dirty read A transac...

Answer Question  Select Best Answer

Md Ikbal Hossain

• Jan 30th, 2018

Navicat Premium

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

PgAdmin

Answer Question  Select Best Answer

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

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.

Atul Mahajan

• Jun 16th, 2017

Table ja_party does not exit

Answer Question  Select Best Answer

RUCHI TYAGI

• Oct 8th, 2020

Inverted file is an index data structure used for mapping content to its location to a database file with in a document or in set of documents

Answer Question  Select Best Answer