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

Поиск

Список

Период

Сортировка

where clause not working through psql command line client

От

rajan

Дата:

01 февраля 2019 г., 10:35:03

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

Дата:

01 февраля 2019 г., 10:37:47

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

Дата:

01 февраля 2019 г., 11:24:57

Thanks a lot, Amul. 



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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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

where clause not working through psql command line client

Re: where clause not working through psql command line client

Re: where clause not working through psql command line client