parth

• Aug 15th, 2017

List all Databases

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

It will display list of DB's

Answer Question  Select Best Answer

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

parth

• Aug 15th, 2017

It is like search operator.

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

ILIKE or ~~*

Answer Question  Select Best Answer

What are the common bugs found while migrating to MySQL db to Postgre?

monaleeb

 Profile Answers by monaleeb Questions by monaleeb

• Dec 29th, 2016

Most time it gives issues for Object data type like Enum, Boolean, Date as Postgres uses it as Object which not concept in MySQL.

VIjay

• Aug 4th, 2014

You may get unicode UTF-8 character decoding problem when migrating from MySQL to PostgreSQL .....

Answer Question  Select Best Answer

sugandh

• Jul 13th, 2017

Maximum Table Size 32 TB

Manoj Yadav

• Mar 8th, 2017

Maximum table size = 32 TB

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