Postgres Pro
Downloads
Home   >   mailing lists

Re: where clause not working through psql command line client - Mailing list pgsql-hackers

From amul sul
Subject Re: where clause not working through psql command line client
Date
Msg-id CAAJ_b95X26mmAO28pO-hC_fTUc=9ZJ+wYEqp_dCJy6a=HUeCdw@mail.gmail.com
Whole thread Raw
In response to where clause not working through psql command line client  (rajan <vgmonnet@gmail.com>)
Responses Re: where clause not working through psql command line client  (rajan <vgmonnet@gmail.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: rajan
Date:
Subject: where clause not working through psql command line client
Next
From: Andrew Gierth
Date:
Subject: Re: LD_LIBRARY_PATH_RPATH