Thread: Select statement error in PostgreSQL 11.9
Dear Team,
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.
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
You are now connected to database "stage" as user "staguser".
stage=> select sr_name from table_user;
ERROR: syntax error at or near "select sr_name from table_user"
LINE 1: select sr_name from table_user;
Regards,
Mohammed Afsar
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.
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