Re: where clause not working through psql command line client

Thanks a lot, Amul. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: where clause not working through psql command line client

You forgot to quote pg_toast_22345, try this: psql -c " select * from pg_class where relname = 'pg_toast_22345' " Regards, Amul On Fri, Feb 1, 2019 at 4:05 PM rajan wrote: > postgres@Server2[DEV][backup] $ psql -c 'select * from pg_class where > relname > = pg_toast_22345' > ERROR: column "

where clause not working through psql command line client

postgres@Server2[DEV][backup] $ psql -c 'select * from pg_class where relname = pg_toast_22345' ERROR: column "pg_toast_16387" does not exist LINE 1: select * from pg_class where relname = pg_toast_22345 - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers