Re: Select statement error in PostgreSQL 11.9 - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Select statement error in PostgreSQL 11.9
Date
Msg-id CAKFQuwauVTrLh9Hnr7nVaV=+kR7SSeBPXOuAP4CQoZaKtaWJFA@mail.gmail.com
Whole thread Raw
In response to Select statement error in PostgreSQL 11.9  (Mohammed Afsar <vmdapsar@gmail.com>)
List pgsql-admin
On Tue, Feb 21, 2023 at 12:24 PM Mohammed Afsar <vmdapsar@gmail.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.

pgsql-admin by date:

Previous
From: Mohammed Afsar
Date:
Subject: Select statement error in PostgreSQL 11.9
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump: error