I can't open the table PostgreSQL

[Mikeeeeee]

Hi!
I can't open table PostgreSQL

QSqlDatabase SearchDB = QSqlDatabase::addDatabase("QPSQL");
SearchDB.setDatabaseName("TestDB1")
SearchDB.setUserName("postgres");
SearchDB.setPassword("1111");
SearchDB.setPort(5432);
if (SearchDB.open()) {qDebug()<<"db is opened";} else {qDebug()<<"db not opened";}

Here qDebag report: "db is opened"

qDebug()<<SearchDB.tables();

Here qDebag report: ("Test2", "123")

QSqlTableModel *SearchTableModel = new QSqlTableModel(this);
SearchTableModel->setTable("Test2");
SearchTableModel->select(); 
qDebug()<<SearchTableModel->lastError();

Table Test2 not opened.
Here qDebag report: SqlError("", "Unable to find table Test2", "")
Howe can I open the table PostgreSQL?

[dheerendra]

Error indicates that Test2 table is not there. Can you recheck whether table exist ?

[jsulm]

@Mikeeeeee Did you verify that the database has a table named Test2?

[Mikeeeeee]

I created this table in the database.
Query: qDebug()<<SearchDB.tables();
report: ("Test2", "123")
The table is definitely there

[SGaist]

Hi,

Might be a silly question but are you sure the database connection is opened before the your create the QSqlTableModel object ?

[Christian Ehrlicher]

And are you sure the table is not inside a schema? tables() only returns the table names without the schema iirc.

[Mikeeeeee]

Yes.
Upper my code.!

[Stoyan]

@Mikeeeeee
You can try to specify also database:

QSqlTableModel *SearchTableModel = new QSqlTableModel(this, SearchDB);

Do you use QSqlDatabase::addDatabase("QPSQL") anywhere else in your program?

[Mikeeeeee]

It's not work: QSqlTableModel *SearchTableModel = new QSqlTableModel(this, SearchDB);
I use heare:

QSqlDatabase SearchDB = QSqlDatabase::addDatabase("QPSQL");

[Christian Ehrlicher]

Postgres is only case-sensitive when the identifier is escaped. Otherwise all is converted to lowercase. See https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
Therefore you have to use

SearchTableModel->setTable("\"Test2\"");

Or simply use don't use upper-case in your table and column-names.

[arso96]

It drove me crazy, was about to post the same thread
https://tgw.onl/digitalocean/ , https://tgw.onl/siteground/ , https://tgw.onl/ipage/