Re: Select statement error in PostgreSQL 11.9

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Select statement error in PostgreSQL 11.9
Дата
Msg-id CAKFQuwauVTrLh9Hnr7nVaV=+kR7SSeBPXOuAP4CQoZaKtaWJFA@mail.gmail.com
обсуждение исходный текст
Ответ на Select statement error in PostgreSQL 11.9  (Mohammed Afsar <vmdapsar@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Mohammed Afsar
Дата:
Сообщение: Select statement error in PostgreSQL 11.9
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump: error