[Qgis-developer] Error for postgres's provider when table(statement SELECT ) is outside public's schema

[Noli Sicad]

In spatilalite, I use this query (below) now but still I got the same error.

Select * from Regions where NAME = 'VENETO'
'

On 12/16/10, Giuseppe Sucameli <sucameli at faunalia.it> wrote:
> Hi Noli,
> this one it's no a plugin error, it's a query syntax error.
> On Thu, Dec 16, 2010 at 5:33 AM, Noli Sicad <nsicad at gmail.com> wrote:
>
>> Select * from Regions where NAME = "VENETO"
>>
> You still use double quotes wrapping values, instead you must use single
> quotes.
> Double quotes are for identifiers like table name, schema name and column
> name.
>