Re: BUG #5143: psql \df doesn't recogize patterns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Piotr Wolinski <pwolinski(at)dfqs(dot)pl>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5143: psql \df doesn't recogize patterns
Date: 2009-10-28 15:50:28
Message-ID: 22077.1256745028@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Piotr Wolinski wrote:
>> It looks like pqsl \df command doesn't recognize regexp pattern.

> No, it doesn't use regexes, only shell patterns (* and ? only).

The case does work for \d though. It appears that \df is passing
force_escape = true to processSQLNamePattern. That's probably a
bug --- it makes sense for \do, but function names aren't special
so there's no reason to prevent people from using regexp patterns.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-10-28 18:11:27 Re: BUG #5143: psql \df doesn't recogize patterns
Previous Message Piotr Woliński 2009-10-28 15:43:43 Re: BUG #5143: psql \df doesn't recogize patterns