Обсуждение: where clause not working through psql command line client

Поиск
Список
Период
Сортировка

where clause not working through psql command line client

От
rajan
Дата:
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

Re: where clause not working through psql command line client

От
amul sul
Дата:
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

Re: where clause not working through psql command line client

От
rajan
Дата:
Thanks a lot, Amul. 



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