Thread: 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-f1928748.html
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 <vgmonnet@gmail.com> wrote:
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-f1928748.html
Thanks a lot, Amul. ----- -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html