Re: Select statement error in PostgreSQL 11.9

On Tue, Feb 21, 2023 at 12:24 PM Mohammed Afsar <vmdapsar(at)gmail(dot)com> wrote:

> When am doing select table column name copy paste getting below and if am
> typing colum name it is working could please check and confirm why it
> behaving.
>

If copy-paste is mis-behaving it is likely because of invisible characters
in whatever you are copying. If typing out the same query by hand results
in a working query this is evidence of the same.

>
> 1.User has all privileges and for other columns it is working fine.
>
> 2.charecter set also same and there is no extension
>
> 3.data type is character varying 255
>

Given that you have a basic syntax error none of those above observations
are helpful - you didn't get far enough into the parsing processing.
David J.