Re: where clause not working through psql command line client

From: amul sul <sulamul(at)gmail(dot)com>
To: rajan <vgmonnet(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: where clause not working through psql command line client
Date: 2019-02-01 10:37:47
Message-ID: CAAJ_b95X26mmAO28pO-hC_fTUc=9ZJ+wYEqp_dCJy6a=HUeCdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmail(dot)com> wrote:

> postgres(at)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
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2019-02-01 10:46:35 Re: LD_LIBRARY_PATH_RPATH
Previous Message rajan 2019-02-01 10:35:03 where clause not working through psql command line client