> Just want to know. > > Now we are passing GetName() to qtDbString() and to form the complete query > we need to use qtDbString() to compare the string. > > We have added below string. > > wxString sql = wxT("SELECT count(*) FROM pg_matviews WHERE matviewname = ") > + qtDbString(this->GetName()) + wxT(" AND schemaname = ") + > qtDbString(this->GetSchema()->GetName()); > > Is it correct ?
I'd expect you to be using GetQuotedIdentifier() there. For a view and schema, the identifier is the name anyway.
-- Dave Page Chief Architect, Tools & Installers EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company