PostgreSql Query wont show tables form DB

[Csonytii]

Hello Everybody,
I Have the following part of code where i set my connection:

 QSqlDatabase DataBaseSample=QSqlDatabase::addDatabase("QPSQL","Sample");
 void setSample(){
         DataBaseSample.setDatabaseName("MyDbName");
         DataBaseSample.setUserName("myuser");
         DataBaseSample.setPassword("mypw");
         DataBaseSample.setHostName("mysite.xy");
         bool ok=DataBaseSample.open();
}
...

And after that i have the following code which is list of all the Tables from the given DB:

    QStringList Tableslist(int DBID){
        QSqlDatabase Current=db->ReturnDataBase(DBID);
        return Current.tables();
    }
...
    QSqlTableModel *model=MC.TableReturn(Choose);
    model->setTable(Tabletoshow);
    model->select();
    ui->tableView->setModel(model);
...

i wanted to check with wireshark where i got wrong but Postgre is encrypt better than mysql.
So code is working with MySql but not with PostgreSql what should i do?

Thank you for your answer

[SGaist]

Hi,

First thing would be to check the value returned by the open call and then check for errors on the other parts of your code.

[Csonytii]

@SGaist

According to qDebug that i didnt include in my code(i copied wrong):

 void setSample(){
         DataBaseSample.setDatabaseName("MyDbName");
         DataBaseSample.setUserName("myuser");
         DataBaseSample.setPassword("mypw");
         DataBaseSample.setHostName("mysite.xy");
         bool ok=DataBaseSample.open();
         qDebug()<<"Connection established:"<<ok;
         qDebug()<<DataBaseSample.lastError().text();
}

which is returns with true and ""

And i dont know any other problems because its work with mysql

[SGaist]

You should also check the QSqlTableModel::lastError just in case.

And maybe a silly question but are you sure that your PostgreSQL database contains the same content as your MySQL database ?

[Csonytii]

@SGaist

Sorry for late answer. LastError dont report any problem either. In the Tables completely the same as the MySQL table scheme... If this application wasn't be used widely, i would not care about PostgreSQL .
It is started to frustrate me that i spend days to configure sql databases in different configuration and they're mess with me indirectly...

[SGaist]

Then maybe something specific to PostgreSQL, are you using the default schema ?

In doubt, this small blog article gives a nice overview of the PostgreSQL schema.

[VRonin]

Can you show us the body of db->ReturnDataBase(DBID); and MC.TableReturn(Choose);?

[Csonytii]

@SGaist
i have a schame named public. with DataGrip show both way,

select * 
from  public.Table
--or simply Table

@VRonin

QSqlTableModel *TableReturn(int DBID){

        QSqlTableModel *model = new QSqlTableModel(nullptr,db->ReturnDataBase(DBID));
        qDebug()<<model->tableName();
        return model;
    }

  QSqlDatabase ReturnDataBase(int DBID){
         QSqlDatabase db;
         if(DBID==0){
               setmydb1();
            db=QSqlDatabase::database("mydb0");
            return db;
         }else if (DBID==1) {
                setmydb1();
             db=QSqlDatabase::database("mydb1");
             return db;
         }
        ...
            return db;

     }

i dont know how efficient is this.

[SGaist]

What does setmydb1 do ? It's called for both databases.

[Csonytii]

@SGaist

setmydb1 is like SetSample with different cities, (i don't want to use real data if that is not a problem). And i know it is harder to help when i do stuff like this, so sorry about that
EDIT1:I finally figured out... Sample is not equal sample... I named the DB as Sample and i wanted to return with sample
EDIT2: now its list the tables, but not the content of it...
EDIT3: for example model->setTable("\"City\""); does the trick

Thank you for your answers!

[Csonytii]

This post is deleted!

[SGaist]

Are you sure you setup the database properly ?

I find it very strange that you have to add double quotes around the table name to be able to access its content.

[Csonytii]

@SGaist
The Double quotes used by pgadmin 4 and DataGrip too. So probably the same as the `tablename` in the Mysql syntax but its obligatory in PostgreSQL

[SGaist]

After verification, here you can find why double quotes should be used.

[Csonytii]

@SGaist

Thanks For you Help